Updating source with data adapter

csharp United States
  • 19 years ago

    I have successfully filled a dataset using the data adapter, added new records to the dataset with the NewRecord function and updated the source database with one call to the data adapter Update function.  When I change the data in the fields of the dataset and call the data adapter Update function I thought the source database would get updated with the one call.  It's not working for me.  The only way I have been able to update the source database was to write a command and use ExecuteNonQuery.  What is the C# or VB.NET syntax for updating the source database after the fields in the dataset have been changed using the data adapter?  

Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“We should forget about small efficiencies, say about 97% of the time: premature optimization is the root of all evil.” - Donald Knuth