1.对已有的DataTable进行筛选、排序
//已有的DataTable
DataTable data;
//第一种模糊查询方法+排序
string strwhere = " 1=1 and Title like '%s%'";
DataRow[] drArr = data.Select(strwhere, "C2 DESC");//模糊查询(如果的多条件筛选,可以加 and 或 or )
//第二种模糊查询方法+排序
//DataRow[] drArr2 = data.Select("'abc' LIKE C1 + '%'", "C2 DESC");
// 将得到的数据转移到新DataTable
DataTable dtNew = data.Clone();
for (int i = 0; i < drArr.Length; i++)
{
dtNew.ImportRow(drArr[i]);//ImportRow 是复制
}
//只排序 对新的Table中字段进行排序
if (data.Rows.Count > 0)
{
DataView dv = Value.DefaultView;
dv.Sort = "tongsu desc";
dtNew= dv.ToTable();
}
2.对已有的DataTable进行分页
DataTable dt = SplitDataTable(dtNew, page, pageSize);
//分页方法 DataTable,当前页数,页面展示数据条数
public static DataTable SplitDataTable(DataTable dt, int PageIndex, int PageSize)
{
if (PageIndex == 0)
return dt;
DataTable newdt = dt.Clone();
//newdt.Clear();
int rowbegin = (PageIndex - 1) * PageSize;
int rowend = PageIndex * PageSize;
if (rowbegin >= dt.Rows.Count)
return newdt;
if (rowend > dt.Rows.Count)
rowend = dt.Rows.Count;
for (int i = rowbegin; i <= rowend - 1; i++)
{
DataRow newdr = newdt.NewRow();
DataRow dr = dt.Rows[i];
foreach (DataColumn column in dt.Columns)
{
newdr[column.ColumnName] = dr[column.ColumnName];
}
newdt.Rows.Add(newdr);
}
return newdt;
}
菜鸟总结 多存疏漏 感谢指正