How to compare rows of two gridview and delete if no matching row found in ASP.Net

tyt2314

SOLVED CLOSED ACTIVE ANSWERED
User: tyt2314
Posted: on Jul 22, 2016 07:05 AM
Forum: Data Controls
Answer: 1
Views: 6284

 protected void OnRowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        string strConnString = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
        SqlConnection con = new SqlConnection(strConnString);
        DataTable dt = new DataTable();
        try
        {
     
        }
        catch(Exception ex)
        {

        }
        using (SqlConnection conn = new SqlConnection(strConnString))
        {


            int selectedRow = e.RowIndex;

            GridViewRow theRow = GridView1.Rows[selectedRow];
            string str = ("Delete TDLoanRate where Id=@id");
            SqlCommand insert = new SqlCommand(str, con);

            insert.Parameters.AddWithValue("@id", Convert.ToInt32(theRow.Cells[0].Text));

            using (SqlDataAdapter sda = new SqlDataAdapter())
            {
                insert.Connection = con;
                con.Open();
                sda.SelectCommand = insert;
                sda.Fill(dt);
                GridView1.DataSource = dt;
                GridView1.DataBind();
            }
            con.Open();
            con.Close();
        }
      
    }

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" OnSelectedIndexChanged="GridView1_SelectedIndexChanged" Width="371px" PageSize="5" AllowSorting="True" onsorting="GridView1_Sorting" OnRowDeleting="OnRowDeleting">
   <Columns> 
        <asp:BoundField HtmlEncode="false"  DataField="Id" HeaderText='<img src="Images/updown.png"/>Id' SortExpression="Id" />
        <asp:BoundField DataField="LoanType" HeaderText="LoanType" SortExpression="LoanType" />
        <asp:BoundField DataField="LoanTerm" HeaderText="Term(Years)" SortExpression="LoanTerm" />
        <asp:BoundField DataField="LoanRate" HeaderText="LoanRate" SortExpression="LoanRate" />
        <asp:BoundField DataField="LoanEffectFrom" HeaderText="Loan Effect From" SortExpression="LoanEffectFrom" />
        <asp:BoundField DataField="LoanMaturity" HeaderText="Loan Maturity Date" SortExpression="LoanMaturity" />
        <asp:CommandField HeaderText="Edit" SelectText="Edit" ShowSelectButton="True" />
        <asp:CommandField HeaderText="Delete" ShowDeleteButton="True" ShowHeader="True" />
    </Columns>
</asp:GridView>

<asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" OnSelectedIndexChanged="GridView2_SelectedIndexChanged" OnRowEditing=" GridView2_RowEditing" OnRowDataBound="GridView2_RowDataBound" >
      <Columns>
         <asp:BoundField DataField="id" HeaderText="Id" SortExpression="id" />
         <asp:BoundField DataField="principal" HeaderText="Principal" SortExpression="principal" />
         <asp:BoundField DataField="LoanTerm" HeaderText="Loan Term" SortExpression="LoanTerm" />
         <asp:BoundField DataField="LoanEffectFrom" HeaderText="Loan Start" SortExpression="LoanEffectFrom" />
         <asp:BoundField DataField="LoanInterest" HeaderText="Interest Payable" SortExpression="LoanInterest" />
         <asp:BoundField DataField="LoanMaturity" HeaderText="Loan End" SortExpression="LoanMaturity" />
         <asp:BoundField DataField="LoanMaturedAmt" HeaderText="Total Amount " SortExpression="LoanMaturedAmt" />
         <asp:BoundField DataField="LoanRate" HeaderText="Rate" SortExpression="LoanRate" />
         <asp:BoundField DataField="Loanloantype" HeaderText="Loan Type" SortExpression="Loanloantype" />
         <asp:BoundField DataField="Loanmonthlyp" HeaderText="Monthly Payment" SortExpression="Loanmonthlyp" />
         <asp:BoundField DataField="apply" HeaderText="Apply" SortExpression="apply" NullDisplayText="Not Seen" />
         <asp:CommandField HeaderText="Check" SelectText="Check" ShowHeader="True" ShowSelectButton="True" />
      </Columns>
</asp:GridView>

I want to be able to delete a row in gridview1 if there are no rows in gridview2 which has exactly the same values as gridview1

What should I put in onRowDeleting?

Download FREE API for Word, Excel and PDF in ASP.Net

AnandM

0 3

Reply
ANSWER
User: AnandM
Replied: on Jul 25, 2016 04:30 AM
Report

Hi tyt2314,

I have created sample which fullfill your requirement

protected void OnRowDeleting(object sender, GridViewDeleteEventArgs e)
{
    string Id = this.GridView1.Rows[e.RowIndex].Cells[0].Text.Trim();
    string loanType = this.GridView1.Rows[e.RowIndex].Cells[1].Text.Trim();
    string loanTerm = this.GridView1.Rows[e.RowIndex].Cells[2].Text.Trim();
    string loanRate = this.GridView1.Rows[e.RowIndex].Cells[3].Text.Trim();
    string loanEffectFrom = this.GridView1.Rows[e.RowIndex].Cells[4].Text.Trim();
    string loanMaturity = this.GridView1.Rows[e.RowIndex].Cells[5].Text.Trim();

    for (int i = 0; i < GridView2.Rows.Count; i++)
    {
        string Id1 = this.GridView2.Rows[i].Cells[0].Text;
        string loanTerm1 = this.GridView2.Rows[i].Cells[2].Text;
        string loanEffectFrom1 = this.GridView2.Rows[i].Cells[3].Text;
        string loanType1 = this.GridView2.Rows[i].Cells[9].Text;
        string loanRate1 = this.GridView2.Rows[i].Cells[8].Text;
        string loanMaturity1 = this.GridView2.Rows[i].Cells[5].Text;
        if (Id1 == Id && loanType1 == loanType && loanTerm1 == loanTerm && loanRate1 == loanRate && loanEffectFrom1 == loanEffectFrom && loanMaturity1 == loanMaturity)
        {
            string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
            DataTable da = new DataTable();
            using (SqlConnection conn = new SqlConnection(constr))
            {
                string strQuery = "Delete FROM Customers where CustomerID = @Id";//Your delete query
                SqlCommand cmd = new SqlCommand(strQuery);
                cmd.Parameters.AddWithValue("@Id", Id);
                using (SqlDataAdapter sda = new SqlDataAdapter())
                {
                    cmd.Connection = conn;
                    conn.Open();
                    sda.SelectCommand = cmd;
                    sda.Fill(da);
                    GridView1.DataSource = da;
                    GridView1.DataBind();
                }
            }
        }
    }
}

Hope this works for you

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

How to compare rows of two gridview and delete if no matching row found in ASP.Net

Company

Explore

Follow us

Contact Us