how to update dataset dynamically

  • Thread starter Thread starter ilyas
  • Start date Start date
I

ilyas

Hi

in my application i am using storeprocedures to retrive the data from
DB then i will store it in Dataset . but i cant display the updated
data using Data Set , plz if anybody knows it plz suggest me how to do
it

Thnx in advance
 
Hi

in my application i am using storeprocedures to retrive the data from
DB then i will store it in Dataset . but i cant display the updated
data using Data Set , plz if anybody knows it plz suggest me how to do
it

Thnx in advance
Click to expand...

When you update a DataSet, you either have to keep a stored copy and
rebind or make another trip to the database and pull the latest
information. In other words, cache or pull.

The decision of cache or pull is largely dependent on how complex the
pull is and how heavy your site is hit (scalability). If you decide
cache, your next decision is cache in page (ViewState for example), in
session or in cache (either built in ASP.NET cache or custom). The main
deciding factor is lifetime of data, although scalability may rear its
head.

Peace and Grace,


--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

Twitter: @gbworld
Blog: http://gregorybeamer.spaces.live.com

*******************************************
| Think outside the box! |
*******************************************
 
Back
Top