winforms update help??

chandu

hi all i have created a datagridview to display my records from db,and now i want to update the records below shown is my code

 
SqlDataAdapter da = new SqlDataAdapter("select * from emp", con);
SqlCommandBuilder cb = new SqlCommandBuilder(da);
DataSet ds = new DataSet();
dataGridView1.DataSource = ds.Tables[0];
da.UpdateCommand = cb.GetUpdateCommand();
da.Update(ds);

but when i execute the code and update the values they are not getting updated in my database??i dnt know y?? plz help me with this,thanks.

7 Replies

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

Hirendra Sisodiya16y ago
please send me your code, if you can.......
chandu16y ago
i do have a primary key for my table,but none is changed im unable to upload the data in my db.i have a doubt like when we display data using datagridview can we modify the data on datagridview itself and upload into db??
Hirendra Sisodiya16y ago
i think you do not have a primary key on that table.
For your code needs primary key of the table. If your table doesn't have a primary key, you need to make one
thanks
chandu16y ago
hi i have worked with ur code but db values are not getting updated?? any help??
Hirendra Sisodiya16y ago
code is right,i think this code should be work fine ......ok..you can do this in another way like this:
OleDbDataAdapter dAdapter = new OleDbDataAdapter(query, connString);
OleDbCommandBuilder cBuilder = new OleDbCommandBuilder(dAdapter);
DataTable dTable = new DataTable();
dAdapter.Fill(dTable);
BindingSource bSource = new BindingSource();
bSource.DataSource = dTable;
DataGridView1.DataSource = bSource;
dAdapter.Update(dTable);
chandu16y ago
thanks for ur reply,but when i execute your code im getting error at myDataRow = myDataSet.Tables["Customers"].NewRow(); as
**Object reference not set to an instance of an object.i dnt know why im getting this error any help??

Amit Choudhary16y ago

hi friend,

 DataSet myDataSet = new DataSet();

 mySqlDataAdapter.Fill(myDataSet, "Customers");
    DataGridView1.DataSource=myDataSet;

 On adding new row event of DataGridView add the following code inside
    DataRow myDataRow;    myDataRow = myDataSet.Tables["Customers"].NewRow();
    myDataRow["CustomerId"] = "NewID";
    myDataRow["ContactName"] = "New Name";
    myDataRow["CompanyName"] = "New Company Name";
    
    myDataSet.Tables["Customers"].Rows.Add(myDataRow);
    myDataSet.AcceptChanges();
     SqlCommandBuilder mySqlCommandBuilder = new SqlCommandBuilder(mySqlDataAdapter);
  mySqlDataAdapter.Update(myDataSet, "Customers");

And Here  your Dataset will be updated from gridview.

Similarly you can Delete/Edit from the grid view with respect to add code to their events.

Please mark as answer if it helps you.