Row delete from database or Viewstate/Datatable

Akhter HUssain

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='<%#Bind("D_CID")%>'>
"Container">
"Contnam" runat="server" Text='<%#Bind("Contnam")%>'>
"QTY">
"QTY" runat="server" Text='<%#Bind("QTY")%>'>
"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();

5 Replies

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

Jignesh Kumar6y ago
Accepted 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 HUssain6y ago
i did not understand you
Jignesh Kumar6y ago
You can update your view state once you delete from database table. You can assing viewstate values in BindGridView(); Method.
Akhter HUssain6y ago
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 Kumar6y ago
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();

}