Re: Invalidate disconected recodset

Tech-Archive recommends: Fix windows errors by optimizing your registry

Yes, my mistake. I was speaking about DataSet.

I had a look at the SQLDependency, but I can't find any description about
how to use in Windows Application. In all articles I read this class were use
with ASP.NET

I found a note, that it can be use in 2 scenarios:
pushing (Service Broker is involved)
polling (triggers are involved)

Unfortunatelly, again, I didn't find any more details.

Where coudl I find more information about using these scenerios in Windows
(Non Internet) app?
Thanks,

Lubomir

"Cor Ligthert [MVP]" wrote:

Lubomir,

Are you sure that you are talking about a disconected recordset.

That exist but is not a datatable or a dataset.

I am in doubt if you mean that thing, because you can do nothing with it in
ADONET than convert it. You make it difficult to help you if you are using
the wrong names for subjects you know.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdataoledboledbdataadapterclassfilltopic1.asp

Cor

"Lubomir" <Lubomir@xxxxxxxxxxxxxxxxxxxxxxxxx> schreef in bericht
news:4F0075C6-37CA-4F2C-B4B4-C1BF04732BDC@xxxxxxxxxxxxxxxx
Hi,

We would like to use MS SQL Server Express database for out data. The data
can be updated by many clients.

There will be an application that will show these data. This application
can
work with the disconnected recordest.

My question is, how to notify this application, about the data in
recordset
are not valid anymore, because the table in the database had been changed
by
a client?

As I understand, I can not use Notification Services with SQL Express.

1/ Is the trigger that would send message to the Service broker suitable
for
this scenario?

2/ Can I use Event notification? I think they don't work with DML

3/ What would be the best way to inform *.exe app that the disconnected
recodset is not valid?

Thanks for any ideas.

Lubomir





.