Hello there

I'm using Llblgen Pro 2, self-servicing (2 class) scenario, C# Winforms 2.0 and SQL Server 2000.

I need to trigger some stored procedures to run various monthly jobs (for example to kick off ETL or process Analysis Services cubes) from my UI. However, I don't want the user to have to wait for the result as I have a simple notification system set up which sends them a message when the process is complete.

How can I simply invoke a stored procedure without waiting for it to complete in the UI? I'm sure it is possible in ADO.NET to make asynchronous calls to database processes.

It may be the case that I have to trigger a job but it would be neat to do it through the UI.

Any help appreciated! As ever, excuse my inexpertise and thanks for reading/writing on this forum everyone.

Carl White

Check out the BackgroundWorkerProcess class. This allows your code to execute async commands and then use the results of the async operation in the main thread of your app (GUI).

I confess I haven't worked with this much. I primarily design web apps. I came across this class researching async operations in asp.net.

Yeah, BackgroundWorker class is the easiest way. Or you can go with delegates or Thread class.

Thanks for the replies - they're both ideas I'd considered, unfortunately. I was rather hoping I could simply kick off a stored procedure then simply ignore its progress and effectively discard any results, allowing my application's (asynchronous) notification process to clean up afterwards.

My concern is that the application may be shut down while the stored proc is running. I shall test to see what happens... Of course, my other option is to call the stored proc asynchronously in ADO.NET but I want to keep my data layer pure.

Thanks again for your replies.

Carl White

Some threads from the past: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=4354 http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=6383