前兩天有一個(gè)簡(jiǎn)單的C/S項(xiàng)目用到分頁(yè)，因?yàn)槭荳inform下,沒(méi)有現(xiàn)成的，自己也懶得寫(xiě)，就找了下，看到了ycmoon的一個(gè)控件
http://www.cnblogs.com/ycmoon/archive/2010/01/07/1640689.html參考后，做了簡(jiǎn)化，只保留了分頁(yè)的部分，主要是點(diǎn)擊事件的Delegate，未做過(guò)多測(cè)試，有興趣的朋友可以下載源碼自行修改，如有好的建議，也可以給我反饋。3w@live.cn ,效果如下：
控件設(shè)計(jì)界面：
設(shè)計(jì)時(shí)：
運(yùn)行時(shí)：
附帶一個(gè)取分頁(yè)數(shù)據(jù)的存儲(chǔ)過(guò)程：
+ expand sourceview plaincopy to clipboardprint?在WinForm項(xiàng)目中，需要設(shè)置控件的總記錄數(shù)RecordCount （由分頁(yè)存儲(chǔ)過(guò)程計(jì)算得出），和翻頁(yè)事件winFormPager1_PageIndexChanged 。
測(cè)試源碼如下：
view plaincopy to clipboardprint?using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace DemoPager
{
public partial class frmMain : Form
{
public frmMain()
{
InitializeComponent();
}
#region Members
//總記錄數(shù)
public int RecordCount = 0;
private string strConn = @"Data Source=ap2\vegnet;Initial Catalog=Db_TonyPaging;Integrated Security=SSPI;";
//"Server=localhost;database=Db_TonyPaging;uid=sa;pwd=sa;";
private string strProcedure = "ZJF_CPP_GetPagedRecordFor2005_2008";
#endregion
#region Methods
/// <summary>
/// 綁定第Index頁(yè)的數(shù)據(jù)
/// </summary>
/// <param name="Index"></param>
private void BindDataWithPage(int Index)
{
winFormPager1.PageIndex = Index;
//winFormPager1.PageSize = 10;; ;
dgvList.DataSource = GetData(strConn, strProcedure, Index, winFormPager1.PageSize);
//獲取并設(shè)置總記錄數(shù)
winFormPager1.RecordCount = RecordCount;
}
/// <summary>
/// 獲取數(shù)據(jù)源
/// </summary>
/// <param name="conn"></param>
/// <param name="strProcedure"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
private DataTable GetData(string conn, string strProcedure, int pageIndex, int pageSize)
{
using (SqlConnection connection = new SqlConnection(conn))
{
SqlCommand command = new SqlCommand(strProcedure, connection);
command.CommandType = CommandType.StoredProcedure;//采用存儲(chǔ)過(guò)程
//存儲(chǔ)過(guò)程參數(shù)
command.Parameters.Add("@Table", SqlDbType.NVarChar, 1000).Value = "DepartDemo";
command.Parameters.Add("@TIndex", SqlDbType.NVarChar, 100).Value = "PKID";
command.Parameters.Add("@Column", SqlDbType.NVarChar, 2000).Value = "*";
command.Parameters.Add("@Sql", SqlDbType.NVarChar, 3000).Value = " 1=1 ";
command.Parameters.Add("@PageIndex", SqlDbType.Int, 8).Value = pageIndex.ToString();
command.Parameters.Add("@PageSize", SqlDbType.Int, 8).Value = pageSize.ToString();
command.Parameters.Add("@Sort", SqlDbType.NVarChar, 200).Value = " PKID desc";
//打開(kāi)連接
if (connection.State != ConnectionState.Open) { connection.Open(); }
try
{
//填充數(shù)據(jù)
SqlDataAdapter da = new SqlDataAdapter(command);
DataSet ds = new DataSet();
da.Fill(ds);
//獲取總記錄數(shù)
RecordCount = Convert.ToInt32(ds.Tables[1].Rows[0][0]);
//返回?cái)?shù)據(jù)集
return ds.Tables[0];
}
catch (SqlException err)
{
MessageBox.Show(err.Message);
return null; ;
}
finally
{
connection.Close();
}
}
}
#endregion
#region Events
private void frmMain_Load(object sender, EventArgs e)
{
//不自動(dòng)生成列
dgvList.AutoGenerateColumns = false;
//綁定數(shù)據(jù)
BindDataWithPage(1);
}
/// <summary>
/// 翻頁(yè)事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void winFormPager1_PageIndexChanged(object sender, EventArgs e)
{
BindDataWithPage(winFormPager1.PageIndex);
}
#endregion
}
}
下載控件源碼及演示程序(含SQL)
下載地址二下載地址一
