发现一个分页控件AspNetPager

最新推荐文章于 2022-06-23 15:18:23 发布

暖枫无敌

最新推荐文章于 2022-06-23 15:18:23 发布

阅读量1.7k

点赞数

分类专栏： C#.NET编程文章标签： parameters dataset string border listview server

本文链接：https://blog.csdn.net/zdw_wym/article/details/5133403

版权

C#.NET编程专栏收录该内容

219 篇文章 2 订阅

订阅专栏

以前在利用GridView、ListView做分页显示的时候,要么使用控件自身的分页功能,要么手动写代码实现分页功能,最近发现有这么一个AspNetpager的分页控件, 还挺不错。

(1)、先下载aspnetpager.dll这个文件,在VS2005新建Web项目中添加该引用,并将其添加到工具栏中,这样可以轻易拖放。

(2)、在cs文件中添加引用:using Wuqi.Webdiyer;

以下是代码：

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="SpiltPage.aspx.cs" Inherits="SpiltPage" %>

<%@ Register Assembly="AspNetPager" Namespace="Wuqi.Webdiyer" TagPrefix="webdiyer" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>分页ASPNETPAGER控件使用</title>

----------------------------------------------------------------------------------------------------

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 Wuqi.Webdiyer;

public partial class SpiltPage : System.Web.UI.Page
{
string conString = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"];

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            using (SqlConnection con = new SqlConnection(conString))
            {
                con.Open();
                string strSQL = "select count(*) from BMSK_GB";
                using (SqlCommand cmd = new SqlCommand(strSQL, con))
                {
                    AspNetPager1.RecordCount = (int)cmd.ExecuteScalar();
                }
            }
            BindData();
        }
    }

    //数据绑定
    public void BindData()
    {
        using (SqlConnection con = new SqlConnection(conString))
        {
            con.Open();
            string strSQL = "select SKBM as 水库编码,SKMC as 水库名称,SZS as 所在市,SZX as 所在县,SFWX as 是否危险 from BMSK_GB";
            SqlDataAdapter da = new SqlDataAdapter(strSQL,con);
            DataSet ds = new DataSet();
            da.Fill(ds,AspNetPager1.PageSize*(AspNetPager1.CurrentPageIndex-1),AspNetPager1.PageSize,"tab");
            this.GridView1.DataSource = ds.Tables["tab"];
            this.GridView1.DataBind();
        }
    }

    //翻页事件
    protected void ChangePage(object src, PageChangedEventArgs e)
    {
        AspNetPager1.CurrentPageIndex = e.NewPageIndex;
        BindData();
    }
}

后续补充说明：

对于用存储过程，可以写一个方法返回一个可用的DataSet对象提供使用，如下：

public static DataSet GetAllUserPage(string table, string fields, string orderField, string sqlWhere,int pageSize, int pageIndex, out int totalPage, out int totalRecord)
        {
            DataSet ds = null;
            string spName = "[dbo].[sp_super_page]";
            SqlParameter[] parameters = new SqlParameter[]
    {
     new SqlParameter("@TableName",SqlDbType.VarChar, 5000),
     new SqlParameter("@Fields",SqlDbType.VarChar, 5000),
     new SqlParameter("@OrderField",SqlDbType.VarChar, 5000),
     new SqlParameter("@sqlWhere",SqlDbType.VarChar, 5000),
     new SqlParameter("@pageSize",SqlDbType.Int),
     new SqlParameter("@pageIndex",SqlDbType.Int),
     new SqlParameter("@TotalPage",SqlDbType.Int),
     new SqlParameter("@totalRecord",SqlDbType.Int)
    };

            parameters[0].Value = table;
            parameters[1].Value = fields;
            parameters[2].Value = orderField;
            parameters[3].Value = sqlWhere;
            parameters[4].Value = pageSize;
            parameters[5].Value = pageIndex;
            parameters[6].Direction = ParameterDirection.Output;
            parameters[7].Direction = ParameterDirection.ReturnValue;

ds = SQLHelper.ExecuteDataset(SQLHelper.connectionStr, CommandType.StoredProcedure, spName, parameters);

totalPage = Convert.ToInt32(parameters[6].Value);
totalRecord = Convert.ToInt32(parameters[7].Value);

return ds;
}