App_Code/myOleDbPager.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;

using System.Configuration;

namespace SCard
{
	/// <summary>
	/// mySqlPager 的摘要说明。
	/// </summary>
	public sealed class MySqlPager : System.Web.UI.Page
	{

        public void setAttribute( DevCenter.SqlPager SqlPager, 
            string strControlToPaginate, string strSelectCommand)
        {
            SqlPager.ControlToPaginate = strControlToPaginate;
			string DBPath = ConfigurationSettings.AppSettings["DataBasePath"];
			SqlPager.ConnectionString = (DBPath); 
            //SqlPager.ConnectionString = ConfigurationSettings.AppSettings["ConnStr"];
            SqlPager.SelectCommand = strSelectCommand;
            SqlPager.ItemsPerPage = 10;
            SqlPager.CurrentPageIndex = 0;
            SqlPager.DataBind();
        }

        public void setAttribute( DevCenter.SqlPager SqlPager, 
            string strControlToPaginate, string strSelectCommand,
            int iItemsPerPage)
        {
            SqlPager.ControlToPaginate = strControlToPaginate;
			string DBPath = ConfigurationSettings.AppSettings["DataBasePath"];
			SqlPager.ConnectionString = (DBPath); 
			//SqlPager.ConnectionString = ConfigurationSettings.AppSettings["ConnStr"];
            SqlPager.SelectCommand = strSelectCommand;
            SqlPager.ItemsPerPage = iItemsPerPage;
            SqlPager.CurrentPageIndex = 0;
            SqlPager.DataBind();
        }

        public void setAttribute( DevCenter.SqlPager SqlPager, 
            string strControlToPaginate, string strSelectCommand,
            string strSortField, int iItemsPerPage)
        {
            SqlPager.ControlToPaginate = strControlToPaginate;
			string DBPath = ConfigurationSettings.AppSettings["DataBasePath"];
			SqlPager.ConnectionString = (DBPath); 
			//SqlPager.ConnectionString = ConfigurationSettings.AppSettings["ConnStr"];
            SqlPager.SelectCommand = strSelectCommand;
            SqlPager.SortField = strSortField;//只能 ASC
            SqlPager.ItemsPerPage = iItemsPerPage;
            SqlPager.CurrentPageIndex = 0;
            SqlPager.DataBind();
        }

        public void setAttribute( DevCenter.SqlPager SqlPager, 
            string strControlToPaginate, string strSelectCommand,
            string strSortField, int iItemsPerPage, int iCurrentPageIndex)
        {
            SqlPager.ControlToPaginate = strControlToPaginate;
			string DBPath = ConfigurationSettings.AppSettings["DataBasePath"];