Mega Code Archive

 
Categories / ASP.Net / Data Binding
 

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>