datatable 分页 接口中进行分页

sql中添加这个字段。row_number() over(order by kmf.id desc ) as rownum,

if (dt.Rows.Count > 0)
{
DataTable dt1 = dt;
if (rownum != "")
{
int idd = Convert.ToInt32(rownum) + 10;
DataRow[] dr = dt.Select(" rownum>'" + rownum + "' and rownum<'" + idd + "' ");
if (dr.Length <= 0)
{
return MergeJson2(2, "没有更多数据", "");
}
dt1 = ToDataTable(dr);
}
else
{
//查询10条数据
DataRow[] dr = dt.Select(" rownum<'11' ");
dt1 = ToDataTable(dr);
}

return MergeJson2(1, "", DataTableJsonNOtable(dt1));
}