ADO Database ASP.Net




    Untitled Page


    
    

                     DataKeyNames="CustomerID" AllowPaging="True">
            
                CustomerID:
                ' Runat="server"
                     ID="CustomerIDLabel1">
                
                CompanyName:
                ' Runat="server"
                     ID="CompanyNameTextBox">
                ContactName:
                ' Runat="server"
                     ID="ContactNameTextBox">
                ContactTitle:
                ' Runat="server"
                    ID="ContactTitleTextBox">
                Address:
                ' Runat="server"
                     ID="AddressTextBox">
                City:
                ' Runat="server"
                     ID="CityTextBox">
                Region:
                ' Runat="server"
                     ID="RegionTextBox">
                PostalCode:
                ' Runat="server"
                     ID="PostalCodeTextBox">
                Country:
                ' Runat="server"
                     ID="CountryTextBox">
                Phone:
                ' Runat="server"
                     ID="PhoneTextBox">
                Fax:
                ' Runat="server"
                     ID="FaxTextBox">
                
                                     CommandName="update" />
                                     CommandName="cancel" />
            

            
              CustomerID:                                 Text='<%# Bind("CustomerID") %>'>
                                 
              CompanyName:                                 Text='<%# Bind("CompanyName") %>'>
                                 
              ContactName:                                 Text='<%# Bind("ContactName") %>'>
                                 
              ContactTitle:                                 Text='<%# Bind("ContactTitle") %>'>
                                 
                                                            Text='<%# Bind("Address") %>'>
                                             
                                                            Text='<%# Bind("City") %>'>
                                             
                                                            Text='<%# Bind("Region") %>'>
                                             
                                                           Runat="server" 
                                            Text='<%# Bind("PostalCode") %>'>
                                            
                                                            Text='<%# Bind("Country") %>'>
                                             
               Phone:                                                   Text='<%# Bind("Phone") %>'>
                                                   
               Fax:                                             Text='<%# Bind("Fax") %>'>
                                             
                                                Text="Edit" CommandName="edit" />
            

        
                     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" />