vb.net and store proc process

Hi,

my vb.net app start a store procedure. It takes long time to be completed.
So my idea is to monitor the process and advise when it is finished or if it fails.

How can I reach this goal?
thank

:wave:

It finishes when the method call returns. Apart from that you have no way of determining where it's up to. I suggest that you just set the Cursor to WaitCursor, as you should always do before a potentially lengthy operation, so the user knows something is happening. You may also want to execute the SP in a seperate thread if you want your UI to remain responsive.

the store proc run with a thread to have UI free.....

I'll follow your suggestion......

It will be interesting to see what ADO.NET 2.0 looks like. I read an article describing how to perform asynchronous data access in .NET 2.0, but I have been unable to find the methods it describes, so I think that they've been removed in beta 2. Maybe they'll come back for the final release, although I'd guess probably not.