Check for duplicate values when adding data using jQuery AJAX in ASP.Net

usman

SOLVED CLOSED ACTIVE ANSWERED
User: usman
Posted: on Jul 29, 2015 12:34 AM
Forum: Data Controls
Answer: 1
Views: 17905

Below is my function which insert textbox value into grid view .this work fine .

Now I want to compare grid view row with textbox value if already exist in grid view then it give me massage already exist with same name means duplicate data cannot insert into grid view. please help me I will code but can’t find the solution.

<script type="text/javascript">
          $(function checkuser()
{
                  //          $(function () {
                  //              $("[id*=btnAddRow]").click(function () {
                  var operator = $("[id*=txtoperator]").val();
                  var value1 = $("[id*= txtvalue1]").val();
                  var value2  = $("[id*= txtvalue2]").val();
                  var total = $("[id*= txttotal]").val();
                  if (operator != "" && value1 != "" && value2 != "" && total != "") {
                
                     row = $("[id*=data_gridview] tr:last-child").clone(true);
                      $("td:nth-child(2)", row).html(operator);
                      $("td:nth-child(3)", row).html(value1);
                      $("td:nth-child(4)", row).html(value2);
                      $("td:nth-child(5)", row).html(total);
////////piece code for check the row alredy exist/////////
                    if $('[id*= data_gridview]').('tr:has(td)')=                $("td:nth-child(2)", row).html(operator) &&                       $("td:nth-child(3)", row).html(value1) &&  $("td:nth-child(4)", row).html(value2))

{
  alert("The Value already Exist ");
}


///////////////////////////////////////////////////////////////

                      $("[id*=data_gridview] tbody tr:first").after(row);

                  }
                  $("[id*=txtoperator]").val('');
                  $("[id*= txtvalue1]").val('');
                  $("[id*= txtvalue2]").val('');
                  $("[id*= txttotal]").val('');
                  return false;
                  }
              };

C# Code……./////////////////////
            if (!this.IsPostBack)
            {
                DataTable dt = new DataTable();
                dt.Columns.AddRange(new DataColumn[4] { new DataColumn("Opertor ",             typeof(string)),
                              
                              
                               
                                 new DataColumn("Value1", typeof(string)),
                                 new DataColumn("Value2", typeof(string)),
                                  new DataColumn("Result", typeof(string)),


                dt.Rows.Add(0, "", "", "", "");



                data_gridview.DataSource = dt;
                trans_gridview.DataBind();



            }

Please help me to solve that problem.

Shashika...

0 2

Reply
ANSWER
User: Shashikant
Replied: on Jul 29, 2015 04:35 AM
Report

Hi usman,

Here I have created sample that full-fill your requirement.

HTML

<div>
    <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
    <script type="text/javascript">
        function AddRow() {
            var operator = $("[id*=txtoperator]").val();
            var value1 = $("[id*= txtvalue1]").val();
            var value2 = $("[id*= txtvalue2]").val();
            var total = $("[id*= txttotal]").val();
            if (operator != "" && value1 != "" && value2 != "" && total != "") {
                var gridRows = $("[id *= data_gridview] tr")
                var isExist = false;
                gridRows.each(function () {
                    if ($("td:nth-child(1)", $(this)).html() == operator && $("td:nth-child(2)", $(this)).html() == value1 && $("td:nth-child(3)", $(this)).html() == value2 && $("td:nth-child(4)", $(this)).html() == total) {
                        isExist = true;
                    }
                });
                if (!isExist) {
                    row = $("[id*=data_gridview] tr:last-child").clone(true);
                    $("td:nth-child(1)", row).html(operator);
                    $("td:nth-child(2)", row).html(value1);
                    $("td:nth-child(3)", row).html(value2);
                    $("td:nth-child(4)", row).html(total)
                    $("[id*=data_gridview] tbody tr:first").after(row);
                    $("[id*=txtoperator]").val('');
                    $("[id*= txtvalue1]").val('');
                    $("[id*= txtvalue2]").val('');
                    $("[id*= txttotal]").val('');
                } else {
                    alert("The Value already Exist ");
                }
            }
            return false;
        };         
    </script>
    <asp:TextBox ID="txtoperator" runat="server" class="myclass" Height="16px" Width="50px"
        MaxLength="5"></asp:TextBox>
    <asp:TextBox ID="txtvalue1" runat="server" class="myclass" Height="16px" Width="50px"
        MaxLength="5"></asp:TextBox>
    <asp:TextBox ID="txtvalue2" runat="server" class="myclass" Height="16px" Width="50px"
        MaxLength="5"></asp:TextBox>
    <asp:TextBox ID="txttotal" runat="server" class="myclass" Height="16px" Width="50px"
        MaxLength="5"></asp:TextBox>
    <br />
    <br />
    <asp:Button ID="btnAddRow" Text="Add Row" runat="server" OnClientClick="return AddRow();" />
    <asp:GridView ID="data_gridview" runat="server" />
</div>

Code

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
        {
            DataTable dt = new DataTable();
            dt.Columns.AddRange(new DataColumn[4] { new DataColumn("Opertor ",typeof(string)),
                                new DataColumn("Value1", typeof(string)),
                                new DataColumn("Value2", typeof(string)),
                                new DataColumn("Result", typeof(string))});
            dt.Rows.Add("", "", "", "");
            data_gridview.DataSource = dt;
            data_gridview.DataBind();
        }
}

Screenshot

Shashika...

0 4

Reply
User: Shashikant
Replied: on Jul 30, 2015 01:40 AM
Report

Instead of saying thanks mark the reply or replies(if multiple) that helped as Answer.

Check for duplicate values when adding data using jQuery AJAX in ASP.Net

Company

Explore

Follow us

Contact Us