ADO Database ASP.Net

  1. Home
  2. ASP.Net
  3. ADO Database
  4. Typical SqlDataSource control generated by Visual Studio





    Untitled Page


    
    

                                   Runat="server" 
                           SelectCommand="SELECT * FROM [Customers]"
                           ConnectionString="<%$ ConnectionStrings:AppConnectionString1 %>">
        
    

    


File: Web.config

  
  
                     connectionString="Data Source=localhost\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=True"
             providerName="System.Data.SqlClient" />