delete row from gridview and database

Question

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..

Priti Kumari · Answer

Please see Attached application..................

SUNIL GUTTA · Answer

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----------------