Mega Code Archive

 

Categories / ASP.Net / ADO Database

 

Filtering SqlDataSource data with a FilterExpression

<asp:SqlDataSource ID="SqlDataSource2" runat="server"       SelectCommand="SELECT * FROM [Customers]"      FilterExpression="CustomerID='@CustomerID'"      ConnectionString="<%$ ConnectionStrings:AppConnectionString1 %>">      <FilterParameters>          <asp:ControlParameter Name="CustomerID" ControlId="GridView1"               PropertyName="SelectedValue"></asp:ControlParameter>      </FilterParameters> </asp:SqlDataSource> File: Web.config <configuration>   <appSettings/>   <connectionStrings>         <add name="AppConnectionString1"               connectionString="Data Source=localhost\SQLEXPRESS;Initial Catalog=Northwind;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>