HOWTO: Reload DataSet?

  • Thread starter Thread starter mitmed
  • Start date Start date
M

mitmed

Hello,

I'm working on basic VB.NET winforms Client-Server application with
SQLServer as backend.
When users open a particular form, the data is loaded into DataSet and
controls are bounded to it. When one user changes the data and saves
it, the changes are saved to the database and also reflected on his
dataset. However, the changes are not seen by other users, who have
the same form open, until they reload their datasets.

Is this a normal .NET behavior?
Is there a way to automatically propagate the changes?
If not, how can I efficiently reload the DataSet? (Our datasets are
quite big, around 20,000 records)
When reloading a DataSet, do I have to rebind the controls too?


Thanks in advance.

Regards,
Dmitri
 
Hi,

mitmed said:
Hello,

I'm working on basic VB.NET winforms Client-Server application with
SQLServer as backend.
When users open a particular form, the data is loaded into DataSet and
controls are bounded to it. When one user changes the data and saves
it, the changes are saved to the database and also reflected on his
dataset. However, the changes are not seen by other users, who have
the same form open, until they reload their datasets.
Click to expand...
Is this a normal .NET behavior?
Click to expand...

Yes, datasets are disconnected from database.
Is there a way to automatically propagate the changes?
Click to expand...

Can't easily do it.
If not, how can I efficiently reload the DataSet? (Our datasets are
quite big, around 20,000 records)
Click to expand...

You are loading too much data. You should add some conditions and load only
the data you really need.
When reloading a DataSet, do I have to rebind the controls too?
Click to expand...

Nope.
 
Back
Top