Using threading to call sql script

[VMI]

How can I use threading in my Windows Form to call a sql script that takes a
few seconds to run? When I click on a button, I'd like to call the SP,
display in my Form message a "Please wait" message, and then when the script
is done, fill the grids with this data.
I've read deveral articles on multithreading, but I really haven't found how
to "join" it to my gui thread once this new thread finishes.

Any help is appreciated. I'm using VS2005.

Thanks.

[Jon Skeet [C# MVP]]

VMI <vo******@yahoo.comwrote:

How can I use threading in my Windows Form to call a sql script that takes a
few seconds to run? When I click on a button, I'd like to call the SP,
display in my Form message a "Please wait" message, and then when the script
is done, fill the grids with this data.
I've read deveral articles on multithreading, but I really haven't found how
to "join" it to my gui thread once this new thread finishes.

I don't think you'll need Thread.Join here, but you'll almost certainly
want Control.Invoke or Control.BeginInvoke to "get back" onto the UI
thread so that you can update the UI from the right thread.

See http://pobox.com/~skeet/csharp/threads/winforms.shtml

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet Blog: http://www.msmvps.com/jon.skeet
If replying to the group, please do not mail me too

[Tariq Karim]

There are various ways of accomplishing this task. Simple way is to
create a method that executes SQL task.

On your GUI thread, create a new thread and pass the above function as
ThreadStart. Start the new created thread. On your GUI thread you can
check the status of newly created thread on a timely fashion (for this
you can use a timer control). You can use the IsAlive property of thread.
If IsAlive returns false, that means thread have completed the execution
of method and result is ready to be displayed.

--
Tariq Karim | Capgemini | El-Segundo
Senior Consultant | Telecom Media and Entertainment
Mobile: [phone] | www.capgemini.com
Join the Collaborative Business Experience

VMI wrote:

How can I use threading in my Windows Form to call a sql script that takes a
few seconds to run? When I click on a button, I'd like to call the SP,
display in my Form message a "Please wait" message, and then when the script
is done, fill the grids with this data.
I've read deveral articles on multithreading, but I really haven't found how
to "join" it to my gui thread once this new thread finishes.

Any help is appreciated. I'm using VS2005.

Thanks.

[gover]

Take a look at the BackgroundWorkerClass. It might be what you're looking
for.

"VMI" <vo******@yahoo.comwrote in message
news:ui**************@TK2MSFTNGP05.phx.gbl...

How can I use threading in my Windows Form to call a sql script that takes
a
few seconds to run? When I click on a button, I'd like to call the SP,
display in my Form message a "Please wait" message, and then when the
script
is done, fill the grids with this data.
I've read deveral articles on multithreading, but I really haven't found
how
to "join" it to my gui thread once this new thread finishes.

Any help is appreciated. I'm using VS2005.

Thanks.