<html><head runat="server">
<title>Display GridView</title>
</head><body>
<form id="frmGridViewExample2" runat="server">
<asp:GridView DataSourceID="gvExample"
Runat="Server" AllowSorting="True" AllowPaging="True" PageSize="10"
AutoGenerateColumns="False" BackColor="#c0c0c0" BorderColor="black"
BorderStyle="Groove" BorderWidth="5" Caption="GridView Example" />
<asp:SqlDataSource ID="gvExample"
ConnectionString="Server=localhost;Database=Northwind;Trusted_Connection=true"
SelectCommand="SELECT EmployeeID, LastName, FirstName FROM Employees" Runat="Server">
<Columns>
<ItemTemplate HeaderText="Employee#v>
<asp:Label Runat="Server"
ForeColor="Red" Font-Bold="True" Text='<%# Eval("EmployeeID") %>'/>
</ItemTemplate>
<asp:BoundField DataField="LastName" NullDisplayText="--" />
<asp:BoundField DataField="FirstName" NullDisplayText="---" />
</Columns>
</asp:GridView>
</form></body></html>
用户评论