Discussion Locked

Dataset Update

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
How does one do multiple table updates in a Dataset using Visual Basic dot net language.

1 reply

by fromnaija

Structurally, a dataset makes data available as a set of collections. Tables are exposed as a collection of the DataSet Class object and records are available in the Rows Property collection of DataTable Class objects. It is therefore possible to make changes to data in a dataset by simply manipulating these collections using base collection methods.

Remember also that a dataset is more or less like an in-memory replication of the database. So, using SQL statement, you perform the update on the dataset and using the dataadapter, send the update to the database.

I hope this helps. If you need sample codes please let me know. Cheers.

This discussion is closed to new replies.