Problem in Table Adapter and Datagrid view

adam abdul

hai,

I am new to c#, actually i have a table adapter which is bind to a grid, and i have three button insert,update 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 shown,please help me,any suggestion will be appreciated. I have attached my code and error message.

Thanks

4 Replies

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

sham suman16y ago
Accepted 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 < 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;
                }
            }
        }

    }
Sam Hobbs16y ago
Database Table Update in a DataGridView without Writing Code
adam abdul16y ago
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
DRISHTY16y ago
Add following line after your delete logic :
sqllAdap.Update(ds.Tables[TBL_NAME]);