How to call the SQL commands asynchronously in ADO.NET
version 2.0
Answers were Sorted based on User's Feedback
Answer / jagan
here
executescalar()
executereader()
executenonquery()
these comes with Begin and End
like Beginexecutescalr()
Endexecutescalar()
.......
by using these command we can achieve asynch comm in
ado.net
Is This Answer Correct ? | 11 Yes | 7 No |
This is the sample code which tells asynchronous access
<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Configuration" %>
<script runat="server">
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection DBCon;
SqlCommand Command = new SqlCommand();
SqlDataReader OrdersReader;
IAsyncResult ASyncResult;
DBCon = new SqlConnection();
DBCon.ConnectionString =
ConfigurationManager.ConnectionStrings
["DSN_NorthWind"].ConnectionString;
Command.CommandText =
"SELECT TOP 5 Customers.CompanyName,
Customers.ContactName, " +
"Orders.OrderID, Orders.OrderDate, " +
"Orders.RequiredDate, Orders.ShippedDate " +
"FROM Orders, Customers " +
"WHERE Orders.CustomerID =
Customers.CustomerID " +
"ORDER BY Customers.CompanyName,
Customers.ContactName";
Command.CommandType = CommandType.Text;
Command.Connection = DBCon;
DBCon.Open();
// Starting the asynchronous processing
ASyncResult = Command.BeginExecuteReader();
// This loop with keep the main thread waiting
until the
// asynchronous process is finished
while (!ASyncResult.IsCompleted)
{
// Sleeping current thread for 10 milliseconds
System.Threading.Thread.Sleep(10);
}
// Retrieving result from the asynchronous process
OrdersReader = Command.EndExecuteReader
(ASyncResult);
// Displaying result on the screen
gvOrders.DataSource = OrdersReader;
gvOrders.DataBind();
// Closing connection
DBCon.Close();
}
</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
<title>The Poll Approach</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="gvOrders" runat="server"
AutoGenerateColumns="False" Width="100%">
<Columns>
<asp:BoundField HeaderText="Company Name"
DataField="CompanyName"></asp:BoundField>
<asp:BoundField HeaderText="Contact Name"
DataField="ContactName"></asp:BoundField>
<asp:BoundField HeaderText="Order Date"
DataField="orderdate"
DataFormatString="{0:d}"></asp:BoundField>
<asp:BoundField HeaderText="Required Date"
DataField="requireddate"
DataFormatString="{0:d}"></asp:BoundField>
<asp:BoundField HeaderText="Shipped Date"
DataField="shippeddate"
DataFormatString="{0:d}"></asp:BoundField>
</Columns>
</asp:GridView>
</div>
</form>
</body>
</html>
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / 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 |
Answer / radheshaym
executescalar()
executereader()
executenonquery()
these comes with Begin and End like Beginexecutescalr()
Endexecutescalar().......
by using these command we can achieve asynch comm in ado.net
Is This Answer Correct ? | 1 Yes | 2 No |
How to work with disconnected data - the dataset and sqldataadapter?
What does executereader return?
What is the difference between ado.net and entity framework?
What is the difference between oledb sql server and oledbdotnet provider?
What is bubbled event can you please explain?
Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?
What is the significance of CommandBehavior.CloseConnection ?
What are the Different layers in ADO.Net?
what is bubbled event can u pls explain
How do you update a dataset in ado.net and how do you update database through dataset?
Why is ADO.NET serialization slower than ADO ?
What is two way data binding android?