How to call the SQL commands asynchronously in ADO.NET
version 2.0

Answer Posted / sandyni

In the asynchronous method ,the client creates a SqlCommand
object.the client application also sets the async attribute
in the connection string to true. Next, the client invokes
any of the asynchronous methods such as
beginExecuteNonQuery, BeginExecuteReader, or
BeginExecuteXmlReader through the SqlCommand object.

After executing the sql command the asynchronous methods
will close by using
EndExecuteNonquery,EndExecuteScalar,EndExecuteReader.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to find the given query is optimised one or not?

758


Explain executenonquery?

820


What is Data Provider?

817


how you will deal result set? How do you sort a dataset?If a dataset contains 100 rows, how to fetch rows between 5 and 15 only?

800


What is the role of data provider in ado.net?

758


What are the drawbacks of using ado.net?

735


What are the types of databinding?

742


What is ado asp?

760


What is a dynaset in access?

815


How can we add relation between tables in a dataset?

768


Is bulk insert faster than insert?

700


What are the differences between OLEDB and SQLClient Providers?

793


What are the advantages of using datalist?

721


What is ado net stands for?

723


What is difference between datatable and dataset?

764