1.使用 GridView 控件和 SqlDataSource 控件显示乐知 班学生名单
<html xmlns="http://www.w3.org/1999/xhtml">
< head runat="server">
<title></title>
< /head>
< body>
<form id="form1" runat="server">
<div>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:MyTestConnectionString %>"
SelectCommand="SELECT [FName], [FId], [FAge], [FGender] FROM [MyStudents]">
</asp:SqlDataSource>
<br />
<br />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px"
CellPadding="3" DataKeyNames="FId" DataSourceID="SqlDataSource1" Height="161px"
Width="291px" AllowPaging="True">
<Columns>
<asp:CommandField ShowSelectButton="True" />
<asp:BoundField DataField="FName" HeaderText="FName" SortExpression="FName" />
<asp:BoundField DataField="FId" HeaderText="FId" InsertVisible="False" ReadOnly="True" SortExpression="FId" />
<asp:BoundField DataField="FAge" HeaderText="FAge" SortExpression="FAge" />
<asp:BoundField DataField="FGender" HeaderText="FGender" SortExpression="FGender" />
</Columns>
<FooterStyle BackColor="White" ForeColor="#000066" />
<HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
<RowStyle ForeColor="#000066" />
<SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
<SortedAscendingCellStyle BackColor="#F1F1F1" />
<SortedAscendingHeaderStyle BackColor="#007DBB" />
<SortedDescendingCellStyle BackColor="#CAC9C9" />
<SortedDescendingHeaderStyle BackColor="#00547E" />
</asp:GridView>
</div>
</form>
< /body>
< /html>
<html xmlns="http://www.w3.org/1999/xhtml">
< head runat="server">
<title></title>
< /head>
< body>
<form id="form1" runat="server">
<div>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:MyTestConnectionString %>"
SelectCommand="SELECT [FName], [FId], [FAge], [FGender] FROM [MyStudents]">
</asp:SqlDataSource>
<br />
<br />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px"
CellPadding="3" DataKeyNames="FId" DataSourceID="SqlDataSource1" Height="161px"
Width="291px" AllowPaging="True">
<Columns>
<asp:CommandField ShowSelectButton="True" />
<asp:BoundField DataField="FName" HeaderText="FName" SortExpression="FName" />
<asp:BoundField DataField="FId" HeaderText="FId" InsertVisible="False" ReadOnly="True" SortExpression="FId" />
<asp:BoundField DataField="FAge" HeaderText="FAge" SortExpression="FAge" />
<asp:BoundField DataField="FGender" HeaderText="FGender" SortExpression="FGender" />
</Columns>
<FooterStyle BackColor="White" ForeColor="#000066" />
<HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
<RowStyle ForeColor="#000066" />
<SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
<SortedAscendingCellStyle BackColor="#F1F1F1" />
<SortedAscendingHeaderStyle BackColor="#007DBB" />
<SortedDescendingCellStyle BackColor="#CAC9C9" />
<SortedDescendingHeaderStyle BackColor="#00547E" />
</asp:GridView>
</div>
</form>
< /body>
< /html>