Chapter 5
:在表中显示数据
使用GridView 控件:
<asp:GridView ID="GridView1" runat="server"
DataSourceID="SqlDataSource1">
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:MdfNorthwind %>"
SelectCommand="SELECT * FROM [Products]">
</asp:SqlDataSource>
从web.config中取得连接字符串:
<connectionStrings>
<add name="MdfNorthwind"
connectionString="Server=./SQLExpress;
AttachDbFileName=|DataDirectory|/Northwind.mdf;
Integrated Security=True;
User Instance=true"
ProviderName="System.Data.SqlClient" />
</connectionStrings>
Bound Field
:
<asp:BoundColumn ...
HtmlEncode="false"
DataFormatString="My prefix {0:x} My suffix"
CheckBox Field
:
<asp:CheckBoxField HeaderText="Discontinued"
DataField="Discontinued" />
使用 DetailsView 控件:
<asp:DetailsView ID="DetailsView1" Runat="server"
DataSourceID="SqlDataSource1"
DataKeyNames="ProductID"
AllowPaging="True" AutoGenerateRows="false">
<Fields>
<asp:BoundField ReadOnly="True" HeaderText="ProductID"
InsertVisible="False" DataField="ProductID"
SortExpression="ProductID" />
<asp:BoundField HeaderText="Name" DataField="ProductName"
SortExpression="ProductName" />
<asp:BoundField HeaderText="SupplierID"
DataField="SupplierID" SortExpression="SupplierID" />
<asp:BoundField HeaderText="CategoryID"
DataField="CategoryID" SortExpression="CategoryID" />
... (additional bound fields)
<asp:CheckBoxField HeaderText="Discontinued"
SortExpression="Discontinued" DataField="Discontinued" />
</Fields>
</asp:DetailsView>
<asp:SqlDataSource ID="SqlDataSource1" Runat="server"
ConnectionString="<%$ ConnectionStrings:MdfNorthwind %>"
SelectCommand="SELECT * FROM Products" />