原理:在已有的sql上,加上ROW_NUMBER()函数,得到行号,将查询的数据存入DataTable ,然后使用视图DataView与行号做比较,过滤不需要的数据。
string sqlstr = "select ROW_NUMBER() over(order by buit_id desc) as row,* from BusinessInformationTable";
DataTable dt = MySQL.DataSelect(sqlstr, "table").Tables[0];
DataView dv = new DataView(dt);
dv.RowFilter = " row > 20 and row <= 30" ;
GridView1.DataSource = dv;
GridView1.DataBind();