Watcher for Datasets?

[J Rico]

Hi,
I'm making an App in which a form is bounded to a table in a database,
and with some arrow keys, you can move through the rows of the
database.
At the moment I do a request to the database each time an arrow is
clicked, but my idea is to load an entire dataset when the form is
loaded and not having to make requests to the database all time.
The problem is that if I do it this way, if other uses introduces a new
row in the database, it won't show on the form I have opened. I'm
wondering if there's something like filesystemwatchers but for
databases, so I only have to reload the dataset if something has
changed in the database.
Thanks in advance.

[Cor Ligthert [MVP]]

Rico,

This is typical a question for the newsgroup

microsoft.public.dotnet.framework.adonet.

Don't forget that the dataset is disconnected, which means that you have to
find if data in your dataset will be changed by others.

You probably will get the answer to use timestamps in your dataset, what
means that these have to be in all already existing applications. From that
I think it will be impossible in whatever way you do that.

However ask it in that newsgroup.

I am active there as well and too interested in the answers.

Cor

[J Rico]

Thanks, I'll ask in that group