|
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>
<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>
|