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
How can you add or remove rows from the datatable object of dataset?
Define the data provider classes that is supported by ado.net?
What is connection in ado.net?
Which one of the objects is a high-level abstraction of the connection and command objects in ado.net?
What is oledb connection?
List the 4 common ado.net namespaces?
What is the difference between statement and preparedstatement interface?
What is a non query?
What is full form of ado?
I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, how do you check whether all the 10 records were present while updating the data(which event and steps) and throw the exception 28 can datareader hold data from multiple tables?
What are the key events of sqlconnection class?
What is the difference between data grid and data repeater?
What are the benefits of using ado.net?
Define Execute Reader?
If we are not returning any records from the database, which method is to be used?