如何实现GridView的手动分页.doc

如何实现GridView的手动分页
我们可以这样做。先要在Html界面中GridView中增加AllowPaging="True"接着做下面的
//在page_load事件中将GridView绑定数据库
protected void Page_Load(object sender, EventArgs e)
{
    string sqlstr=select * from TABLE;
    sqlconnection conn=new sqlconnection("数据库连接字串");
    DataSet mydataset = new DataSet();
    SqlDataAdapter myds = new SqlDataAdapter();
    myds.SelectCommand = new SqlCommand(sqlstr, conn);
    myds.Fill(mydataset);
    this.GridView1.DataSource = mydataset;
    mydataset.Dispose();
    myds.Dispose();
    conn.Close();
    conn.Dispose();
    GridView1.DataBind();
}
//GridView有一个PageIndexChanging事件
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
   GridView1.PageIndex = e.NewPageIndex;
   GridView1.DataBind();
}
这样就可以实现啦！
要使用手动分页前提是GridView没有使用数据源控件(sqldatasource.....)的时候。

 请教GridView的手动分页如何实现？谢谢!
请教GridView的手动分页(自定义分页)如何实现？
比如已知有10000条数据，我要GridView的分页功能来显示数据，但是自动分页功能需要每次都取出全部的10000条数据，这样效率不高，
所以就要求只用设置GridView的分页数如1000页(每页10知)，当选择第n页时才从数据库中取出对应的数据，请问怎样实现？
谢谢!

ASP.NET结合存储过程写的通用搜索分页程序
存储过程改自bigeagle的论坛分页程序。请大家批判！：）
select.aspx
----------------------------------------------
<%@ Page Language="C#" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.SqlClient" %>

    protected void Page_Load(Object sender, EventArgs e)
         {
             int intPageNo,intPageSize,intPageCount;
</p><p style='padding:5px 0px;'>6、             intPageSize = 25;
             if (Request["CurrentPage"]==null)
                 {
                     intPageNo = 1;
                 }
             else
                 {
                     intPageNo = Int32.Parse(Request["CurrentPage"]);
                 }
            </p><p style='padding:5px 0px;'>7、

             SqlConnection mySqlConnection = new SqlConnection("server=(local);Database=test;user id=sa;password=");
             SqlCommand mySqlCommand = new SqlCommand("up_GetTopicList", mySqlConnection);
             mySqlCommand.CommandType = CommandType.StoredProcedure;
  </p><p style='padding:5px 0px;'>8、          
             SqlParameter workParm;

             //搜索表字段，以","号分隔
             workParm = mySqlCommand.Parameters.Add("@a_TableList", SqlDbType.VarChar, 200);
             mySqlCommand.Parameters["@a_TableList"].Value = "OFFERID,type,offertime";

        </p><p style='padding:5px 0px;'>9、     //搜索表名
             workParm = mySqlCommand.Parameters.Add("@a_TableName", SqlDbType.VarChar, 30);
             mySqlCommand.Parameters["@a_TableName"].Value = "offer";

             //搜索条件，如"select * from aa where a=1 and b=2 and c=3"则条件为"where a=1 and b=2 and c=3"
         </p><p style='padding:5px 0px;'>10、    workParm = mySqlCommand.Parameters.Add("@a_SelectWhere", SqlDbType.VarChar, 500);
             mySqlCommand.Parameters["@a_SelectWhere"].Value = "where type='idl'";

             //表主键字段名，必须为INT类型
             workParm = mySqlCommand.Parameters.Add("@a_SelectOrderId", SqlDbType</p><p style='padding:5px 0px;'>11、VarChar, 50);
             mySqlCommand.Parameters["@a_SelectOrderId"].Value = "offerid";      

             //排序，可以使用多字段排序但主键字段必需在最前面
             workParm = mySqlCommand.Parameters.Add("@a_SelectOrder", SqlDbType.VarChar, 50);
             mySqlCommand.Parameters["@a_SelectOrd</p><p style='padding:5px 0px;'>12、er"].Value = "order by offerid desc";

             //页号
             workParm = mySqlCommand.Parameters.Add("@a_intPageNo", SqlDbType.Int);
             mySqlCommand.Parameters["@a_intPageNo"].Value = intPageNo;

             //每页显示数
             workParm = mySqlC</p><p style='padding:5px 0px;'>13、ommand.Parameters.Add("@a_intPageSize", SqlDbType.Int);
             mySqlCommand.Parameters["@a_intPageSize"].Value = intPageSize;

             //总记录数(存储过程输出参数)
             workParm = mySqlCommand.Parameters.Add("@RecordCount", SqlDbType.Int);
             workParm.Direction = </p><p style='padding:5px 0px;'>14、ParameterDirection.Output;            

             //当前页记录数(存储过程返回值)
             workParm = mySqlCommand.Parameters.Add("RowCount", SqlDbType.Int);
             workParm.Direction = ParameterDirection.ReturnValue;
             mySqlConnection.Open();
             Repeater.Data</p><p style='padding:5px 0px;'>15、Source = mySqlCommand.ExecuteReader();                                  

             Repeater.DataBind();

             mySqlConnection.Close();

             Int32 RecordCount = (Int32)mySqlCommand.Parameters["@RecordCount"].Value;
             Int32</p><p style='padding:5px 0px;'>16、 RowCount = (Int32)mySqlCommand.Parameters["RowCount"].Value;

             LabelRecord.Text = RecordCount.ToString();
             LabelRow.Text = intPageNo.ToString();
             intPageCount = RecordCount/intPageSize;
             if ((RecordCount%intPageSize)>0)
            </p><p style='padding:5px 0px;'>17、     intPageCount += 1;
             LabelPage.Text = intPageCount.ToString();

             if (intPageNo>1)
                 {
                     HLFistPage.NavigateUrl = "select.aspx?CurrentPage=1";
                     HLPrevPage.NavigateUrl = String.Concat("select.aspx?Curr</p><p style='padding:5px 0px;'>18、entPage=","",intPageNo-1);
                 }
             else
                 {
                     HLFistPage.NavigateUrl = "";
                     HLPrevPage.NavigateUrl = "";
                     //HLFistPage.Enabled = false;
                     //HLPrevPage.Enabled = false;
       </p><p style='padding:5px 0px;'>19、          }

             if (intPageNo<intPageCount)
                 {
                     HLNextPage.NavigateUrl = String.Concat("select.aspx?CurrentPage=","",intPageNo+1);
                     HLEndPage.NavigateUrl = String.Concat("select.aspx?CurrentPage=","",intPageCount</p><p style='height:0px;padding:0;overflow:hidden'>20、);
                 }
             else
                 {
                     HLNextPage.NavigateUrl = "";
                     HLEndPage.NavigateUrl = "";
                     //HLNextPage.Enabled=false;
                     //HLEndPage.Enabled=false;
                 }

  </p><p style='height:0px;padding:0;overflow:hidden'>21、       }

