winforms update help??

Question

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.

Hirendra Sisodiya · Answer

please send me your code if you can.......

chandu · Answer

i do have a primary key for my tablebut 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 Sisodiya · Answer

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

chandu · Answer

hi i have worked with ur code but db values are not getting updated?? any help??

Hirendra Sisodiya · Answer

code is righti 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 ) ;

chandu · Answer

thanks for ur replybut 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 Choudhary · Answer

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.