DetailsView分页显示数据

aspx页面部分：

        <asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" Height="50px"
            Width="500px" AllowPaging="True" DataSourceID="SqlDataSource">
            <Fields>
                  <asp:BoundField Datafield="xsxm" HeaderText="姓名" ReadOnly="true"/>                   
                  <asp:BoundField Datafield="xsxb"  HeaderText="性别"/>
                  <asp:BoundField Datafield="xss"   HeaderText="所在地"/>                   
                </Fields>
        </asp:DetailsView>

        <asp:SqlDataSource ID="SqlDataSource"
          SelectCommand="use xsrxglxt select xsxm,xsxb,xss from S_xs"
          connectionstring="<%$ ConnectionStrings:NorthwindConnection %>"
          RunAt="server"/>

 

web.config部分：

添加connectionStrings

<connectionStrings>
    <add name="NorthwindConnection" connectionString="Data Source=xmuserver;Initial Catalog=xsrxglxt;Persist Security Info=True;User ID=sa;Password=x3m0u8;MultipleActiveResultSets=False;Packet Size=4096;Application Name=&quot;Microsoft SQL Server Management Studio&quot;" providerName="System.Data.SqlClient"/>
  </connectionStrings>

 

效果：