<%@ 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 OrdersCommand = new SqlCommand();
SqlCommand CustCommand = new SqlCommand();
SqlDataReader OrdersReader;
SqlDataReader CustReader;
IAsyncResult OrdersASyncResult;
IAsyncResult CustAsyncResult;
int WHIndex;
System.Threading.WaitHandle[] WHandles =
new System.Threading.WaitHandle[1];
System.Threading.WaitHandle OrdersWHandle;
System.Threading.WaitHandle CustWHandle;
DBCon = new SqlConnection();
DBCon.ConnectionString =
ConfigurationManager.ConnectionStrings["DSN_NorthWind"].ConnectionString;
CustCommand.CommandText =
"SELECT * FROM Customers WHERE CompanyName = 'Alfreds Futterkiste'";
CustCommand.CommandType = CommandType.Text;
CustCommand.Connection = DBCon;
OrdersCommand.CommandText =
"SELECT Customers.CompanyName, Customers.ContactName, " +
"Orders.OrderID, Orders.OrderDate, " +
"Orders.RequiredDate, Orders.ShippedDate " +
"FROM Orders, Customers " +
"WHERE Orders.CustomerID = Customers.CustomerID " +
"AND Customers.CompanyName = 'Alfreds Futterkiste' " +
"ORDER BY Customers.CompanyName, Customers.ContactName";
OrdersCommand.CommandType = CommandType.Text;
OrdersCommand.Connection = DBCon;
// Opening the database connection
DBCon.Open();
// Retrieving customer information asynchronously
CustAsyncResult = CustCommand.BeginExecuteReader();
// Retrieving orders list asynchronously
OrdersASyncResult = OrdersCommand.BeginExecuteReader();
CustWHandle = CustAsyncResult.AsyncWaitHandle;
OrdersWHandle = OrdersASyncResult.AsyncWaitHandle;
// Filling Wait Handles array with the two wait handles we
// are going to use in this code
WHandles[0] = CustWHandle;
WHandles[1] = OrdersWHandle;
// Looping 2 times because there are 2 wait handles
// in the array
for (int Index = 0; Index < 2; Index++ )
{
// We are only waiting for any of the two
// asynchronous process to finish running
WHIndex = System.Threading.WaitHandle.WaitAny(WHandles);
// The return value from the WaitAny method is
// the array index of the Wait Handle that just
// finsihed running
switch (WHIndex)
{
case 0:
CustReader = CustCommand.EndExecuteReader(CustAsyncResult);
gvCustomers.DataSource = CustReader;
gvCustomers.DataBind();
break;
case 1:
OrdersReader =
OrdersCommand.EndExecuteReader(OrdersASyncResult);
gvOrders.DataSource = OrdersReader;
gvOrders.DataBind();
break;
}
}
// Closing connection
DBCon.Close();
}
</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
<title>The Wait Any Approach</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="gvCustomers" Width="100%" runat="server"></asp:GridView>
<br /><br />
<asp:GridView ID="gvOrders" Width="100%" AutoGenerateColumns="False"
runat="server">
<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>
ASP.Net 3.5 高级编程 例子
需积分: 0 67 浏览量
2008-10-24
14:26:34
上传
评论
收藏 3.08MB RAR 举报
ASP.Net 3.5 高级编程 例子 （950个子文件） 
Global.asax 1KB Global.asax 1KB Global.asax 1KB Global.asax 954B Global.asax 954B Global.asax 954B Listing26-6.ascx 707B Listing26-5.ascx 707B Listing26-7.ascx 707B Listing26-4.ascx 707B Listing26-9.ascx 707B Listing26-8.ascx 707B Listing26-3.ascx 558B Listing26-2.ascx 226B Listing26-1.ascx 99B Listing27-8.ashx 445B Listing27-7.ashx 398B Listing 29-04.asmx 96B Listing9-4.aspx 7KB Listing9-13.aspx 7KB Listing9-17.aspx 7KB Listing9-16.aspx 7KB Listing9-9.aspx 7KB Listing9-10.aspx 7KB Listing9-8.aspx 7KB Listing9-11.aspx 6KB Listing9-12.aspx 6KB Listing9-15.aspx 6KB Listing9-3.aspx 6KB Listing9-7.aspx 6KB Listing9-6.aspx 6KB Listing9-2.aspx 6KB Listing 32-3.aspx 4KB Listing25-6.aspx 4KB Listing 32-3.aspx 4KB Listing25-8.aspx 4KB PatientForm.aspx 3KB CallbackNorthwind.aspx 3KB Listing25-10.aspx 3KB Listing 20-35.aspx 3KB Listing 08-23.aspx 3KB Listing 04-25.aspx 3KB Listing 32-14.aspx 2KB Listing 32-14.aspx 2KB Listing25-3.aspx 2KB Listing 08-10.aspx 2KB Listing 20-24.aspx 2KB Listing25-1.aspx 2KB Listing 20-06.aspx 2KB Listing 3-10.aspx 2KB Listing 08-11.aspx 2KB Listing 3-37.aspx 2KB Listing 17-18.aspx 2KB Listing 16-10.aspx 2KB Listing 15-02.aspx 2KB Listing 20-10.aspx 2KB Listing 20-32.aspx 2KB Listing 20-03.aspx 2KB Listing 3-46.aspx 2KB Listing 3-22.aspx 2KB Listing 14-15.aspx 2KB DynamicPopulateExtender.aspx 2KB SlideShowExtender.aspx 2KB Listing 20-11.aspx 2KB Listing 14-10.aspx 2KB Listing 3-40.aspx 2KB Listing 32-1.aspx 2KB Listing 04-12.aspx 2KB Listing 32-1.aspx 2KB Listing 20-33.aspx 2KB Listing25-26.aspx 1KB Default.aspx 1KB Listing 16-17.aspx 1KB Listing 20-20.aspx 1KB Listing 19-19.aspx 1KB Default.aspx 1KB Default.aspx 1KB Listing 3-12.aspx 1KB Listing 19-18.aspx 1KB Listing9-22.aspx 1KB Listing 19-19.aspx 1KB Listing26-8.aspx 1KB Listing 08-9.aspx 1KB Listing 19-04.aspx 1KB Listing 20-09.aspx 1KB Listing26-9.aspx 1KB Default.aspx 1KB Listing 04-15.aspx 1KB Listing 19-15.aspx 1KB Default.aspx 1KB Listing25-4.aspx 1KB Listing 19-18.aspx 1KB Listing25-2.aspx 1KB Listing 19-15.aspx 1KB Listing 08-8.aspx 1KB Listing 19-04.aspx 1KB Listing25-25.aspx 1KB Page1b.aspx 1KB Listing 16-27.aspx 1KB Listing 20-39.aspx 1KB共 950 条
- 1
- 2
- 3
- 4
- 5
- 6
- 10
评论0