Mega Code Archive

 
Categories / ASP.Net Tutorial / Data Binding
 

Set RowStyle and HeaderStyle for GridView

Property                  Description DataField                 Identifies the field DataFormatString          Formats the field.  ApplyFormatInEditMode     format the value even when editing.                            The default is false,                            FooterText, HeaderText    text in header and footer and HeaderImageUrl         ReadOnly                  it prevents the value from being changed in edit mode.  InsertVisible             If true, it prevents the value being set in insert mode.                      Visible                    SortExpression            Sorts your results based on one or more columns.  HtmlEncode                If true (the default), all text will be HTML encoded to prevent special characters from mangling the page.  NullDisplayText           Displays the text that will be shown for a null value.                            The default is an empty string                            ConvertEmptyStringToNull  If true, converts all empty strings to null values. ControlStyle              Configures the appearance  HeaderStyle FooterStyle and ItemStyle  <%@ Page Language="C#" AutoEventWireup="true"%> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server">     <title>Untitled Page</title> </head> <body>     <form id="form1" runat="server">     <div>         <table>             <tr>                 <td valign="top" style="width: 328px">                     Global style settings:<br />                     <asp:GridView ID="GridView1"                                    runat="server"                                    DataSourceID="SqlDataSource1"                                   AutoGenerateColumns="false">                                  <RowStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" />                                         <HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#F7F7F7" />                        <Columns>                          <asp:BoundField DataField="ProductID" HeaderText="ID" />                          <asp:BoundField DataField="ProductName" HeaderText="Product Name" />                          <asp:BoundField DataField="UnitPrice" HeaderText="Price" />                        </Columns>                     </asp:GridView>                 </td>                 <td valign="top" style="width: 358px">                     Column-specific styles:<br />                     <asp:GridView ID="GridView2"                                    runat="server"                                    DataSourceID="SqlDataSource1"                                   AutoGenerateColumns="false" >                      <Columns>                          <asp:BoundField DataField="ProductID" HeaderText="ID" />                          <asp:BoundField DataField="ProductName" HeaderText="Product Name">                             <ItemStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" />                                                 <HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#F7F7F7" />                          </asp:BoundField>                          <asp:BoundField DataField="UnitPrice" HeaderText="Price" />                      </Columns>                     </asp:GridView>                 </td>             </tr>         </table>         &nbsp;<br />         <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:Northwind %>"             SelectCommand="SELECT ProductID, ProductName, UnitPrice FROM Products"></asp:SqlDataSource>          </div>     </form> </body> </html> File: Web.config <?xml version="1.0"?> <configuration>   <connectionStrings>     <add name="Northwind" connectionString="Data Source=localhost\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=SSPI"/>   </connectionStrings> </configuration>