Problem in Table Adapter and Datagrid view

Question

hai I am new to c# actually i have a table adapter which is bind to a grid and i have three button insertupdate and delete. insert and update are working fine when i delete a record in grid it is been deleted but it is not been deleted in database.once again if i run the application the deleted record is shownplease help meany suggestion will be appreciated. I have attached my code and error message. Thanks

sham suman · Answer

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 { 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; } } } }

Sam Hobbs · Answer

Database Table Update in a DataGridView without Writing Code

adam abdul · Answer

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

DRISHTY · Answer

Add following line after your delete logic : sqllAdap.Update(ds.Tables[TBL_NAME]);