- 复制DataTable
DataTable dt = new DataTable();
DataTable newDt = dt.Clone();
DataTable newDt = dt.Copy();
DataTable newDt = dt;
- DataTable 取某一列的值
List<string> djh= dt.AsEnumerable().Select(r => r["djh"]).ToList();
string[] djh=dt.AsEnumerable().Select(d=>d.Field<string>("djh")).ToArray();
- DataTable 取多个列的值
var zzxx = dt.AsEnumerable().Select(t => new
{
ryid = t["id"].ToInt(),
rydm = t["dm"].ToString(),
rymc = t["mc"].ToString(),
dwmc = "作者"
}).ToList();
- DataTable 拼接几个列
string[] djh=dt.AsEnumerable().Select(d=>d.Field<string>("id") + d.Field<string>("djh")).ToArray();