GridView用存储过程自定义分页分页的完整例子

hongcha99
衣带渐宽终不悔，为书消得人憔悴。
等级:

发表于：2008-01-07 12:04:253楼得分:0

后台代码
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Text.RegularExpressions;
public partial class cpjsq : System.Web.UI.Page
{
public int curPage = 1;//当前页
public int totalPage = 0;//总的页数
public static string item;
protected void Page_Load(object sender, EventArgs e)
{
if(!Page.IsPostBack)
{
if (Request["item"] != null)
{
item = Request["item"].ToString();
}
int intPageNo, intPageSize, intPageCount;
intPageSize = 6;//OK!!!!!
if (Request["CurrentPage"] == null)
{
intPageNo = 1;
}
else
{
intPageNo = Int32.Parse(Request["CurrentPage"]);
}
SqlConnection mySqlConnection = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["BBB"]);
SqlCommand mySqlCommand = new SqlCommand("up_GetTopicList", mySqlConnection);
mySqlCommand.CommandType = CommandType.StoredProcedure;

SqlParameter workParm;
//newsid,newstitle,newscontent,newsdatetime,newscategory
//搜索表字段，以","号分隔
workParm = mySqlCommand.Parameters.Add("@a_TableList", SqlDbType.VarChar, 200);
mySqlCommand.Parameters["@a_TableList"].Value = "ID,LJ,JS,WZ";

//搜索表名
workParm = mySqlCommand.Parameters.Add("@a_TableName", SqlDbType.VarChar, 30);
mySqlCommand.Parameters["@a_TableName"].Value = "cpjs";

//搜索条件，如"select * from aa where a=1 and b=2 and c=3"则条件为"where a=1 and b=2 and c=3"
workParm = mySqlCommand.Parameters.Add("@a_SelectWhere", SqlDbType.VarChar, 500);
mySqlCommand.Parameters["@a_SelectWhere"].Value = " where JS like '%" + item + "%'";
//mySqlCommand.Parameters["@a_SelectWhere"].Value = "where newsid <>'10000000'";

//表主键字段名，必须为INT类型
workParm = mySqlCommand.Parameters.Add("@a_SelectOrderId", SqlDbType.VarChar, 50);
mySqlCommand.Parameters["@a_SelectOrderId"].Value = "ID";

//排序，可以使用多字段排序但主键字段必需在最前面
workParm = mySqlCommand.Parameters.Add("@a_SelectOrder", SqlDbType.VarChar, 50);
mySqlCommand.Parameters["@a_SelectOrder"].Value = "order by ID desc";

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

//每页显示数
workParm = mySqlCommand.Parameters.Add("@a_intPageSize", SqlDbType.Int);
mySqlCommand.Parameters["@a_intPageSize"].Value = intPageSize;

//总记录数(存储过程输出参数)
workParm = mySqlCommand.Parameters.Add("@RecordCount", SqlDbType.Int);
workParm.Direction = ParameterDirection.Output;

//当前页记录数(存储过程返回值)
workParm = mySqlCommand.Parameters.Add("RowCount", SqlDbType.Int);
workParm.Direction = ParameterDirection.ReturnValue;

mySqlConnection.Open();
dl1.DataSource = mySqlCommand.ExecuteReader();

dl1.DataBind();

mySqlConnection.Close();

Int32 RecordCount = (Int32)mySqlCommand.Parameters["@RecordCount"].Value;
Int32 RowCount = (Int32)mySqlCommand.Parameters["RowCount"].Value;
LabelRecord.Text = RecordCount.ToString();
LabelRow.Text = intPageNo.ToString();
if (GetPageCount(intPageSize, RecordCount) != 1) //总页数不为1时
{
intPageCount = GetPageCount(intPageSize, RecordCount);

LabelPage.Text = intPageCount.ToString(); //lbl总页数

HLFistPage.Enabled = true;
HLEndPage.Enabled = true;

HLFistPage.NavigateUrl = "cpjsq.aspx?CurrentPage=1"; //首页
HLEndPage.NavigateUrl = "cpjsq.aspx?CurrentPage=" + intPageCount; //末页

if (intPageNo < intPageCount) //传过来的页码小于总页数
{
HLNextPage.Enabled = true;
HLNextPage.NavigateUrl = "cpjsq.aspx?CurrentPage=" + Convert.ToString(intPageNo + 1); //上一页
}
else
{
HLNextPage.Enabled = false;
HLEndPage.Enabled = false;
}

if (intPageNo > 1) //传过来的页码大于1
{
HLPrevPage.Enabled = true;
HLPrevPage.NavigateUrl = "cpjsq.aspx?CurrentPage=" + Convert.ToString(intPageNo - 1); //下一页
}
else
{
HLPrevPage.Enabled = false;
HLFistPage.Enabled = false;
}
}
else
{
HLFistPage.Enabled = false;
HLEndPage.Enabled = false;
HLNextPage.Enabled = false;
HLPrevPage.Enabled = false;
//lblAllPage.Text = "1";
LabelPage.Text = "1";

}
if (this.LabelRecord.Text == "0")
{
Response.Write(" <script>alert('没有搜索到指定的数据!'); </script>");
}
}
}
public string strvalue(string value, int length)
{
if (value.Length > length)
{
value = value.Substring(0, length);
value = value + "...";
return value;
}
else
{
return value;
}
}
public string StripHT(string strHtml)
{
Regex regex = new Regex(" <.+?>", RegexOptions.IgnoreCase);
string strOutput = regex.Replace(strHtml, "");
return strOutput;
}
public int GetPageCount(int rowSize, int rowCount)
{
int pageCount; //总页数
if (rowCount > rowSize)
{
if (rowCount % rowSize == 0)
{
pageCount = (rowCount / rowSize);
}
else
{
pageCount = (rowCount / rowSize) + 1;
}
}
else
{
pageCount = 1;
}
return pageCount;
}
}

修改删除举报引用回复