2023年6月21日发(作者：)

c#winform实现分页查询效果如下代码using System;using c;using entModel;using ;using ent;using g;using ;using ;using ;using ;namespace WindowsFormsApplication1{public partial class Form2 : Form{public Form2(){InitializeComponent();}int n = 1;int size = 1;private void Form2_Load(object sender, EventArgs e){ = “当前第”+ng()+“页”;Getdata();}public void Getdata(){size =32();string sql = “select

from(select ,rn=ROW_NUMBER()over(order by id asc)from department )as t where between(@n-1)@size+1 and @n@size”;SqlParameter[] pr = new SqlParameter[]{new SqlParameter("@n", ) {Value=n },new SqlParameter("@size",) { Value=size}}; DataTable dt = (sql,pr); urce = dt; } private void button1_Click(object sender, EventArgs e) { if(n==1) { ("已经是第⼀页了"); } else { n--; = "当前第" + ng() + "页"; Getdata(); }

} private void button2_Click(object sender, EventArgs e) { string sql = "select count(*)from department"; int i = (int)eScalar(sql); //总条数/每页个数=总页数

float x = i % size == 0 ?i/size : i % size + 1; if(x==n||size>i) { ("这是最后⼀页了"); } else { n++; = "当前第" + ng() + "页"; Getdata(); }

} private void textBox1_MouseHover(object sender, EventArgs e) { n = 1; size = 32(); Getdata(); } //private void textBox1_MouseMove(object sender, MouseEventArgs e) //{ // n = 1; // Getdata(); //} //private void textBox1_ModifiedChanged(object sender, EventArgs e) //{ // n = 1; // Getdata(); //}}}

2023年6月21日发(作者：)

c#winform实现分页查询效果如下代码using System;using c;using entModel;using ;using ent;using g;using ;using ;using ;using ;namespace WindowsFormsApplication1{public partial class Form2 : Form{public Form2(){InitializeComponent();}int n = 1;int size = 1;private void Form2_Load(object sender, EventArgs e){ = “当前第”+ng()+“页”;Getdata();}public void Getdata(){size =32();string sql = “select

from(select ,rn=ROW_NUMBER()over(order by id asc)from department )as t where between(@n-1)@size+1 and @n@size”;SqlParameter[] pr = new SqlParameter[]{new SqlParameter("@n", ) {Value=n },new SqlParameter("@size",) { Value=size}}; DataTable dt = (sql,pr); urce = dt; } private void button1_Click(object sender, EventArgs e) { if(n==1) { ("已经是第⼀页了"); } else { n--; = "当前第" + ng() + "页"; Getdata(); }

} private void button2_Click(object sender, EventArgs e) { string sql = "select count(*)from department"; int i = (int)eScalar(sql); //总条数/每页个数=总页数

float x = i % size == 0 ?i/size : i % size + 1; if(x==n||size>i) { ("这是最后⼀页了"); } else { n++; = "当前第" + ng() + "页"; Getdata(); }

} private void textBox1_MouseHover(object sender, EventArgs e) { n = 1; size = 32(); Getdata(); } //private void textBox1_MouseMove(object sender, MouseEventArgs e) //{ // n = 1; // Getdata(); //} //private void textBox1_ModifiedChanged(object sender, EventArgs e) //{ // n = 1; // Getdata(); //}}}