Data Binding ASP.Net

  1. Home
  2. ASP.Net
  3. Data Binding
  4. Using Templated Columns with GridView
<%@ Page Language="C#" %>


    Using Templated Columns with GridView


    
    

                    ProviderName="System.Data.SqlClient" 
            ConnectionString="<%$ ConnectionStrings:AdventureWorks %>"
            SelectCommand="Select ProductID, Name, ProductNumber, DaysToManufacture, SellStartDate, ReorderPoint from Production.Product">            
        
                   AutoGenerateColumns="False">              
            
                
                    
                            <%# Eval("ProductID") %> -
                            <%# Eval("Name") %>                            
                            Product Number: <%# Eval("ProductNumber") %>
                            Days to manufacture:<%# Eval("DaysToManufacture") %> 
                            Start Date: <%# Eval("SellStartDate", "{0:MM/dd/yy}") %>                                  
                            Reorder Point:<%# Eval("ReorderPoint") %>