Deleting Row From Grid View

Syed Taha

6y3k.NET

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)

{

DataTable dt = new DataTable();

dt.Columns.Add(new DataColumn("EmpId", typeof(string)));

dt.Columns.Add(new DataColumn("EmpName", typeof(string)));

dt.Columns.Add(new DataColumn("DeptName", typeof(string)));

dt.Columns.Add(new DataColumn("EmpAddress", typeof(string)));

dt.Columns.Add(new DataColumn("EmpSalary", typeof(string)));

string Id = string.Empty;

string Name = string.Empty;

string DeptName = string.Empty;

string EmpAddress = string.Empty;

string EmpSalary = string.Empty;

for (int i = 0; i < GridView1.Rows.Count; i++)

{

GridViewRow row = (GridViewRow)GridView1.Rows[i];

if (i != e.RowIndex)

{

Id = row.Cells[1].Text;

Name = row.Cells[2].Text;

DeptName = row.Cells[3].Text;

EmpAddress = row.Cells[4].Text;

EmpSalary = row.Cells[5].Text;

DataRow dr = dt.NewRow();

dr["EmpId"] = Id;

dr["EmpName"] = Name;

dr["DeptName"] = DeptName;

dr["EmpAddress"] = EmpAddress;

dr["EmpSalary"] = EmpSalary;

dt.Rows.Add(dr);

}

GridView1.EditIndex = -1;

GridView1.DataBind();

GridView1.DataSource = dt;

}

This code is deleting row but after adding new row the deleted row appears once again could any one help me

Thanks in Advance

11 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mageshwaran R6y ago
Hi Syed:
Your problem solved please try below code:
public void DataBind()
    {

        dt.Columns.Add(new DataColumn("Id", typeof(int)));
        dt.Columns.Add(new DataColumn("Name", typeof(string)));
        string Id = string.Empty;
        string Name = string.Empty;
        for (int i = 0; i < dt.Columns.Count; i++)
        {
            DataRow dr = dt.NewRow();
            dr["Id"] = 1;
            dr["Name"] = "test1";
            dr["Id"] = 2;
            dr["Name"] = "test2";
            dt.Rows.Add(dr.ItemArray);
            break;
        }
        for (int i = dt.Rows.Count - 1; i >= 0; i--)
        {
            DataRow dr = dt.Rows[i];
            if (dr["Id"] =="1")
                dr.Delete();
        }
        dt.AcceptChanges();
        grdview.DataSource = dt.AsDataView();
        grdview.DataBind();


    }
Ronika Jency6y ago
Hi,

I think, it is runtime error. can you share the error message?
Syed Taha6y ago
@Ronika The error is of not coding and the error is coming in my output
Ronika Jency6y ago
Hi,

@Ronika It is giving me error on this
dt.Rows[index].Delete();

Can you share the error you are facing for this?. Because, if you are passing the correct index in dt. It should not throw the error.

Did you run my code right?
Syed Taha6y ago
@Ronika It is giving me error on this

dt.Rows[index].Delete();
Ronika Jency6y ago
Hi,

use below code already i have given explain for the code
protected void OnRowDeleting(object sender, GridViewDeleteEventArgs e)
{
int index = Convert.ToInt32(e.RowIndex);
DataTable dt = ViewState["dt"] as DataTable;
dt.Rows[index].Delete();
ViewState["dt"] = dt;
BindGrid();
}
Syed Taha6y ago
@Magesh R your answer is giving error
for(int i = dtPerson.Rows.Count-1; i >= 0; i--)
{
DataRow dr = dtPerson.Rows[i];
if (dr["name"] == "Name")
dr.Delete();
}
dtPerson.AcceptChanges();
Syed Taha6y ago
@Ronika Jency I am not using database
What should I do now
Mageshwaran R6y ago
Hi Syed:

Please try below code:
for(int i = dtPerson.Rows.Count-1; i >= 0; i--)
{
    DataRow dr = dtPerson.Rows[i];
    if (dr["name"] == "Name")
        dr.Delete();
}
dtPerson.AcceptChanges();
Mageshwaran R6y ago
Hi Syed:
Please try below code, it is given detailed solution of your problem
protected void Button_click(object sender, EventArgs e)
    {

        foreach (GridViewRow gvrow in GridView1.Rows)
        {
                var Label = gvrow.FindControl("Label1") as Label;
SqlCommand cmd = new SqlCommand("delete from tbl_data where id=@id",con);
cmd.Parameters.AddWithValue("id", int.Parse(Label.Text));
                con.Open();
                int id = cmd.ExecuteNonQuery();
                con.Close();
grdview.DataBind()


        }


    }
Ronika Jency6y ago
Hi,
OnRowDeleting event handler is executes. Inside the OnRowDeleting event handler, the Index of the GridView Row is determined and and it is used to delete the Row from the DataTable.
Finally the DataTable is saved back to the ViewState and the GridView is again populated.
Below code is delete from gridview datatable.
protected void OnRowDeleting(object sender, GridViewDeleteEventArgs e)
{
int index = Convert.ToInt32(e.RowIndex);
DataTable dt = ViewState["dt"] as DataTable;
dt.Rows[index].Delete();
ViewState["dt"] = dt;
BindGrid();
}
You delete the row from grid view. But not in your DB i think. that's why if you call add then its binding deleted row too.
Below is code delete from table,
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
GridViewRow row = (GridViewRow)GridView1.Rows[e.RowIndex];
SqlCommand cmd = new SqlCommand("delete from tbl_data where id=@id");
GridView1.DataBind();
}
Any one of code you can use, what your need.