SqlCommandBuilder not updating database in C#

but where are you making changes in datagridview and loading the change into datatable?

reload the datatable this time not from the database but with datagridview

foreach(DataGridViewRow row in dgv.Rows)
{
DataRow dRow = dt.NewRow();
foreach(DataGridViewCell cell in row.Cells)
{
dRow[cell.ColumnIndex] = cell.Value;
}
dt.Rows.Add(dRow);
}

though your approach is not correct , instead of changing in datagrid change in datatable then bring the changes in datagrid.

the update() method works on the changes made to the datatable and accordingly fires the T-Sql for any modified data update statement is fired behind the scene , it is decided by the row state property of datatable.

in your case there is no change occuring in datatable so on Update() nothing will take place.

please go through https://www.sharpencode.com/article/ADONET/dataset-and-sqldataadapter

2 Replies

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

Sachin Singh5y ago
but where are you making changes in datagridview and loading the change into datatable?
reload the datatable this time not from the database but with datagridview
foreach(DataGridViewRow row in dgv.Rows)
{
    DataRow dRow = dt.NewRow();
    foreach(DataGridViewCell cell in row.Cells)
    {
        dRow[cell.ColumnIndex] = cell.Value;
    }
    dt.Rows.Add(dRow);
}
though your approach is not correct , instead of changing in datagrid change in datatable then bring the changes in datagrid.
the update() method works on the changes made to the datatable and accordingly fires the T-Sql for any modified data update statement is fired behind the scene , it is decided by the row state property of datatable.
in your case there is no change occuring in datatable so on Update() nothing will take place.

please go through https://www.sharpencode.com/article/ADONET/dataset-and-sqldataadapter
Sachin Singh5y ago
You were not updating anything , i have updated your methods now test. the file is attached.