http://nfex.ru/index.php?action=history&feed=atom&title=ASP.Net%2FADO.net_Database%2FDataReader
ASP.Net/ADO.net Database/DataReader - История изменений
2026-04-30T09:48:48Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://nfex.ru/index.php?title=ASP.Net/ADO.net_Database/DataReader&diff=1674&oldid=prev
в 15:30, 26 мая 2010
2010-05-26T15:30:47Z
<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/ADO.net_Database/DataReader&diff=1675&oldid=prev
Admin: 1 версия
2010-05-26T11:51:07Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>==Using the DataReader mode for executing a SQL Statement==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="csharp"><br />
<%@ Page Language="C#" %><br />
<html xmlns="http://www.w3.org/1999/xhtml" ><br />
<head runat="server"><br />
<title>Using the DataReader mode for executing a SQL Statement</title><br />
</head><br />
<body><br />
<form id="form1" runat="server"><br />
<div><br />
<asp:SqlDataSource ID="categoriesSource" <br />
runat="server"<br />
ProviderName="System.Data.SqlClient" <br />
DataSourceMode="DataReader"<br />
ConnectionString="<%$ ConnectionStrings:AdventureWorks %>"<br />
SelectCommand="Select ProductSubcategoryID, Name from Production.ProductSubcategory"> <br />
</asp:SqlDataSource><br />
Categories: <br />
<asp:DropDownList runat="server" <br />
DataSourceID="categoriesSource"<br />
DataValueField="ProductSubcategoryID" <br />
DataTextField="Name" <br />
AutoPostBack="true"<br />
ID="lstCategories" /><br />
<asp:SqlDataSource ID="productsSource" <br />
runat="server"<br />
ProviderName="System.Data.SqlClient" <br />
DataSourceMode="DataReader"<br />
ConnectionString="<%$ ConnectionStrings:AdventureWorks %>"<br />
SelectCommand="Select ProductID, Name, ProductNumber, StandardCost from Production.Product Where ProductSubcategoryID=@ProductSubcategoryID"><br />
<SelectParameters><br />
<asp:ControlParameter <br />
ControlID="lstCategories" <br />
Name="ProductSubcategoryID"<br />
PropertyName="SelectedValue" /><br />
</SelectParameters><br />
</asp:SqlDataSource><br />
<asp:GridView runat="server" DataSourceID="productsSource"<br />
HeaderStyle-HorizontalAlign="Center" HeaderStyle-Font-Bold="True"<br />
HeaderStyle-BackColor="blue" HeaderStyle-ForeColor="White" /> <br />
</div><br />
</form><br />
</body><br />
</html><br />
File: Web.config<br />
<configuration><br />
<appSettings/><br />
<connectionStrings><br />
<add name="AdventureWorks" <br />
connectionString="Data Source=localhost\SQLEXPRESS;Initial Catalog=AdventureWorks;Integrated Security=True"<br />
providerName="System.Data.SqlClient" /><br />
</connectionStrings><br />
<system.web><br />
<compilation debug="true" strict="false" explicit="true"><br />
<codeSubDirectories><br />
<add directoryName="VB"></add><br />
<add directoryName="CS"></add><br />
</codeSubDirectories><br />
</compilation><br />
<pages><br />
<namespaces><br />
<clear/><br />
<add namespace="System"/><br />
<add namespace="System.Collections"/><br />
<add namespace="System.Collections.Specialized"/><br />
<add namespace="System.Configuration"/><br />
<add namespace="System.Text"/><br />
<add namespace="System.Text.RegularExpressions"/><br />
<add namespace="System.Web"/><br />
<add namespace="System.Web.Caching"/><br />
<add namespace="System.Web.SessionState"/><br />
<add namespace="System.Web.Security"/><br />
<add namespace="System.Web.Profile"/><br />
<add namespace="System.Web.UI"/><br />
<add namespace="System.Web.UI.WebControls"/><br />
<add namespace="System.Web.UI.WebControls.WebParts"/><br />
<add namespace="System.Web.UI.HtmlControls"/><br />
</namespaces><br />
</pages><br />
<authentication mode="Windows"></authentication><br />
<identity impersonate="true"/><br />
</system.web><br />
</configuration><br />
</source></div>
Admin