.high {  font-family: "宋体"; font-size: 9pt; line-height: 140%}
.mid {  font-size: 9pt; line-height: 12pt}
.small {  f</p><p style='height:0px;padding:0;overflow:hidden'>22、ont-size: 9pt; line-height: normal}
.TP10_5 {
    font-size: 14px;
    line-height: 140%;
}

    A:link {
    COLOR: #cc6666
}

             |
              |

      adding="0">

                ble>

      olor="#FFFFFF">分配状态
CREATE proc up_GetTopicList
       @a_TableList Varchar(200),
       @a_TableName Varchar(30),
       @a_SelectWhere Varchar(500),
       @a_SelectOrderId Varchar(20),
       @a_SelectOrder Varchar(50),
       @a_intPageNo int,
       @a_intPageSize int,
       @RecordCount int OUTPUT
as
   /*定义局部变量*/
   declare @intBeginID         int
   declare @intEndID           int
   declare @intRootRecordCount int
   declare @intRowCount        int
   declare @TmpSelect          NVarchar(600)
   /*关闭计数*/
   set nocount on

   /*求总共根贴数*/
   select @TmpSelect = 'set nocount on;select @SPintRootRecordCount = count(*) from '+@a_TableName+' '+@a_SelectWhere
   execute sp_executesql
             @TmpSelect,
             N'@SPintRootRecordCount int OUTPUT',
             @SPintRootRecordCount=@intRootRecordCount OUTPUT
select @RecordCount = @intRootRecordCount
   if (@intRootRecordCount = 0)    --如果没有贴子，则返回零
       return 0

   /*判断页数是否正确*/
   if (@a_intPageNo - 1) * @a_intPageSize > @intRootRecordCount
      return (-1)
   /*求开始rootID*/
   set @intRowCount = (@a_intPageNo - 1) * @a_intPageSize + 1
   /*限制条数*/
   select @TmpSelect = 'set nocount on;set rowcount @SPintRowCount;select @SPintBeginID = '+@a_SelectOrderId+' from '+@a_TableName+' '+@a_SelectWhere+' '+@a_SelectOrder
   execute sp_executesql
             @TmpSelect,
             N'@SPintRowCount int,@SPintBeginID int OUTPUT',
             @SPintRowCount=@intRowCount,@SPintBeginID=@intBeginID OUTPUT

   /*结束rootID*/
   set @intRowCount = @a_intPageNo * @a_intPageSize
   /*限制条数*/
   select @TmpSelect = 'set nocount on;set rowcount @SPintRowCount;select @SPintEndID = '+@a_SelectOrderId+' from '+@a_TableName+' '+@a_SelectWhere+' '+@a_SelectOrder
   execute spexecutesql
             @TmpSelect,
             N'@SPintRowCount int,@SPintEndID int OUTPUT',
             @SPintRowCount=@intRowCount,@SPintEndID=@intEndID OUTPUT

if @a_SelectWhere='' or @a_SelectWhere IS NULL
   select @TmpSelect = 'set nocount off;set rowcount 0;select '+@a_TableList+' from '+@a_TableName+' where '+@a_SelectOrderId+' between '
else
   select @TmpSelect = 'set nocount off;set rowcount 0;select '+@a_TableList+' from '+@a_TableName+' '+@a_SelectWhere+' and '+@a_SelectOrderId+' between '
if @intEndID > @intBeginID
   select @TmpSelect = @TmpSelect+'@SPintBeginID and @SPintEndID'+' '+@a_SelectOrder
else
   select @TmpSelect = @TmpSelect+'@SPintEndID and @SPintBeginID'+' '+@a_SelectOrder
   execute sp_executesql
             @TmpSelect,
             N'@SPintEndID int,@SPintBeginID int',
             @SPintEndID=@intEndID,@SPintBeginID=@intBeginID
   return(@@rowcount)
   --select @@rowcount
GO

关于我们      便捷服务       自信AI       AI导航        抽奖活动©2010-2026 宁波自信网络信息技术有限公司  版权所有客服电话：[phone]  投诉电话：[phone]浙公网安备33021202000488号   浙ICP备2021020529号-1  |  浙B2-20240490  关注我们 ：