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
Define data access layer?
What is an example of ordinal data?
What is datasource in ado.net?
What is difference between entity framework and ado.net?
What does sqldatareader return?
What is microsoft ado.net?
What are the pre-requisites for connection pooling?
Does entity framework use ado.net?
What are the benefits of using ado.net?
What are all the classes that are available in System.Data Namespace?
Explain the difference in an abstract class and an interface?
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?
Which name space is used to get assembly details?
Which one of the objects is a high-level abstraction of the connection and command objects in ado.net?
How will you fill the gridview by using datatable object at runtime?