ASP.Net/ADO.net Database/DataReader

Материал из .Net Framework эксперт
Перейти к: навигация, поиск

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>
Источник — «http://nfex.ru/index.php?title=ASP.Net/ADO.net_Database/DataReader&oldid=1675»