ADO.NET DataAdapter Update Method (Persist DataSet to DataStore)

[Guest]

I hopeing that someone is able to point me to some good documentation on
using the DataAdapter to Persists DataSets back to a DataStore. I having
difficulty in working out how all this disconnected or (loosly-coupled)
data-layer stuff works and would like some complete examples in ASP.NET (VB) ?

Any feedback is appreciated.

Regards
Ben

 

[William \(Bill\) Vaughn]

Basically, you have several options to generate the code to perform the
update. Whatever technique you use, the UpdateCommand, DeleteCommand and
InsertCommand have to point to Command objects to updated a row, delete a
row and insert a row. Depending on the SELECT you execute to populate the
DataTable (the SelectCommand in the DA), these can be built at design-time
(manually or with the VS DataAdapter Configuration Wizard) or at runtime
with the Command(Don'tUse)Builder.
There are a lot of examples in my book. See www.betav.com.
There are also many examples in the doc.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________