Stored Procedure - finished?

[AW]

XP + VB2008 Standard + MS Sql Express 2005
I can run QueriesTableAdapter1.Query1(par1,par2,par3)
and it works just fine BUT if I try to it run multiple times I get a
bunch of messages about threading and it seems to hang.
So, I thought, I need to know when the Query finished to wait before
sending a new Query BUT my bing searches find nothing.
Is there NO way to determine a stored Query is finished?
Do I need the Pro version of VB 2008 to do this?
Am I asking the dumbest question in the universe?
Thanks?

 

[Patrice]

Hard to tell without knowing what you are doing or the exact error message
you see...

To begin with, running a query is not asynchronous by default so you likely
done something special. Is this really a threading issue or could be the
issue that is you can have a single DataReader on a connection at the same
time ?

For now I would suspect you try to update your UI from a background thread.
Try for example : http://weblogs.asp.net/justin_rogers/pages/126345.aspx

--
Patrice


"AW" a écrit dans le message de groupe de discussion :
(e-mail address removed)...

 

[AW]

XP + VB 2008 - the docs say I can call a MS SQL Server 2005 stored
procedure like a subroutine so I jumped to the conclusion that it
would complete and then return - too simple minded?
The docs say nothing about threading or synchrouous or not.
So I called QueryTableAdapter.Query(par1,par2,par3)
and it works if I run one at a time but not if I try running a bunch
in a DO loop. Just simple and direct. Not looked at your ref yet.
So I must use threading for db calls?

 

[Patrice]

Hi,

Let's start from the beginning. What is the exact error messsage you get ?

--
Patrice


"AW" a écrit dans le message de groupe de discussion :
(e-mail address removed)...

 

[AW]

When trying to reproduce what I thought were problems and errors I was
unable to do so because the db updates kept working perfectly and
without a hitch. So I apologize for wasting your time.
But I would still like to know how to determine when a Query has
finished. Any info about that appreciated. Thanks for your time.

 

[Patrice]

By default a query is synchronous. So it is finished when you get at the
next line...

For asynchronous operations see
http://msdn.microsoft.com/en-us/library/zw97wx20.aspx.

For now I'm no sure you are running asynchronous queries but have some other
kind of issue...