Updating records in dataset
A couple scenarios illustrate why you would want to work with disconnected data: people working without network connectivity and making Web sites more scalable.
Consider sales people who need customer data as they travel.
In Lesson 3, we discussed a fully connected mode of operation for interacting with a data source by using the Sql Command object.
These are added to the Sql Data Adapter after it is instantiated.At the beginning of the day, they’ll need to sync up with the main database to have the latest information available.During the day, they’ll make modifications to existing customer data, add new customers, and input new orders.You just create a new instance, just like any other object: The Data Set constructor doesn’t require parameters.
However there is one overload that accepts a string for the name of the Data Set, which is used if you were to serialize the data to XML.
Since that isn’t a requirement for this example, I left it out.