When DatSet reload?

  • Thread starter Thread starter Laszlo
  • Start date Start date
L

Laszlo

Hi,

I have my data in a DataSet class. But the data could changed on the SQL
Server from an other user. How can I know, that the data is changed?

It will be very usefull, if I could define a trigger on the SQL Server, and
that could send me an event to my program, and the I can refill the DataSet.
But this function isn't supported, or is?

Who can I get this functionality ?

Laszlo
 
Hi,

Laszlo said:
Hi,

I have my data in a DataSet class. But the data could changed on the SQL
Server from an other user. How can I know, that the data is changed?
Click to expand...

You can't. There is Sql Server notification services out there however it is
useful in limited scenarios.
What are you doing btw?
 
Hi Laszlo,

The dataset it disconnected, it can on a pda as well.

When you do an update of the dataset you can catch the errors which will be
probably mostly concurrency errors (because another user has done something
with the data), and after that with a fill refill your dataset again.

You have yourself to correct the concurrency errors wherefore are events and
methods, however you have to choose yourself the method you want to use.
(Force the update, reload the dataset for the user with the new
information and let him do his work, ask the user etc etc it can be on much
different situations and therefore much different methods ).

That is one of the the reasons why it is clever to keep your dataset as
small as possible for the situation.

I hope this helps?

Cor
 
Hi,

it is a multisuer environment. I get jobs, but I will not load the tables
before every job, it is too slow.
Then I must make a mechanisme, perhaps via a table. I can read this table,
and I can reload my table or not.

Laszlo
 
Back
Top