?? 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();
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -