Migration from ADO to ADO.Net with SqlClient

[Guest]

I am trying to get to terms with the use of updating through a data adaptor
in VS 2005.
The application allows the user to create forms and add fields and tables to
the database and so the code has to be generic.

In ADO, one can read the record,change the value and simply update:
RecordSet.Fields(FieldName)=SomeValue
RecordSet.Update

I can update a DataSet in a similar way, but how do I get the chages back to
the database? The data adaptor needs an UpdateCommand, but I cant find any
information about what this should be like.

Any help would be welcome.

 

[Mary Chipman [MSFT]]

This should get you started:

Updating Data Sources with DataAdapters
http://msdn2.microsoft.com/en-us/library/33y2221y.aspx

--Mary