Dataset refresh single column

  • Thread starter Thread starter Arapi
  • Start date Start date
A

Arapi

Hi,

I am upgrading a vb6 app to .net. My app works this way: on the form_load
event I populate a dataset with all existing products (over 25,000) and
their quantities on the database. Having in mind that many people (many
computers) are placing orders at the same time, there is a great possibility
that real quantity of the product might not be the same as when the dataset
was loaded. Does any one have any idea on how can I make sure that the
quantity column on my dataset is always up to date without having to reload
the whole table (i am expecting the number of products to grow well beyond
35,000 which I believe will have a negative effect on the performance if
dataset is loaded on every entry). With other words, is there any way just
to reload the quantity column without reloading the whole table (maybe this
way the process would work faster)?



Thanks
 
If your data is that dynamic, is it really ideal to be loading it all into a
DataSet at the application start up?
 
Well yes, only the quantity column is a bit more dynamic. This is a POS
environment (with around 1000 invoices/day) and, in my opinion, it is a
better idea to load everything at startup (once a day) so that there are as
few active connections to the database as possible. Btw, isn't this what the
ado.net is all about? The disconnected state. Anyhow thanks for your
reply.
 
Back
Top