Interested to Buy Any Domain ? << Click Here >> for more details...
How to call the SQL commands asynchronously in ADO.NET
version 2.0
- 4 Answers
- 14048 Views
- DELL, I also Faced
- E-Mail Answers
Answer Posted / kiran
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 |
Post New Answer View All Answers
Which is the feature of ado.net?
What are the steps you will take to improve performance?
What is ado and rdo?
Define the data provider classes that is supported by ado.net?
how can implement dropdownlist in particular of dataset when try to update?
What is difference between Dataview and Datatable?
What is two way data binding android?
What is bubbled event?
What are the benefits of using of ADO.NET in .NET 4.0?
What are the usages of the command object in ado.net?
Explain how to call the sql commands asynchronously in ado.net version 2.0?
What is the difference in record set and dataset?
Explain the difference in record set and dataset?
What is namespace in ado.net?
What does ole stand for in excel?
