data adapter does not update

Question

SqlConnection con=new SqlConnection(Data Source=real\real;Initial Catalog=Northwind;Integrated Security=SSPI;); string sql1=Select * from Employees; SqlDataAdapter da=new SqlDataAdapter(sql1con); SqlCommandBuilder cb=new SqlCommandBuilder(da); DataSet ds=new DataSet(); da.Fill(dsEmployees); ds.Tables[0].Rows[0][LastName]=Smith; ds.AcceptChanges(); da.Update(dsEmployees); I execute the above simple code and yet the tables Employess from Nortwind database is not updated. I get no errors. I have followed the example from the documentation of SqlCommandBuilder.

aeroswan · Answer

yesthat's right. when you execute the acceptchanges method the DataRow's RowState property will change from Added orModified to Unchanged. so DataAdapter will not get the changes.

eksypnos123 · Answer

yep it works thanks. it seems that the ds.AcceptChanges unmarks the rows that are modified so the da soes nothing if it's called after.

aeroswan · Answer

i have encountered the same problemand you can solve it by changing the sequence of the last two rows of codes. ......... ......... ds.Tables[0].Rows[0][LastName]=Smith; da.Update(dsEmployees); ds.AcceptChanges(); i have tried it in oracleand it works.