0
Hi,
You can use Acceptchange() method after deleting code. Just check this.
Change the table name as per ur TableName.
Insted of session You can use direct table from DataAdapter. Just assign table name. Check this code...
Write this code in GridView1 RowDelete Command event.
protected void GridView1_RowDeleted(object sender, GridViewDeletedEventArgs e)
{
int i;
DataSet objds = (DataSet)Session["ObjDataSet"]; //Assign table from database here.
DataTable dtNewAct = (DataTable)objds.Tables[0];
i = GridView1.SelectedIndex;
for (int iRow = 0; iRow < objds.Tables[0].Rows.Count - 1; iRow++)
{
if (i == iRow)
{
if (objds.Tables[0].Rows[i].RowState != DataRowState.Deleted)
{
objds.Tables[0].Rows[i].Delete();
objds.Tables[0].AcceptChanges();
Session["ObjDataSet"] = objds;
}
}
}
}
Accepted 0
hai,
Thanks for kind response, i tried ur code but it fails to get table name.
Here is the code below
Note: adduser is my table name
private void simpleButton1_Click(object sender, EventArgs e)
{
if (dataGridView1.SelectedRows.Count > 0)
{
dataGridView1.Rows.RemoveAt(this.dataGridView1.SelectedRows[0].Index);
}
addUserTableAdapter.Update(checkOutDataSet.Tables[adduser]);
}
error message:
Error 1 The name 'adduser' does not exist in the current context
0
Add following line after your delete logic :
sqllAdap.Update(ds.Tables[TBL_NAME]);