HOWTO: Reload DataSet?

[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

 

[Miha Markic [MVP C#]]

Hi,

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?

Yes, datasets are disconnected from database.

Is there a way to automatically propagate the changes?

Can't easily do it.

If not, how can I efficiently reload the DataSet? (Our datasets are
quite big, around 20,000 records)

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?

Nope.