Update command of Dataset In C#

[Ariadne]

Hi,

I am using the C# as frontend and MS Access a backend.
I have a Insert statement to insert new records into the Access database, but how do i Update the dataset?

[Zecho]

Hi,

The approach that you are doing is quite the reverse. You must first edit your dataset then send the updates to your access database. To do this you must have a activeconnection, adapter and a dataset. eg:

OleDbDataAdapter adapter = new OleDbDataAdapter("SELECT * FROM myTable", con);
OleDbCommandBuilder cm = new OleDbCommandBuilder(adapter);
...
// Fill the DataSet and edit
adapter.Fill(ds);
ds.Tables[0].Rows[10]["field1"] = "TEsting";
// send updates to database
adapter.Update(ds);

[Ariadne]

I am using the insert command to update the database. so now How do u update the dataset? Do u refill it .

[Reegan]

You can follow this method,

adapter.InsertCommand = new SqlCommand("INSERT INTO myTable VALUES(@Id)", conn);
adapter.InsertCommand.Parameters.Add("@Id", ...);

Sending Insert statements directly to the database is not a very good idea if your using a dataset. You must edit your dataset, then using your adapter, send the changes to your database.