ASP.Net/ADO.net Database/DataReader — различия между версиями
Admin (обсуждение | вклад) м (1 версия) |
|
(нет различий)
|
Версия 18:30, 26 мая 2010
Using the DataReader mode for executing a SQL Statement
<source lang="csharp">
<%@ Page Language="C#" %> <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server">
<title>Using the DataReader mode for executing a SQL Statement</title>
</head> <body>
<form id="form1" runat="server">
<asp:SqlDataSource ID="categoriesSource" runat="server" ProviderName="System.Data.SqlClient" DataSourceMode="DataReader" ConnectionString="<%$ ConnectionStrings:AdventureWorks %>" SelectCommand="Select ProductSubcategoryID, Name from Production.ProductSubcategory"> </asp:SqlDataSource> Categories: <asp:DropDownList runat="server" DataSourceID="categoriesSource" DataValueField="ProductSubcategoryID" DataTextField="Name" AutoPostBack="true" ID="lstCategories" /> <asp:SqlDataSource ID="productsSource" runat="server" ProviderName="System.Data.SqlClient" DataSourceMode="DataReader" ConnectionString="<%$ ConnectionStrings:AdventureWorks %>" SelectCommand="Select ProductID, Name, ProductNumber, StandardCost from Production.Product Where ProductSubcategoryID=@ProductSubcategoryID"> <SelectParameters> <asp:ControlParameter ControlID="lstCategories" Name="ProductSubcategoryID" PropertyName="SelectedValue" /> </SelectParameters> </asp:SqlDataSource> <asp:GridView runat="server" DataSourceID="productsSource" HeaderStyle-HorizontalAlign="Center" HeaderStyle-Font-Bold="True" HeaderStyle-BackColor="blue" HeaderStyle-ForeColor="White" />
</form>
</body> </html> File: Web.config <configuration>
<appSettings/> <connectionStrings> <add name="AdventureWorks" connectionString="Data Source=localhost\SQLEXPRESS;Initial Catalog=AdventureWorks;Integrated Security=True" providerName="System.Data.SqlClient" /> </connectionStrings> <system.web> <compilation debug="true" strict="false" explicit="true"> <codeSubDirectories> <add directoryName="VB"></add> <add directoryName="CS"></add> </codeSubDirectories> </compilation> <pages> <namespaces> <clear/> <add namespace="System"/> <add namespace="System.Collections"/> <add namespace="System.Collections.Specialized"/> <add namespace="System.Configuration"/> <add namespace="System.Text"/> <add namespace="System.Text.RegularExpressions"/> <add namespace="System.Web"/> <add namespace="System.Web.Caching"/> <add namespace="System.Web.SessionState"/> <add namespace="System.Web.Security"/> <add namespace="System.Web.Profile"/> <add namespace="System.Web.UI"/> <add namespace="System.Web.UI.WebControls"/> <add namespace="System.Web.UI.WebControls.WebParts"/> <add namespace="System.Web.UI.HtmlControls"/> </namespaces> </pages> <authentication mode="Windows"></authentication> <identity impersonate="true"/> </system.web>
</configuration>
</source>