dating advice from a woman - Updating database using dataadapter

Every request for the page checks the cache and loads the data if it isn’t there or just pulls the data out of the cache and displays it.

updating database using dataadapter-6

Data Sets only hold data and do not interact with a data source.

It is the Sql Data Adapter that manages connections with the data source and gives us disconnected behavior.

These are the mechanics of working with disconnected data.

Because the applications hold on to connections only when necessary, the application becomes more scalable.

Another scenario is making a Web site more scalable.

With a Sql Data Reader, you have to go back to the database for records every time you show a page.

This requires a new connection for each page load, which will hurt scalability as the number of users increases.

One way to relieve this is to use a Data Set that is updated one time and stored in the cache.

There are two ways to add insert, update, and delete commands: via Sql Data Adapter properties or with a Sql Command Builder.

Tags: , ,