Dataadapter not updating database updating multiple rows at a time in sql server
One way to relieve this is to use a Data Set that is updated one time and stored in the cache.
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.
Consider salespeople who need customer data as they travel.
At the beginning of the day, they’ll need to sync up with the main database to have the latest information available.
In Lesson 4, we learned how to read data quickly an let go of the connection with the Sql Data Reader.