I am trying to update my database with the contents of a DataSet, but currently am unable to do so with the following code:
string s = "Select number,name from table where id = 5 and num = 20";
SqlDataAdapter adapter = new SqlDataAdapter(s, con);
adapter.Fill(dset, "ABC");
SqlCommandBuilder sT = new SqlCommandBuilder(adapter);
adapter.Update(dset,"ABC");
This code is not updating the ABC table in the database.