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
- 14272 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
What are good ado.net object to replace to ado recordset object.
What are the methods of XML dataset object?
What are the different ado.net namespaces?
How is it possible to get 2 tables of data at a time by using data reader?
What is the difference between an ADO.NET Dataset and an ADO Recordset?
What is ole in vb?
How does ado.net work?
What is the difference between oledb sql server and oledbdotnet provider?
Is ado.net dead?
What property must be set and what method must be called in your code to bind the data from some data source to the Repeater control?
differences between ADO and ADO.NET
What is XML serialization
What is the use of connection object in ado.net?
Which parameter of ConnectionString is used to specify the name of the database?
What is a datagridview?
