Row delete from database or Viewstate/Datatable

Question

i have gridview,i want condition to delete row from gridview, "GridView1" runat= "server" AllowSorting= "True" HorizontalAlign= "Center" AutoGenerateColumns= "false" CssClass= "mygrdContent" HeaderStyle-BackColor= "#66ccff" HeaderStyle-CssClass= "header" HeaderStyle-ForeColor= "White" OnRowDataBound= "GridView1_RowDataBound" OnRowDeleting= "GridView1_RowDeleting" PagerStyle-CssClass= "pager" RowStyle-CssClass= "rows" Width= "452px" ShowFooter= "True" > "ID" > "D_CID" runat= "server" Text= ' ' > "Container" > "Contnam" runat= "server" Text= ' ' > "QTY" > "QTY" runat= "server" Text= ' ' > "lblTotal1" runat= "server" > "Button" ShowDeleteButton= "True" /> "#66CCFF" ForeColor= "White" /> "Yellow" /> if i have data in gridview in datatable/Viewstate then it delete from viewstate if first column id does not exit , if i have ID in first column ,which i retrieved from database then it deleted from database below i tried but it is not working protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { int id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value); int index = Convert.ToInt32(e.RowIndex); DataTable dt = (DataTable)ViewState[ "dt" ]; // Delete from ViewState. dt.Rows[index].Delete(); ViewState[ "dt" ] = dt; string query = "delete from tbl_Import_Detail WHERE D_CID = @Id" ; using (SqlCommand cmd = new SqlCommand(query)) { cmd.Connection = con; cmd.Parameters.AddWithValue( "@Id" , id); con.Open(); cmd.ExecuteNonQuery(); con.Close(); } BindGridView();

Jignesh Kumar · Answer

You need to change you BindGrivew method and Below code line you can add in this method ViewState[ "dt" ] = dt; // dt means values you are getting from database after delete. Still you have query, Please share BindGridview code.

Akhter HUssain · Answer

i did not understand you

Jignesh Kumar · Answer

You can update your view state once you delete from database table. You can assing viewstate values in BindGridView(); Method.

Akhter HUssain · Answer

Hi Jignesh Kumar, i am getting error,i want condition to delete ,it executing both command,beacuse some time ID exit or not in gridview View below image There is no row at position 1. Line 529: dt.Rows[index].Delete();

Jignesh Kumar · Answer

Hi, You need to call AcceptChanges() method after delete row from datatable. Try this one, protected void GridView1_RowDeleting( object sender, GridViewDeleteEventArgs e) { int id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value); int index = Convert.ToInt32(e.RowIndex); DataTable dt = (DataTable)ViewState[ "dt" ]; // Delete from ViewState. dt.Rows[index].Delete(); dt.AcceptChanges(); ViewState[ "dt" ] = dt; string query = "delete from tbl_Import_Detail WHERE D_CID = @Id" ; using (SqlCommand cmd = new SqlCommand(query)) { cmd.Connection = con; cmd.Parameters.AddWithValue( "@Id" , id); con.Open(); cmd.ExecuteNonQuery(); con.Close(); } BindGridView(); }