UC知道datatable 如何分页
来源：百度知道 编辑：UC知道 时间：2024/05/29 04:35:52
public DataTable DemandDt = new DataTable("DemandDt");
#region 数据绑定
private void BindUserData()
{
SupplyDt.Columns.Add(new DataColumn("id", typeof(Int32)));
SupplyDt.Columns.Add(new DataColumn("type", typeof(string)));
SupplyDt.Columns.Add(new DataColumn("information", typeof(string)));
DataRow Newrow;
int i = 0;
QueryParam qp = new QueryParam();
qp.Where = "Where type='供'";
List<sdinformationEntity> sd = BusinessFacadeHQAgricultureClass.sdinformationList(qp, out i);
try
{
foreach (sdinformationEntity sdinformation in sd)
{
Newrow = SupplyDt.NewRow();//新行必须在循环内 不然会覆盖数据…………
Newrow["id"] = sdinformation.ID;
#region 数据绑定
private void BindUserData()
{
SupplyDt.Columns.Add(new DataColumn("id", typeof(Int32)));
SupplyDt.Columns.Add(new DataColumn("type", typeof(string)));
SupplyDt.Columns.Add(new DataColumn("information", typeof(string)));
DataRow Newrow;
int i = 0;
QueryParam qp = new QueryParam();
qp.Where = "Where type='供'";
List<sdinformationEntity> sd = BusinessFacadeHQAgricultureClass.sdinformationList(qp, out i);
try
{
foreach (sdinformationEntity sdinformation in sd)
{
Newrow = SupplyDt.NewRow();//新行必须在循环内 不然会覆盖数据…………
Newrow["id"] = sdinformation.ID;
DataTable分页代码如下：
/// <summary>
/// 根据索引和pagesize返回记录
/// </summary>
/// <param name="dt">记录集 DataTable</param>
/// <param name="PageIndex">当前页</param>
/// <param name="pagesize">一页的记录数</param>
/// <returns></returns>
public static DataTable SplitDataTable(DataTable dt, int PageIndex, int PageSize)
{