BoundField with ItemStyle : BoundField « Data Binding « ASP.Net






BoundField with ItemStyle


<%@ Page Language="C#" %>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Formatting GridView using Styles</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:SqlDataSource ID="productsSource" runat="server"
            ProviderName="System.Data.SqlClient" 
            ConnectionString="<%$ ConnectionStrings:AdventureWorks %>"
            SelectCommand="Select ProductID, Name, ProductNumber, DaysToManufacture, SellStartDate from Production.Product">            
        </asp:SqlDataSource>
        <asp:GridView runat="server" 
                      ID="gridProducts" 
                      DataSourceID="productsSource"
                      Font-Names="Verdana" 
                      Font-Size="X-Small" 
                      ForeColor="#333333"
                      CellPadding="4" 
                      GridLines="None" 
                      AutoGenerateColumns="False">
             <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
             <RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
             <AlternatingRowStyle BackColor="White" />       
            <Columns>
                <asp:BoundField DataField="ProductID" HeaderText="ID">
                    <ItemStyle Font-Bold="True" BorderWidth="1" />
                </asp:BoundField>
                <asp:BoundField DataField="Name" HeaderText="Name">
                    <ItemStyle Wrap="True" Width="200"/>
                </asp:BoundField>
                <asp:BoundField DataField="ProductNumber" HeaderText="Number">
                    <ItemStyle BackColor="LightSteelBlue" />
                </asp:BoundField>
                <asp:BoundField DataField="DaysToManufacture" HeaderText="Days To Manufacture" />                
                <asp:BoundField DataField="SellStartDate" HeaderText="Sell Start Date"
                    DataFormatString="{0:MM/dd/yyyy}" />
            </Columns>
        </asp:GridView>
    </div>
    </form>
</body>
</html>
File: Web.config

<configuration>
  <appSettings/>
  <connectionStrings>
        <add name="AdventureWorks" 
             connectionString="Data Source=localhost\SQLEXPRESS;Initial Catalog=AdventureWorks;Integrated Security=True"
             providerName="System.Data.SqlClient" />
    </connectionStrings>
  <system.web>
    <compilation debug="true" strict="false" explicit="true">
      <codeSubDirectories>
        <add directoryName="VB"></add>
        <add directoryName="CS"></add>
      </codeSubDirectories>
    </compilation>
    <pages>
      <namespaces>
        <clear/>
        <add namespace="System"/>
        <add namespace="System.Collections"/>
        <add namespace="System.Collections.Specialized"/>
        <add namespace="System.Configuration"/>
        <add namespace="System.Text"/>
        <add namespace="System.Text.RegularExpressions"/>
        <add namespace="System.Web"/>
        <add namespace="System.Web.Caching"/>
        <add namespace="System.Web.SessionState"/>
        <add namespace="System.Web.Security"/>
        <add namespace="System.Web.Profile"/>
        <add namespace="System.Web.UI"/>
        <add namespace="System.Web.UI.WebControls"/>
        <add namespace="System.Web.UI.WebControls.WebParts"/>
        <add namespace="System.Web.UI.HtmlControls"/>
      </namespaces>
    </pages>
    <authentication mode="Windows"></authentication>
    <identity impersonate="true"/>
  </system.web>
</configuration>

 








Related examples in the same category

1.BoundField as GridView columns
2.Adding multicolumn sorting to the GridView (C#)
3.Adding multicolumn sorting to the GridView (VB)
4.Using the BoundField for explicitly specifying Columns