Asynchronous SqlCommand execution

  • Thread starter Thread starter George Gîta
  • Start date Start date
G

George Gîta

I there a way to execute a SqlCommnad asynchronous? Or to open an dataset
asynchronous?
Like in ADO using adAsyncFetch.

Thank you ...
 
Not yet - it will be in .net 2.0.
As a workaround you might use worker thread to fetch the records.
 
Miha is right, but I would not bother inventing something that ADO 2.0 will
do for you (and in a far safer way).

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

Miha Markic said:
Not yet - it will be in .net 2.0.
As a workaround you might use worker thread to fetch the records.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

George Gîta said:
I there a way to execute a SqlCommnad asynchronous? Or to open an
dataset
asynchronous?
Like in ADO using adAsyncFetch.

Thank you ...
Click to expand...
Click to expand...
 
More info --

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvs05/html/async2.asp

While I agree with Bill about not reinventing the upcoming wheel, but if you
need to get around this problem today (and not wait another 6 months or
launch on beta 1), you could try looking into AsyncCallBack .. thats a
cheap'n'easy way to get around Synchronous operations.

- Sahil Malik
You can reach me thru my blog at
http://www.dotnetjunkies.com/weblog/sahilmalik



William (Bill) Vaughn said:
Miha is right, but I would not bother inventing something that ADO 2.0 will
do for you (and in a far safer way).

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

Miha Markic said:
Not yet - it will be in .net 2.0.
As a workaround you might use worker thread to fetch the records.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

George Gîta said:
I there a way to execute a SqlCommnad asynchronous? Or to open an
dataset
asynchronous?
Like in ADO using adAsyncFetch.

Thank you ...
Click to expand...
Click to expand...
Click to expand...
 
I am actually much more excited about Whidbeys BackgroundWorker than I am
about our (ado.net's) asynchronous operation with callbacks. A good thing is
that people have found this so useful for winforms application that you can
find source code that backports the BackgroundWorker to v1.1

I just came across these (I have not looked at them)
http://www.jacksonsoft.freeuk.com/articles/backgroundworker.html
http://weblogs.asp.net/rosherove/articles/BackgroundWorker.aspx
http://bitarray.co.uk/ben/articles/208.aspx


--
Angel Saenz-Badillos [MS] Managed Providers
This posting is provided "AS IS", with no warranties, and confers no
rights.Please do not send email directly to this alias.
This alias is for newsgroup purposes only.
I am now blogging about ADO.NET: http://weblogs.asp.net/angelsb/




Sahil Malik said:
More info --

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvs05/html/async2.asp

While I agree with Bill about not reinventing the upcoming wheel, but if you
need to get around this problem today (and not wait another 6 months or
launch on beta 1), you could try looking into AsyncCallBack .. thats a
cheap'n'easy way to get around Synchronous operations.

- Sahil Malik
You can reach me thru my blog at
http://www.dotnetjunkies.com/weblog/sahilmalik



William (Bill) Vaughn said:
Miha is right, but I would not bother inventing something that ADO 2.0 will
do for you (and in a far safer way).

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

Miha Markic said:
Not yet - it will be in .net 2.0.
As a workaround you might use worker thread to fetch the records.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

I there a way to execute a SqlCommnad asynchronous? Or to open an
dataset
asynchronous?
Like in ADO using adAsyncFetch.

Thank you ...
Click to expand...
Click to expand...
Click to expand...
 
Back
Top