Beginning ASP.NET 2.0 and Databases学习笔记（4）

 

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