<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Configuration" %>
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();
ASyncResult = Command.BeginExecuteReader();
while (!ASyncResult.IsCompleted)
{
System.Threading.Thread.Sleep(10);
}
OrdersReader = Command.EndExecuteReader(ASyncResult);
gvOrders.DataSource = OrdersReader;
gvOrders.DataBind();
DBCon.Close();
}
The Poll Approach