If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

VB.NET Progress Bar indicating status of Stored Proc

samelterrance · 2007-07-16 09:29:31

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…

16-07-2007 9:29am

#1

samelterrance

Closed Accounts Posts: 120 ✭✭

Join Date: July 2007

Posts: 102

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,

0

Comments

#2 16-07-2007 11:14am

Ginger

Registered Users, Registered Users 2 Posts: 2,931 ✭✭✭

Join Date: January 2003

Posts: 2658

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

0