DataTable常用操作

1.添加列

　　dt.Columns.Add("A1",typeof(decimal));

2.Select查询

　　dt.Select("A1 like '%aa%'")

3.排序和分页　

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14

//jqgridparam.page 前端传入的页数   jqgridparam.rows 每页行数<br> DataView dv = dt.DefaultView; dv.Sort = "A1 desc"; DataTable source = dv.ToTable(); DataTable paged = source.Clone(); int rowbegin = (jqgridparam.page-1)  * jqgridparam.rows; int rowend = (jqgridparam.page ) * jqgridparam.rows; if (rowend > source.Rows.Count) {     rowend = source.Rows.Count; } for (int i = rowbegin; i < rowend; i++) {     paged.ImportRow(source.Rows[i]); }

 4.修改列名

　　dt.Columns["Name"].ColumnName = "ShortName";

5.移除列

　　dt.Columns.Remove("ShortName");