这个小小的功能实现起来还是有一点点复杂, 分页单独一个usercontrol 出来,导致查询换页 与gridcontrol页面分离, 一般通过换页事件通知girdcontrol 做出查询
查询来说有时是查询所有,有时是查询一个月,或者别的时间. 在分页控件内的控件上做相应的赋值.想想实现起来还是有一定的复杂度.
如果数据量足够大 : 第一步是先查出数据总量,根据总量,把分页上的 数量,页数.当前页等做初始化,把第一页的数据通过数据库查询先赋值给gridcontrol,其余页面等用户点击时进行赋值
查询数据总数:
/// <summary>
/// 查询记录条数
/// </summary>
/// <returns>记录条数</returns>
public int Count()
{
const string sql = "SELECT count(*) as id FROM [dbo].[Contacts]";
using (SqlConnection connection = new SqlConnection(connstr))
{
int list = Convert.ToInt32(connection.ExecuteScalar(sql));
return list;
}
}
数据库查询分页代码:
/// <summary>
/// 分页
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public IEnumerable<Model.ScanAllData> Page(int pageIndex, int pageSize)
{
const string sql = @"select * from(select *,(ROW_NUMBER() over(order by id asc))as newId from Contacts) as t
where t.newId between (@pageIndex-1)*@pageSize+1 and @pageSize*@pageIndex";
using (SqlConnection connection = new SqlConnection(connstr))
{
var reader = connection.Query<Model.ScanAllData>(sql, new { pageIndex = pageIndex, pageSize = pageSize });
return reader;
}
}
分页控件样式图
新建一个usercontrol , 加上panelcontorl 然后 从左到右 需 button , 输入框,下拉框 ,labelcontrol 挨个拖进
代码如下:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Drawing;
using System.Data;
using System.Linq;
using System.Text;
using System.Windows.Forms;
//MGNC
//QQ:1981633
namespace WORKALERT
{
public partial class MgncPager : UserControl
{
private int allCount = 0;
private int pageSize = 10;
private int curPage = 1;
public delegate void MyPagerEvents(int curPage,int pageSize);
public delegate void ExportEvents(bool singlePage);//单页，所有
public event MyPagerEvents myPagerEvents;
public event ExportEvents exportEvents;
public MgncPager()
{
InitializeComponent();
}
//计算分页,分页大小，总记录数。
public void RefreshPager(int pageSize,int allCount,int curPage)
{
this.allCount = allCount;
this.pageSize = pageSize;
this.curPage = curPage;
this.textEditAllPageCount.Text = GetPageCount().ToString();
lcStatus.Text = string.Format("(共{0}条记录，每页{1}条，共{2}页)", allCount, pageSize, GetPageCount());
textEditCurPage.Text = curPage.ToString() ;
textEditToPage.Text = curPage.ToString();
comboBoxEditPageSize.Text = pageSize.ToString();
if (curPage == 0)
{
if (GetPageCount() > 0)
{
curPage = 1;
myPagerEvents(curPage, pageSize);
}
}
if (curPage > GetPageCount())
{
curPage = GetPageCount();
myPagerEvents(curPage, pageSize);
}
}
//获取总记录数
public int GetAllCount()
{
return allCount;
}
//获得当前页编号，从1开始
public int GetCurPage()
{
return curPage;
}
//获得总页数
public int GetPageCount()
{
int count = 0;
if (allCount % pageSize == 0)
{
count = allCount / pageSize;
}
else
count = allCount / pageSize+1;
return count;
}
private void simpleButtonNext_Click(object sender, EventArgs e)
{
if (myPagerEvents != null)
{
if(curPage<GetPageCount())
curPage += 1;
myPagerEvents(curPage,pageSize);
}
}
private void simpleButtonEnd_Click(object sender, EventArgs e)
{
if (myPagerEvents != null)
{
curPage = GetPageCount();
myPagerEvents(curPage, pageSize);
}
}
private void simpleButtonPre_Click(object sender, EventArgs e)
{
if (myPagerEvents != null)
{
if (curPage > 1)
curPage -= 1;
myPagerEvents(curPage, pageSize);
}
}
private void simpleButtonFirst_Click(object sender, EventArgs e)
{
if (myPagerEvents != null)
{
curPage = 1;
myPagerEvents(curPage, pageSize);
}
}
private void simpleButtonToPage_Click(object sender, EventArgs e)
{
try
{
int selPage = Convert.ToInt32(textEditToPage.Text);
if (myPagerEvents != null)
{
if ((selPage >= 1) && (selPage <= GetPageCount()))
curPage = selPage;
myPagerEvents(curPage, pageSize);
}
}
catch (Exception)
{
//throw;
}
}
private void simpleButtonExportCurPage_Click(object sender, EventArgs e)
{
try
{
if (exportEvents != null)
{
exportEvents(true);
}
}
catch (Exception)
{
//throw;
}
}
private void simpleButtonExportAllPage_Click(object sender, EventArgs e)
{
try
{
if (exportEvents != null)
{
exportEvents(false);
}
}
catch (Exception)
{
//throw;
}
}
private void comboBoxEditPageSize_EditValueChanged(object sender, EventArgs e)
{
try
{
int pageSize = Convert.ToInt32(comboBoxEditPageSize.Text);
if ((pageSize > 0))
{
this.pageSize = pageSize;
myPagerEvents(curPage, pageSize);
}
}
catch (Exception)
{
}
}
}
}
调用:
加两个事件:
mgncPager1.myPagerEvents += MyPagerEvents; //new MgncPager.MyPagerEvents(MyPagerEvents);
mgncPager1.exportEvents += ExportEvents;// new MgncPager.ExportEvents(ExportEvents);
public int curPage = 1;
public int pageSize = 10;
public int allcount = 0;
public void ExportEvents(bool singlePage)//单页，所有
{
//导出GridControl代码写在这。
}
public void RefreshGridList()
{
FillGridListCtrlQuery(curPage);//自己实现FillGridListCtrlQuery函数。
}
private void FillGridListCtrlQuery(int curPage = 1) //更新控件
{
// GridControl1.DataSource = WebService.Pager(。。。。。//显示分页结果
mgncPager1.RefreshPager(pageSize, allcount, curPage);//更新分页控件显示。
}
private void MyPagerEvents(int curPage, int pageSize)
{
this.curPage = curPage;
this.pageSize = pageSize;
FillGridListCtrlQuery(curPage);
}
mgncPager1.RefreshPager(pageSize, allcount, curPage);//更新分页控件显示。
每次查询数据量大需要分页,需要初始化这个控件上的值.
这边上还没实现数据保存,可以借鉴 别的博文里边你的文章,下边有上一页下一页 操作代码,包括内容导出
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Text;
using System.Linq;
using System.Threading.Tasks;
using System.Windows.Forms;
using DevExpress.XtraEditors;
using DZAMS.DBUtility;
namespace DZAMS.Demo
{
public partial class GridPage_Frm : DevExpress.XtraEditors.XtraForm
{
public DataTable dt = new DataTable();
StoreProcedure sp;
private int pageSize = 10; //每页显示行数
private int nMax = 0; //总记录数
private int pageCount = 0; //页数＝总记录数/每页显示行数
private int pageCurrent = 0; //当前页号
private DataSet ds = new DataSet();
private DataTable dtInfo = new DataTable();
public GridPage_Frm()
{
InitializeComponent();
}
private void GridPage_Frm_Load(object sender, EventArgs e)
{
string strQuery = string.Format("SELECT Id, UserCode, UserName, RoleName, Ip, Mac, LoginTime FROM DZ_LoginLog");
dt = SqlHelper.ExecuteDataset(SqlHelper.conn, CommandType.Text, strQuery.ToString()).Tables[0];
gridControl1.DataSource = dt;
string strConn = "SERVER=(local);DATABASE=DZ;UID=sa;PWD=XXXX"; //数据库连接字符串
SqlConnection conn = new SqlConnection(strConn);
conn.Open();
string strSql = "SELECT count(*) as num FROM DZ_LoginLog";
SqlDataAdapter sda = new SqlDataAdapter(strSql, conn);
sda.Fill(ds, "ds");
conn.Close();
nMax = Convert.ToInt32(ds.Tables[0].Rows[0]["num"].ToString());
lblTotalCount.Text = nMax.ToString();
lblPageSize.Text = pageSize.ToString();
sp = new StoreProcedure("Pr_Monitor_Pagination", strConn);
dtInfo = sp.ExecuteDataTable("DZ_LoginLog", "Id", "Id desc", pageCurrent++, pageSize);
InitDataSet();
}
private void InitDataSet()
{
pageCount = (nMax / pageSize); //计算出总页数
if ((nMax % pageSize) > 0) pageCount++;
pageCurrent = 1; //当前页数从1开始
LoadData();
}
private void LoadData()
{
lblPageCount.Text = "/"+pageCount.ToString();
txtCurrentPage.Text = Convert.ToString(pageCurrent);
this.bdsInfo.DataSource = dtInfo;
this.bdnInfo.BindingSource = bdsInfo;
this.gridControl1.DataSource = bdsInfo;
}
private void bdnInfo_ItemClicked(object sender, ToolStripItemClickedEventArgs e)
{
if (e.ClickedItem.Text == "导出当前页")
{
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.Title = "导出Excel";
saveFileDialog.Filter = "Excel文件(*.xls)|*.xls";
DialogResult dialogResult = saveFileDialog.ShowDialog(this);
if (dialogResult == DialogResult.OK)
{
DevExpress.XtraPrinting.XlsExportOptions options = new DevExpress.XtraPrinting.XlsExportOptions();
gridControl1.ExportToXls(saveFileDialog.FileName, options);
// gridControl1.ExportToExcelOld(saveFileDialog.FileName);
DevExpress.XtraEditors.XtraMessageBox.Show("保存成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
if (e.ClickedItem.Text == "关闭")
{
this.Close();
}
if (e.ClickedItem.Text == "首页")
{
pageCurrent--;
if (pageCurrent <= 0)
{
MessageBox.Show("已经是首页，请点击“下一页”查看！");
return;
}
else
{
pageCurrent = 1;
dtInfo = sp.ExecuteDataTable("DZ_LoginLog", "Id", "Id desc", pageCurrent, pageSize);
}
}
if (e.ClickedItem.Text == "上一页")
{
pageCurrent--;
if (pageCurrent <= 0)
{
MessageBox.Show("已经是第一页，请点击“下一页”查看！");
return;
}
else
{
dtInfo = sp.ExecuteDataTable("DZ_LoginLog", "Id", "Id desc", pageCurrent, pageSize);
}
}
if (e.ClickedItem.Text == "下一页")
{
pageCurrent++;
if (pageCurrent > pageCount)
{
MessageBox.Show("已经是最后一页，请点击“上一页”查看！");
return;
}
else
{
dtInfo = sp.ExecuteDataTable("DZ_LoginLog", "Id", "Id desc", pageCurrent, pageSize);
}
}
if (e.ClickedItem.Text == "尾页")
{
pageCurrent++;
if (pageCurrent > pageCount)
{
MessageBox.Show("已经是尾页，请点击“上一页”查看！");
return;
}
else
{
pageCurrent = pageCount;
dtInfo = sp.ExecuteDataTable("DZ_LoginLog", "Id", "Id desc", pageCount, pageSize);
}
}
LoadData();
}
}
}
附 控件MgncPager.Designer.cs
namespace WORKALERT
{
partial class MgncPager
{
/// <summary>
/// 必需的设计器变量。
/// </summary>
private System.ComponentModel.IContainer components = null;
/// <summary>
/// 清理所有正在使用的资源。
/// </summary>
/// <param name="disposing">如果应释放托管资源，为 true；否则为 false。</param>
protected override void Dispose(bool disposing)
{
if (disposing && (components != null))
{
components.Dispose();
}
base.Dispose(disposing);
}
#region 组件设计器生成的代码
/// <summary>
/// 设计器支持所需的方法 - 不要
/// 使用代码编辑器修改此方法的内容。
/// </summary>
private void InitializeComponent()
{
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(MgncPager));
this.panelControl1 = new DevExpress.XtraEditors.PanelControl();
this.lcStatus = new DevExpress.XtraEditors.LabelControl();
this.simpleButtonToPage = new DevExpress.XtraEditors.SimpleButton();
this.textEditToPage = new DevExpress.XtraEditors.TextEdit();
this.labelControl2 = new DevExpress.XtraEditors.LabelControl();
this.simpleButtonExportCurPage = new DevExpress.XtraEditors.SimpleButton();
this.simpleButtonExportAllPage = new DevExpress.XtraEditors.SimpleButton();
this.textEditAllPageCount = new DevExpress.XtraEditors.TextEdit();
this.labelControl4 = new DevExpress.XtraEditors.LabelControl();
this.comboBoxEditPageSize = new DevExpress.XtraEditors.ComboBoxEdit();
this.labelControl1 = new DevExpress.XtraEditors.LabelControl();
this.simpleButtonEnd = new DevExpress.XtraEditors.SimpleButton();
this.simpleButtonNext = new DevExpress.XtraEditors.SimpleButton();
this.textEditCurPage = new DevExpress.XtraEditors.TextEdit();
this.simpleButtonPre = new DevExpress.XtraEditors.SimpleButton();
this.simpleButtonFirst = new DevExpress.XtraEditors.SimpleButton();
((System.ComponentModel.ISupportInitialize)(this.panelControl1)).BeginInit();
this.panelControl1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.textEditToPage.Properties)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.textEditAllPageCount.Properties)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.comboBoxEditPageSize.Properties)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.textEditCurPage.Properties)).BeginInit();
this.SuspendLayout();
//
// panelControl1
//
this.panelControl1.Appearance.BackColor = System.Drawing.Color.White;
this.panelControl1.Appearance.Options.UseBackColor = true;
this.panelControl1.Controls.Add(this.lcStatus);
this.panelControl1.Controls.Add(this.simpleButtonToPage);
this.panelControl1.Controls.Add(this.textEditToPage);
this.panelControl1.Controls.Add(this.labelControl2);
this.panelControl1.Controls.Add(this.simpleButtonExportCurPage);
this.panelControl1.Controls.Add(this.simpleButtonExportAllPage);
this.panelControl1.Controls.Add(this.textEditAllPageCount);
this.panelControl1.Controls.Add(this.labelControl4);
this.panelControl1.Controls.Add(this.comboBoxEditPageSize);
this.panelControl1.Controls.Add(this.labelControl1);
this.panelControl1.Controls.Add(this.simpleButtonEnd);
this.panelControl1.Controls.Add(this.simpleButtonNext);
this.panelControl1.Controls.Add(this.textEditCurPage);
this.panelControl1.Controls.Add(this.simpleButtonPre);
this.panelControl1.Controls.Add(this.simpleButtonFirst);
this.panelControl1.Dock = System.Windows.Forms.DockStyle.Fill;
this.panelControl1.Location = new System.Drawing.Point(0, 0);
this.panelControl1.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
this.panelControl1.Name = "panelControl1";
this.panelControl1.Size = new System.Drawing.Size(1089, 41);
this.panelControl1.TabIndex = 29;
//
// lcStatus
//
this.lcStatus.AutoSizeMode = DevExpress.XtraEditors.LabelAutoSizeMode.None;
this.lcStatus.Dock = System.Windows.Forms.DockStyle.Fill;
this.lcStatus.Location = new System.Drawing.Point(577, 2);
this.lcStatus.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
this.lcStatus.Name = "lcStatus";
this.lcStatus.Padding = new System.Windows.Forms.Padding(13, 0, 0, 0);
this.lcStatus.Size = new System.Drawing.Size(310, 37);
this.lcStatus.TabIndex = 12;
this.lcStatus.Text = "(共XXX条记录，每页XX条，共XX页)";
//
// simpleButtonToPage
//
this.simpleButtonToPage.Dock = System.Windows.Forms.DockStyle.Left;
this.simpleButtonToPage.Location = new System.Drawing.Point(534, 2);
this.simpleButtonToPage.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
this.simpleButtonToPage.Name = "simpleButtonToPage";
this.simpleButtonToPage.Size = new System.Drawing.Size(43, 37);
this.simpleButtonToPage.TabIndex = 13;
this.simpleButtonToPage.Text = "跳转";
this.simpleButtonToPage.Click += new System.EventHandler(this.simpleButtonToPage_Click);
//
// textEditToPage
//
this.textEditToPage.Dock = System.Windows.Forms.DockStyle.Left;
this.textEditToPage.EditValue = "1";
this.textEditToPage.Location = new System.Drawing.Point(494, 2);
this.textEditToPage.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
this.textEditToPage.Name = "textEditToPage";
this.textEditToPage.Properties.Appearance.Options.UseTextOptions = true;
this.textEditToPage.Properties.Appearance.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.textEditToPage.Properties.AutoHeight = false;
this.textEditToPage.Size = new System.Drawing.Size(40, 37);
this.textEditToPage.TabIndex = 9;
//
// labelControl2
//
this.labelControl2.AutoSizeMode = DevExpress.XtraEditors.LabelAutoSizeMode.None;
this.labelControl2.Dock = System.Windows.Forms.DockStyle.Left;
this.labelControl2.Location = new System.Drawing.Point(441, 2);
this.labelControl2.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
this.labelControl2.Name = "labelControl2";
this.labelControl2.Size = new System.Drawing.Size(53, 37);
this.labelControl2.TabIndex = 10;
this.labelControl2.Text = "当前页：";
//
// simpleButtonExportCurPage
//
this.simpleButtonExportCurPage.Dock = System.Windows.Forms.DockStyle.Right;
this.simpleButtonExportCurPage.Location = new System.Drawing.Point(887, 2);
this.simpleButtonExportCurPage.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
this.simpleButtonExportCurPage.Name = "simpleButtonExportCurPage";
this.simpleButtonExportCurPage.Size = new System.Drawing.Size(100, 37);
this.simpleButtonExportCurPage.TabIndex = 2;
this.simpleButtonExportCurPage.Text = "导出当前页";
this.simpleButtonExportCurPage.Click += new System.EventHandler(this.simpleButtonExportCurPage_Click);
//
// simpleButtonExportAllPage
//
this.simpleButtonExportAllPage.Dock = System.Windows.Forms.DockStyle.Right;
this.simpleButtonExportAllPage.Location = new System.Drawing.Point(987, 2);
this.simpleButtonExportAllPage.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
this.simpleButtonExportAllPage.Name = "simpleButtonExportAllPage";
this.simpleButtonExportAllPage.Size = new System.Drawing.Size(100, 37);
this.simpleButtonExportAllPage.TabIndex = 2;
this.simpleButtonExportAllPage.Text = "导出全部页";
this.simpleButtonExportAllPage.Click += new System.EventHandler(this.simpleButtonExportAllPage_Click);
//
// textEditAllPageCount
//
this.textEditAllPageCount.Dock = System.Windows.Forms.DockStyle.Left;
this.textEditAllPageCount.Location = new System.Drawing.Point(402, 2);
this.textEditAllPageCount.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
this.textEditAllPageCount.Name = "textEditAllPageCount";
this.textEditAllPageCount.Properties.Appearance.ForeColor = System.Drawing.Color.Red;
this.textEditAllPageCount.Properties.Appearance.Options.UseForeColor = true;
this.textEditAllPageCount.Properties.AutoHeight = false;
this.textEditAllPageCount.Properties.ReadOnly = true;
this.textEditAllPageCount.Size = new System.Drawing.Size(39, 37);
this.textEditAllPageCount.TabIndex = 14;
//
// labelControl4
//
this.labelControl4.AutoSizeMode = DevExpress.XtraEditors.LabelAutoSizeMode.None;
this.labelControl4.Dock = System.Windows.Forms.DockStyle.Left;
this.labelControl4.Location = new System.Drawing.Point(346, 2);
this.labelControl4.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
this.labelControl4.Name = "labelControl4";
this.labelControl4.Size = new System.Drawing.Size(56, 37);
this.labelControl4.TabIndex = 15;
this.labelControl4.Text = "总页数：";
//
// comboBoxEditPageSize
//
this.comboBoxEditPageSize.Dock = System.Windows.Forms.DockStyle.Left;
this.comboBoxEditPageSize.EditValue = "100";
this.comboBoxEditPageSize.Location = new System.Drawing.Point(281, 2);
this.comboBoxEditPageSize.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
this.comboBoxEditPageSize.Name = "comboBoxEditPageSize";
this.comboBoxEditPageSize.Properties.Appearance.Options.UseTextOptions = true;
this.comboBoxEditPageSize.Properties.Appearance.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.comboBoxEditPageSize.Properties.AutoHeight = false;
this.comboBoxEditPageSize.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
this.comboBoxEditPageSize.Properties.DisplayFormat.FormatString = "d";
this.comboBoxEditPageSize.Properties.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.comboBoxEditPageSize.Properties.EditFormat.FormatString = "d";
this.comboBoxEditPageSize.Properties.EditFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.comboBoxEditPageSize.Properties.EditValueChangedDelay = 1;
this.comboBoxEditPageSize.Properties.Items.AddRange(new object[] {
"5",
"10",
"15",
"30",
"50",
"100"});
this.comboBoxEditPageSize.Size = new System.Drawing.Size(65, 37);
this.comboBoxEditPageSize.TabIndex = 7;
this.comboBoxEditPageSize.EditValueChanged += new System.EventHandler(this.comboBoxEditPageSize_EditValueChanged);
//
// labelControl1
//
this.labelControl1.AutoSizeMode = DevExpress.XtraEditors.LabelAutoSizeMode.None;
this.labelControl1.Dock = System.Windows.Forms.DockStyle.Left;
this.labelControl1.Location = new System.Drawing.Point(201, 2);
this.labelControl1.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
this.labelControl1.Name = "labelControl1";
this.labelControl1.Size = new System.Drawing.Size(80, 37);
this.labelControl1.TabIndex = 8;
this.labelControl1.Text = " 分页大小：";
//
// simpleButtonEnd
//
this.simpleButtonEnd.Appearance.Options.UseTextOptions = true;
this.simpleButtonEnd.Appearance.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.simpleButtonEnd.Dock = System.Windows.Forms.DockStyle.Left;
this.simpleButtonEnd.Image = ((System.Drawing.Image)(resources.GetObject("simpleButtonEnd.Image")));
this.simpleButtonEnd.ImageLocation = DevExpress.XtraEditors.ImageLocation.MiddleCenter;
this.simpleButtonEnd.Location = new System.Drawing.Point(162, 2);
this.simpleButtonEnd.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
this.simpleButtonEnd.Name = "simpleButtonEnd";
this.simpleButtonEnd.Size = new System.Drawing.Size(39, 37);
this.simpleButtonEnd.TabIndex = 0;
this.simpleButtonEnd.Click += new System.EventHandler(this.simpleButtonEnd_Click);
//
// simpleButtonNext
//
this.simpleButtonNext.Appearance.Options.UseTextOptions = true;
this.simpleButtonNext.Appearance.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.simpleButtonNext.Dock = System.Windows.Forms.DockStyle.Left;
this.simpleButtonNext.Image = ((System.Drawing.Image)(resources.GetObject("simpleButtonNext.Image")));
this.simpleButtonNext.ImageLocation = DevExpress.XtraEditors.ImageLocation.MiddleCenter;
this.simpleButtonNext.Location = new System.Drawing.Point(123, 2);
this.simpleButtonNext.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
this.simpleButtonNext.Name = "simpleButtonNext";
this.simpleButtonNext.Size = new System.Drawing.Size(39, 37);
this.simpleButtonNext.TabIndex = 0;
this.simpleButtonNext.Click += new System.EventHandler(this.simpleButtonNext_Click);
//
// textEditCurPage
//
this.textEditCurPage.Dock = System.Windows.Forms.DockStyle.Left;
this.textEditCurPage.EditValue = "1";
this.textEditCurPage.Location = new System.Drawing.Point(80, 2);
this.textEditCurPage.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
this.textEditCurPage.Name = "textEditCurPage";
this.textEditCurPage.Properties.Appearance.Options.UseTextOptions = true;
this.textEditCurPage.Properties.Appearance.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.textEditCurPage.Properties.AutoHeight = false;
this.textEditCurPage.Properties.ReadOnly = true;
this.textEditCurPage.Size = new System.Drawing.Size(43, 37);
this.textEditCurPage.TabIndex = 4;
//
// simpleButtonPre
//
this.simpleButtonPre.Appearance.Options.UseTextOptions = true;
this.simpleButtonPre.Appearance.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.simpleButtonPre.Dock = System.Windows.Forms.DockStyle.Left;
this.simpleButtonPre.Image = ((System.Drawing.Image)(resources.GetObject("simpleButtonPre.Image")));
this.simpleButtonPre.ImageLocation = DevExpress.XtraEditors.ImageLocation.MiddleCenter;
this.simpleButtonPre.Location = new System.Drawing.Point(41, 2);
this.simpleButtonPre.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
this.simpleButtonPre.Name = "simpleButtonPre";
this.simpleButtonPre.Size = new System.Drawing.Size(39, 37);
this.simpleButtonPre.TabIndex = 0;
this.simpleButtonPre.Click += new System.EventHandler(this.simpleButtonPre_Click);
//
// simpleButtonFirst
//
this.simpleButtonFirst.Appearance.Options.UseTextOptions = true;
this.simpleButtonFirst.Appearance.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.simpleButtonFirst.Dock = System.Windows.Forms.DockStyle.Left;
this.simpleButtonFirst.Image = ((System.Drawing.Image)(resources.GetObject("simpleButtonFirst.Image")));
this.simpleButtonFirst.ImageLocation = DevExpress.XtraEditors.ImageLocation.MiddleCenter;
this.simpleButtonFirst.Location = new System.Drawing.Point(2, 2);
this.simpleButtonFirst.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
this.simpleButtonFirst.Name = "simpleButtonFirst";
this.simpleButtonFirst.Size = new System.Drawing.Size(39, 37);
this.simpleButtonFirst.TabIndex = 0;
this.simpleButtonFirst.Click += new System.EventHandler(this.simpleButtonFirst_Click);
//
// MgncPager
//
this.AutoScaleDimensions = new System.Drawing.SizeF(8F, 15F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.Controls.Add(this.panelControl1);
this.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
this.Name = "MgncPager";
this.Size = new System.Drawing.Size(1089, 41);
((System.ComponentModel.ISupportInitialize)(this.panelControl1)).EndInit();
this.panelControl1.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.textEditToPage.Properties)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.textEditAllPageCount.Properties)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.comboBoxEditPageSize.Properties)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.textEditCurPage.Properties)).EndInit();
this.ResumeLayout(false);
}
#endregion
private DevExpress.XtraEditors.PanelControl panelControl1;
private DevExpress.XtraEditors.TextEdit textEditCurPage;
private DevExpress.XtraEditors.SimpleButton simpleButtonExportAllPage;
private DevExpress.XtraEditors.SimpleButton simpleButtonExportCurPage;
private DevExpress.XtraEditors.SimpleButton simpleButtonEnd;
private DevExpress.XtraEditors.SimpleButton simpleButtonNext;
private DevExpress.XtraEditors.SimpleButton simpleButtonPre;
private DevExpress.XtraEditors.SimpleButton simpleButtonFirst;
private DevExpress.XtraEditors.LabelControl labelControl1;
private DevExpress.XtraEditors.ComboBoxEdit comboBoxEditPageSize;
private DevExpress.XtraEditors.TextEdit textEditToPage;
private DevExpress.XtraEditors.LabelControl labelControl2;
private DevExpress.XtraEditors.LabelControl lcStatus;
private DevExpress.XtraEditors.SimpleButton simpleButtonToPage;
private DevExpress.XtraEditors.TextEdit textEditAllPageCount;
private DevExpress.XtraEditors.LabelControl labelControl4;
}
}不爱动弹自己整理就从这个地址下1分:http://download.csdn.net/detail/flyman105/9906644
这个控件是个初步框架,里边添不同的需求,比如分类查询,还需要做相应修改.
在c#开发中很多人不建议使用分页, 数据库导出1万条记录也很快, 再有就是目标用户也不会看那么多分页.