Dataadapter not updating database

Rated 4.93/5 based on 741 customer reviews

A Data Set is an in-memory data store that can hold numerous tables.Data Sets only hold data and do not interact with a data source.During the day, they’ll make modifications to existing customer data, add new customers, and input new orders.This is okay because they have a given region or customer base where other people won’t be changing the same records.

The Sql Data Adapter opens a connection only when required and closes it as soon as it has performed its task.Because the applications hold on to connections only when necessary, the application becomes more scalable.A couple scenarios illustrate why you would want to work with disconnected data: people working without network connectivity and making Web sites more scalable.Also, if the amount of data is so large that holding it in memory is impractical, you will need to use Sql Data Reader for read-only data.Really, one could come up with all kinds of exceptions, but the true guiding force should be the requirements of your application which will influence what your design should be.

Leave a Reply