sqldatasource服务器分页 [英] sqldatasource server paging

问题描述

我需要使用sqldatasource（存储过程）来绑定gridview。

  <   asp：GridView     ID   =  gvBC    runat   =  server    AutoGenerateColumns   = 错误    ShowFooter   =  True    AllowSorting   =  True    AllowPaging   =  True     pageSize     =  3    DataSourceID   =  dsBCSearch  >  
 <  列 >  
 <   asp：BoundField     DataField   =  ContactID     HeaderText   =  ContactID   可见  =  false  /  >  
 <   asp：BoundField     DataField   =  BldgNum    HeaderText   =  Bldg＃    SortExpression   =  BldgNum    /  >  
 <   /列 >  
 <   EmptyDataTemplate  > 找不到建筑协调员。 <   / EmptyDataTemplate  >  
 <   EmptyDataRowStyle     Horizo​​ntalAlign   = 中心    /  >  
 <   / asp：GridView  >  
 <   asp：SqlDataSource     ID   =  dsBCSearch    runat   =  server    ConnectionString   =  <％ $ ConnectionStrings：DBConnStr％>    SelectCommand   =  GetBC    SelectCommandType   =  StoredProcedure    
   
   SortParameterName   =  SortExpression      /  >  

代码落后：

 受保护  void  Page_Load（ object  sender，EventArgs e）
 {
 LoadBC（）; 
} 
 受保护  void  LoadBC（）
 {
 dsBCSearch.SelectCommand =   GetBCwP; 
 dsBCSearch.SelectParameters.Clear（）; 
 
 dsBCSearch.SelectParameters.Add（  LName，此 .txtLNAme.Text.Trim（））; 
 dsBCSearch.SelectParameters.Add（  Active，此 .chkActive.Checked.ToString（））; 
  //   dsBCSearch.SelectParameters.Add（sortExpression，this.gvBC.SortExpression）;  
 dsBCSearch.SelectParameters.Add（  startRowIndex，此 .gvBC.PageIndex.ToString（））; 
 dsBCSearch.SelectParameters.Add（  maximumRows，此 .gvBC.PageSize.ToString（））; 
 
  this  .gvBC.DataBind（）; 
} 

现在只渲染第一页（3条记录），页脚显示没有数字。我可以为页脚添加分页吗？



谢谢

解决方案

ConnectionStrings：DBConnStr％> SelectCommand = GetBC SelectCommandType = StoredProcedure

SortParameterName = SortExpression / >

代码背后：

  protected   void  Page_Load（ object  sender，EventArgs e）
 { 
 LoadBC（）; 
} 
 受保护  void  LoadBC（）
 {
 dsBCSearch.SelectCommand =   GetBCwP; 
 dsBCSearch.SelectParameters.Clear（）; 
 
 dsBCSearch.SelectParameters.Add（  LName，此 .txtLNAme.Text.Trim（））; 
 dsBCSearch.SelectParameters.Add（  Active，此 .chkActive.Checked.ToString（））; 
  //   dsBCSearch.SelectParameters.Add（sortExpression，this.gvBC.SortExpression）;  
 dsBCSearch.SelectParameters.Add（  startRowIndex，此 .gvBC.PageIndex.ToString（））; 
 dsBCSearch.SelectParameters.Add（  maximumRows，此 .gvBC.PageSize.ToString（））; 
 
  this  .gvBC.DataBind（）; 
} 

现在只渲染第一页（3条记录），页脚显示没有数字。我可以在页脚添加分页吗？



谢谢

看看这个链接它可能对你有用。

使用对象数据源优化分页和排序 [ ^ ]

I need use sqldatasource(stored proc) to bind a gridview.

<asp:GridView ID="gvBC" runat="server" AutoGenerateColumns="False" ShowFooter="True" AllowSorting="True" AllowPaging="True" pageSize ="3" DataSourceID="dsBCSearch">
    <Columns>
        <asp:BoundField DataField="ContactID" HeaderText="ContactID" Visible="false"/>
        <asp:BoundField DataField="BldgNum" HeaderText="Bldg#" SortExpression="BldgNum" />
    </Columns>
    <EmptyDataTemplate> No Building Coordinator Found. </EmptyDataTemplate>
    <EmptyDataRowStyle HorizontalAlign="Center" /> 
</asp:GridView>
<asp:SqlDataSource ID="dsBCSearch" runat="server" ConnectionString="<%$ ConnectionStrings:DBConnStr %>" SelectCommand="GetBC" SelectCommandType="StoredProcedure" 

SortParameterName="SortExpression"  />

Code behind:

protected void Page_Load(object sender, EventArgs e)
{
    LoadBC();
}
protected void LoadBC()
{
    dsBCSearch.SelectCommand = "GetBCwP";
    dsBCSearch.SelectParameters.Clear();

    dsBCSearch.SelectParameters.Add("LName", this.txtLNAme.Text.Trim());
    dsBCSearch.SelectParameters.Add("Active", this.chkActive.Checked.ToString());
    //dsBCSearch.SelectParameters.Add("sortExpression", this.gvBC.SortExpression);
    dsBCSearch.SelectParameters.Add("startRowIndex", this.gvBC.PageIndex.ToString());
    dsBCSearch.SelectParameters.Add("maximumRows", this.gvBC.PageSize.ToString());

    this.gvBC.DataBind();
}

Now just render first page (3 records) and in footer no number showing up. HOw can I add paging to footer?

Thanks

解决方案

ConnectionStrings:DBConnStr %>" SelectCommand="GetBC" SelectCommandType="StoredProcedure" SortParameterName="SortExpression" />

Code behind:

protected void Page_Load(object sender, EventArgs e)
{
    LoadBC();
}
protected void LoadBC()
{
    dsBCSearch.SelectCommand = "GetBCwP";
    dsBCSearch.SelectParameters.Clear();

    dsBCSearch.SelectParameters.Add("LName", this.txtLNAme.Text.Trim());
    dsBCSearch.SelectParameters.Add("Active", this.chkActive.Checked.ToString());
    //dsBCSearch.SelectParameters.Add("sortExpression", this.gvBC.SortExpression);
    dsBCSearch.SelectParameters.Add("startRowIndex", this.gvBC.PageIndex.ToString());
    dsBCSearch.SelectParameters.Add("maximumRows", this.gvBC.PageSize.ToString());

    this.gvBC.DataBind();
}

Now just render first page (3 records) and in footer no number showing up. HOw can I add paging to footer?

Thanks

Have a look in this link it might help you.
Optimized Paging and Sorting using Object Data Source[^]

这篇关于sqldatasource服务器分页的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！