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 XML serialization
How can we load multiple tables in a dataset?
What is the procedure to call a Stored Procedure of Back End in ADO (ActiveX Data Object) and RDO (Remote Data Objects)?
How to enable and disable connection pooling?
What are the different methods available under the sqlcommand class to access the data?
What is ado oledb and odbc?
What is the return type of executescalar?
How can you identify whether or not any changes are made to the DataSet object since it was last loaded?
What do you know about ado.net's methods?
What are the benefits of ADO.NET?
What is DataReader Object?
What is the difference between Optimistic and Pessimistic locking?
Explain how to find the given query is optimised one or not?
What are the essential features of ado.net?
What is sqldatareader in ado.net?