VB.NET Progress Bar indicating status of Stored Proc

samelterrance

Hi All,

I am using VB.NET and SQL Server 2005.
I have a stored procedure which I am executing from a windows app.
Once the user clicks the go button, I would like a progress bar to indicate approximately how much time is remaining.

I kind of recall something about a datapumptask in sql server,
just wondering if anyone has experience in this area. I've done some research and kind find a suitable article.

Thanks in advance,

Ginger

You can use the SQLDependency and an event handler to manage this

http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqldependency.aspx

But thats mainly for changes in the dataset. Normally I would create a new delegate and get it to do the task so that the UI doesnt lock up.. but its been a while since i have done this sort of development

I know red gate software have something like this