Here is an article that introduces command builder. It might be a good place to start:

http://www.programmersheaven.com/2/FAQ-ADONET-CommandBuilder-Prepare-Dataset

---

www.insteptech.com
We are volunteers and ask only that if we are able to help you, that you mark our reply as your answer. THANKS!

Well you need to read up on it to discover that.

Generating Commands with CommandBuilders (ADO.NET)

---

John Grove - TFD Group, Senior Software Engineer, EI Division, http://www.tfdg.com

Hi Vishie,

You can call the EndCurrentEdit method on the CurrencyManager associated with the data source to apply pending changes to the data source and then call the Update method on the DataAdapter to save changes back to database. The following is a sample:

SqlDataAdapter da = new SqlDataAdapter("select * from tablename","connection string");
SqlCommandBuilder cb = new SqlCommandBuilder(da);
da.Fill(dataset, "tablename");
// make some changes in the data source
// ...
this.BindingContext[dataset, "tablename"].EndCurrentEdit();
da.Update(dataset,"tablename");
dataset.AcceptChanges();

Hope this helps.

Sincerely,
Linda Liu

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. end us any feedback you have about the help from MSFT at fbmsdn@microsoft.com.

Here is an article that introduces command builder. It might be a good place to start:

http://www.programmersheaven.com/2/FAQ-ADONET-CommandBuilder-Prepare-Dataset

---

www.insteptech.com
We are volunteers and ask only that if we are able to help you, that you mark our reply as your answer. THANKS!

I would also read this article:

Weaning Developers from the CommandBuilder

---

John Grove - TFD Group, Senior Software Engineer, EI Division, http://www.tfdg.com

but how the get insert or other command wil take the data from the form..and insert into the table??

Well you need to read up on it to discover that.

Generating Commands with CommandBuilders (ADO.NET)

---

John Grove - TFD Group, Senior Software Engineer, EI Division, http://www.tfdg.com

Hi Vishie,

You can call the EndCurrentEdit method on the CurrencyManager associated with the data source to apply pending changes to the data source and then call the Update method on the DataAdapter to save changes back to database. The following is a sample:

SqlDataAdapter da = new SqlDataAdapter("select * from tablename","connection string");
SqlCommandBuilder cb = new SqlCommandBuilder(da);
da.Fill(dataset, "tablename");
// make some changes in the data source
// ...
this.BindingContext[dataset, "tablename"].EndCurrentEdit();
da.Update(dataset,"tablename");
dataset.AcceptChanges();

Hope this helps.

Sincerely,
Linda Liu

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. end us any feedback you have about the help from MSFT at fbmsdn@microsoft.com.