/// <summary>
///当前页的索引
/// </summary>
int pageindex = -1;
/// <summary>
///每页的显示记录条数
/// </summary>
int pagesize = 10;
//总页数
int pagecount = -1;
DataTable dt_all = new DataTable();
protected void GetData()
{
string sql = "select * from room";
dt_all = DBUil.getDate(sql);
pagecount = dt_all.Rows.Count % pagesize == 0 ? dt_all.Rows.Count / pagesize : dt_all.Rows.Count / pagesize + 1;
}
#region 直接在DataSet(数据集)中分页
/// <summary>
/// 直接在DataSet(数据集)中分页
/// </summary>
/// <param name="ds">DataSet</param>
/// <param name="PageNum">每页显示条数</param>
/// <param name="InPage">第几页</param>
/// <returns></returns>
public static DataTable SplitDataSet(DataTable ds, int InPage, int PageNum)
{
DataTable vds = new DataTable();
vds = ds.Clone();
int fromIndex = PageNum * (InPage - 1);
int toIndex = PageNum * InPage - 1;
for (int i = fromIndex; i <= toIndex; i++)
{
if (i >= ds.Rows.Count)
break;
vds.ImportRow(ds.Rows[i]);
}
ds.Dispose();
return vds;
}
#endregion