Mega Code Archive

 
Categories / ASP.Net / ADO Database
 

Using the DataReader mode for executing a SQL Statement

<%@ 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">     <div>         <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" />             </div>     </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>