http://nfex.ru/index.php?title=ASP.NET_Tutorial/ADO.net_Database/SqlAsyncResult&feed=atom&action=history
ASP.NET Tutorial/ADO.net Database/SqlAsyncResult - История изменений
2024-03-28T11:31:50Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://nfex.ru/index.php?title=ASP.NET_Tutorial/ADO.net_Database/SqlAsyncResult&diff=2665&oldid=prev
в 15:30, 26 мая 2010
2010-05-26T15:30:57Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr style="vertical-align: top;" lang="ru">
<td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td>
<td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 15:30, 26 мая 2010</td>
</tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>
http://nfex.ru/index.php?title=ASP.NET_Tutorial/ADO.net_Database/SqlAsyncResult&diff=2666&oldid=prev
Admin: 1 версия
2010-05-26T11:56:42Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>== Asynchronous command processing using the callback approach (C#)==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="csharp"><br />
<%@ Page Language="C#" %><br />
<%@ Import Namespace="System.Data" %><br />
<%@ Import Namespace="System.Data.SqlClient" %><br />
<%@ Import Namespace="System.Configuration" %><br />
<script runat="server"><br />
protected void Page_Load(object sender, EventArgs e)<br />
{<br />
SqlConnection DBCon;<br />
SqlCommand Command = new SqlCommand();<br />
SqlAsyncResult ASyncResult;<br />
DBCon = new SqlConnection();<br />
Command = new SqlCommand();<br />
DBCon.ConnectionString = ConfigurationManager.ConnectionStrings["DSN_NorthWind"].ConnectionString;<br />
Command.rumandText = <br />
"SELECT TOP 5 Customers.rupanyName, Customers.ContactName, " +<br />
" Orders.OrderID, Orders.OrderDate, " +<br />
" Orders.RequiredDate, Orders.ShippedDate " +<br />
" FROM Orders, Customers " +<br />
" WHERE Orders.CustomerID = Customers.CustomerID " +<br />
" ORDER BY Customers.rupanyName, Customers.ContactName ";<br />
Command.rumandType = CommandType.Text;<br />
Command.Connection = DBCon;<br />
DBCon.Open();<br />
AsyncResult = Command.BeginExecuteReader(new AsyncCallback(CBMethod), <br />
CommandBehavior.CloseConnection);<br />
}<br />
public void CBMethod(SQLAsyncResult ar)<br />
{<br />
SqlDataReader OrdersReader;<br />
OrdersReader = ar.EndExecuteReader(ar);<br />
gvOrders.DataSource = OrdersReader;<br />
gvOrders.DataBind();<br />
}<br />
</script><br />
<html xmlns="http://www.w3.org/1999/xhtml" ><br />
<head id="Head1" runat="server"><br />
<title>The Call Back Approach</title><br />
</head><br />
<body><br />
<form id="form1" runat="server"><br />
<div><br />
<asp:GridView ID="gvOrders" Width="100%" AutoGenerateColumns="False" <br />
Runat="server"><br />
<Columns><br />
<asp:BoundField HeaderText="Company Name" <br />
DataField="CompanyName"></asp:BoundField><br />
<asp:BoundField HeaderText="Contact Name" <br />
DataField="ContactName"></asp:BoundField><br />
<asp:BoundField HeaderText="Order Date" DataField="orderdate" <br />
DataFormatString="{0:d}"></asp:BoundField><br />
<asp:BoundField HeaderText="Required Date" DataField="requireddate" <br />
DataFormatString="{0:d}"></asp:BoundField><br />
<asp:BoundField HeaderText="Shipped Date" DataField="shippeddate" <br />
DataFormatString="{0:d}"></asp:BoundField><br />
</Columns><br />
</asp:GridView> <br />
</div><br />
</form><br />
</body><br />
</html><br />
File: Web.config<br />
<configuration><br />
<connectionStrings><br />
<add name="DSN_Northwind" <br />
connectionString="Data Source=localhost\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=True"<br />
providerName="System.Data.SqlClient" /><br />
</connectionStrings><br />
</configuration></source><br />
<br />
<br />
<br />
== Asynchronous command processing using the callback approach (VB)==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="csharp"><br />
<%@ Page Language="C#" %><br />
<%@ Import Namespace="System.Data" %><br />
<%@ Import Namespace="System.Data.SqlClient" %><br />
<%@ Import Namespace="System.Configuration" %><br />
<script runat="server"><br />
Private Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) <br />
Dim DBCon As SqlConnection<br />
Dim Command As SqlCommand = New SqlCommand()<br />
Dim ASyncResult As SqlAsyncResult<br />
DBCon = New SqlConnection()<br />
Command = New SqlCommand()<br />
DBCon.ConnectionString = _<br />
ConfigurationManager.ConnectionStrings("DSN_NorthWind").ConnectionString<br />
Command.rumandText = _<br />
"SELECT TOP 5 Customers.rupanyName, Customers.ContactName, " & _<br />
" Orders.OrderID, Orders.OrderDate, " & _<br />
" Orders.RequiredDate, Orders.ShippedDate " & _<br />
" FROM Orders, Customers " & _<br />
" WHERE Orders.CustomerID = Customers.CustomerID " & _<br />
" ORDER BY Customers.rupanyName, Customers.ContactName "<br />
Command.rumandType = CommandType.Text<br />
Command.Connection = DBCon<br />
DBCon.Open()<br />
AsyncResult = Command.BeginExecuteReader(New _<br />
AsyncCallback(AddressOf CBMethod), CommandBehavior.CloseConnection)<br />
End Sub<br />
Public Sub CBMethod(ByVal ar As SQLAsyncResult)<br />
Dim OrdersReader As SqlDataReader<br />
OrdersReader = ar.EndExecuteReader(ar)<br />
gvOrders.DataSource = OrdersReader<br />
gvOrders.DataBind()<br />
End Sub<br />
</script><br />
<html xmlns="http://www.w3.org/1999/xhtml" ><br />
<head id="Head1" runat="server"><br />
<title>The Call Back Approach</title><br />
</head><br />
<body><br />
<form id="form1" runat="server"><br />
<div><br />
<asp:GridView ID="gvOrders" Width="100%" AutoGenerateColumns="False" <br />
Runat="server"><br />
<Columns><br />
<asp:BoundField HeaderText="Company Name" <br />
DataField="CompanyName"></asp:BoundField><br />
<asp:BoundField HeaderText="Contact Name" <br />
DataField="ContactName"></asp:BoundField><br />
<asp:BoundField HeaderText="Order Date" DataField="orderdate" <br />
DataFormatString="{0:d}"></asp:BoundField><br />
<asp:BoundField HeaderText="Required Date" DataField="requireddate" <br />
DataFormatString="{0:d}"></asp:BoundField><br />
<asp:BoundField HeaderText="Shipped Date" DataField="shippeddate" <br />
DataFormatString="{0:d}"></asp:BoundField><br />
</Columns><br />
</asp:GridView> <br />
</div><br />
</form><br />
</body><br />
</html><br />
File: Web.config<br />
<configuration><br />
<connectionStrings><br />
<add name="DSN_Northwind" <br />
connectionString="Data Source=localhost\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=True"<br />
providerName="System.Data.SqlClient" /><br />
</connectionStrings><br />
</configuration></source></div>
Admin