ADO Database ASP.Net

  1. Home
  2. ASP.Net
  3. ADO Database
  4. SqlDataSource with Parameters
<%@ Page Language="C#" AutoEventWireup="true"%>
               "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">


    Untitled Page


    
    

                                   runat="server" 
                           ProviderName="System.Data.SqlClient" 
                           ConnectionString="<%$ ConnectionStrings:Northwind %>" 
                           SelectCommand="SELECT EmployeeID, FirstName, LastName, Title, City FROM Employees WHERE City=@City">
            
                                                      Name="City" 
                                      PropertyName="SelectedValue" />
            
        
                                   runat="server" 
                           ProviderName="System.Data.SqlClient" 
                           ConnectionString="<%$ ConnectionStrings:Northwind %>" 
                           SelectCommand="SELECT DISTINCT City FROM Employees">
        
                                  runat="server"
                          DataSourceID="sourceEmployeeCities"
                          DataTextField="City"
                          Width="205px"
                          AutoPostBack="True">
        
                              runat="server"
                      DataSourceID="sourceEmployees"
                      CellPadding="4"
                      Font-Names="Verdana"
                      Font-Size="Small"
                      ForeColor="Navy"
                      GridLines="None"
                      AutoGenerateColumns="False" 
                      DataKeyNames="EmployeeID">
            
            
            
            
            
            
            
                                    ReadOnly="True" SortExpression="EmployeeID" />
                
                
                
                
            
        
    

    


File: Web.config