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

Define data access layer?

533


What is an example of ordinal data?

489


What is datasource in ado.net?

590


What is difference between entity framework and ado.net?

481


What does sqldatareader return?

502






What is microsoft ado.net?

579


What are the pre-requisites for connection pooling?

539


Does entity framework use ado.net?

507


What are the benefits of using ado.net?

518


What are all the classes that are available in System.Data Namespace?

558


Explain the difference in an abstract class and an interface?

507


How can I retrieve two tables of data at a time by using data reader? Data reader read and forward only, how is it possible to get 2 tables of data at a time?

522


Which name space is used to get assembly details?

525


Which one of the objects is a high-level abstraction of the connection and command objects in ado.net?

636


How will you fill the gridview by using datatable object at runtime?

551