Data Binding ASP.Net

  1. Home
  2. ASP.Net
  3. Data Binding
  4. BoundField with ItemStyle
<%@ Page Language="C#" %>


    Formatting GridView using Styles


    
    

                    ProviderName="System.Data.SqlClient" 
            ConnectionString="<%$ ConnectionStrings:AdventureWorks %>"
            SelectCommand="Select ProductID, Name, ProductNumber, DaysToManufacture, SellStartDate from Production.Product">            
        
                              ID="gridProducts" 
                      DataSourceID="productsSource"
                      Font-Names="Verdana" 
                      Font-Size="X-Small" 
                      ForeColor="#333333"
                      CellPadding="4" 
                      GridLines="None" 
                      AutoGenerateColumns="False">
             
             
                    
            
                
                    
                
                
                    
                
                
                    
                
                                
                                    DataFormatString="{0:MM/dd/yyyy}" />
            
        
    

    


File: Web.config

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