myoledbpager.cs

商业源码

using System;

using System.Configuration;

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

        public void setAttribute( DevCenter.OleDbPager OleDbPager, 
            string strControlToPaginate, string strSelectCommand)
        {
            OleDbPager.ControlToPaginate = strControlToPaginate;
			string DBPath = ConfigurationSettings.AppSettings["DataBasePath"];
			OleDbPager.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" + Server.MapPath(DBPath); 
            //OleDbPager.ConnectionString = ConfigurationSettings.AppSettings["ConnStr"];
            OleDbPager.SelectCommand = strSelectCommand;
            OleDbPager.ItemsPerPage = 10;
            OleDbPager.CurrentPageIndex = 0;
            OleDbPager.DataBind();
        }

        public void setAttribute( DevCenter.OleDbPager OleDbPager, 
            string strControlToPaginate, string strSelectCommand,
            int iItemsPerPage)
        {
            OleDbPager.ControlToPaginate = strControlToPaginate;
			string DBPath = ConfigurationSettings.AppSettings["DataBasePath"];
			OleDbPager.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" + Server.MapPath(DBPath); 
			//OleDbPager.ConnectionString = ConfigurationSettings.AppSettings["ConnStr"];
            OleDbPager.SelectCommand = strSelectCommand;
            OleDbPager.ItemsPerPage = iItemsPerPage;
            OleDbPager.CurrentPageIndex = 0;
            OleDbPager.DataBind();
        }

        public void setAttribute( DevCenter.OleDbPager OleDbPager, 
            string strControlToPaginate, string strSelectCommand,
            string strSortField, int iItemsPerPage)
        {
            OleDbPager.ControlToPaginate = strControlToPaginate;
			string DBPath = ConfigurationSettings.AppSettings["DataBasePath"];
			OleDbPager.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" + Server.MapPath(DBPath); 
			//OleDbPager.ConnectionString = ConfigurationSettings.AppSettings["ConnStr"];
            OleDbPager.SelectCommand = strSelectCommand;
            OleDbPager.SortField = strSortField;//只能 ASC
            OleDbPager.ItemsPerPage = iItemsPerPage;
            OleDbPager.CurrentPageIndex = 0;
            OleDbPager.DataBind();
        }

        public void setAttribute( DevCenter.OleDbPager OleDbPager, 
            string strControlToPaginate, string strSelectCommand,
            string strSortField, int iItemsPerPage, int iCurrentPageIndex)
        {
            OleDbPager.ControlToPaginate = strControlToPaginate;
			string DBPath = ConfigurationSettings.AppSettings["DataBasePath"];
			OleDbPager.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" + Server.MapPath(DBPath); 
			//OleDbPager.ConnectionString = ConfigurationSettings.AppSettings["ConnStr"];
            OleDbPager.SelectCommand = strSelectCommand;
            OleDbPager.SortField = strSortField;//只能 ASC
            OleDbPager.ItemsPerPage = iItemsPerPage;
            OleDbPager.CurrentPageIndex = iCurrentPageIndex;
            OleDbPager.DataBind();
        }


	}
}