c# 中dataTable数据某一列求个
double total= Convert.ToDouble(datatable.Compute("SUM(需要求和的参数)", ""))
dataTable调整列顺序可以通过:
dt.Columns["姓名"].SetOrdinal(0); //设置姓名为第一列
dataTable中新增行
DataTable lists;
DataTable lists1;
DataRow dr = lists.NewRow();
dr["物料代码"] = lists1.Rows[i]["物料代码"];
dr["物料类型"] = lists1.Rows[i]["物料类型"];
dr["物料层级"] = lists1.Rows[i]["物料层级"];
lists.Rows.Add(dr);
将list转换成DataTable
DataTable lists1 = (DataTable)JsonConvert.DeserializeObiect(JsonConvert.serializeObiect(result),(typeof(DataTable)))