本文共 2205 字,大约阅读时间需要 7 分钟。
winform中用到的分页控件这里用:http://cyq1162.blog.51cto.com/2127378/896084
也可以在这下载:
原文中的用法:
private void StartForm_Load(object sender, EventArgs e) { //创建文件数据库表。 MDataTable.CreateSchema("Users.txt", false, new string[] { "UserName", "Password", "Enabled" }, SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.Bit); for (int i = 0; i < 200; i++)//插入200条数据。 { using (MAction action = new MAction("Users.txt", "Txt Path={0}")) { action.Set("UserName", "UserName_" + i); action.Set("Password", "Password_" + i); action.Set("Enabled", i%2==0); action.Insert(InsertOp.None); } } pagerControl1.OnPageChanged += new EventHandler(pagerControl1_OnPageChanged); LoadData(); } void pagerControl1_OnPageChanged(object sender, EventArgs e) { LoadData(); } void LoadData() { int count; using (MAction action = new MAction("Users.txt", "Txt Path={0}")) { action.Select(pagerControl1.PageIndex, pagerControl1.PageSize, string.Empty, out count).Bind(gvUsers); pagerControl1.DrawControl(count); } }
SQLite的分页sql语句为
select * from 表 where 条件 order by 列 limit 10,20;
表示跳过10行,取20行的返回结果。
把控件添加在页面后,参考上面代码改写为:public Form2() { InitializeComponent(); pagerControl1.OnPageChanged += new EventHandler(pagerControl1_OnPageChanged); LoadData(); } void LoadData() { pagerControl1.PageSize = 50; string sql = string.Format("select * from tb limit {0},{1}", (pagerControl1.PageIndex-1) * pagerControl1.PageSize, pagerControl1.PageSize); DataTable dt = SqliteHelper.ExecDataSet(sql).Tables[0]; dataGridView1.DataSource = dt; int count = SqliteHelper.ExecuteScalar("select count(*) from tb"); pagerControl1.DrawControl(count); } private void pagerControl1_OnPageChanged(object sender, EventArgs e) { LoadData(); }
转载地址:http://omzrf.baihongyu.com/