delete row from gridview and database

Hi,

could anyone tell me how i can delete a row from the gridview and the database

public void getTasks()

{

SqlDataReader rdr = logik.loadData();

if (rdr == null || !rdr.HasRows)

{

GridView1.DataSource = rdr;

GridView1.DataBind();

}

else

{

GridView1.DataSource = rdr;

GridView1.DataBind();

GridView1.HeaderRow.Visible = false;

}

}

i have a guess about using rdr[0] cus thats the row id i guess.. but actually dont know how to implement..

Well there are two ways to do so .

1) gridview_rowdeleting event 2) just writing a delete command to delete row from ds and update to sqlDB or perform operations directly on DB using DataReader ..

Actually 1st case suits your need just becoz i don't which row you intend to delete from n rows ..

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)

{

//e.rowindex gives which row u selected to delete .

string fn = GridView1.Rows[e.RowIndex].Cells[2].Text;
// ID column of row in Gridview .

con.Open();

string str = string.Format("delete from table_name where id='{0}' ", fn);

SqlCommand cmd = new SqlCommand(str, con);

cmd.ExecuteNonQuery();

con.Close();

display_grid(); // calls below method to update the latest records in gridview ..

}

protected void display_grid()

{

da = new SqlDataAdapter("select * from formtable", con);

ds = new DataSet();

da.Fill(ds, "ccc");

GridView1.DataSource = ds.Tables[0];

GridView1.DataBind();

}

--------------------------------RATE THIS ANSWER AS HELPFUL , IF HELPS----------------

2 Replies

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

Priti Kumari12y ago
Please see Attached application..................
0
SUNIL GUTTA12y ago
Well there are two ways to do so .

1) gridview_rowdeleting event 2) just writing a delete command to delete row from ds and update to sqlDB or perform operations directly on DB using DataReader ..

Actually 1st case suits your need just becoz i don't which row you intend to delete from n rows ..

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
//e.rowindex gives which row u selected to delete .
string fn = GridView1.Rows[e.RowIndex].Cells[2].Text;
// ID column of row in Gridview .

con.Open();
string str = string.Format("delete from table_name where id='{0}' ", fn);
SqlCommand cmd = new SqlCommand(str, con);
cmd.ExecuteNonQuery();
con.Close();

display_grid(); // calls below method to update the latest records in gridview ..

}
protected void display_grid()
{
da = new SqlDataAdapter("select * from formtable", con);
ds = new DataSet();
da.Fill(ds, "ccc");

GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}

--------------------------------RATE THIS ANSWER AS HELPFUL , IF HELPS----------------
0