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
What is disconnected architecture in ado.net?
What are the advantages of oledb compared with other classes?
What are the difference between readonly vs. Const?
Which components of a data provider is used to retrieve, insert, delete, or modify data in a data source?
Is it possible to load multiple tables in a Dataset?
How is entity framework different from ado.net?
What is sqldatasource?
What is namespace in ado.net?
What is openquery?
Explain advantages of ado.net?
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?
What is adodb dll?
Which ado.net object is very fast in getting data from the database?
Can we load multiple tables in a dataset?
Which object is used to add relationship between two Datatables?