借鉴一下别的的成果,介绍一下,字段转datatable,相信大家以后会用到,自己也记录一下
代码:
public static DataTable DicToTable(Dictionary<string, string> dicDep)
{
DataTable dt = new DataTable();
//dt.Columns.Add("ID", typeof(Guid));
//dt.Columns.Add("DID", typeof(string));
//dt.Columns.Add("DEPARTMENTNUM", typeof(string));
//dt.Columns.Add("DEPARTMENTNAME", typeof(string));
//dt.Columns.Add("REMARKS", typeof(string));
foreach (var colName in dicDep.Keys)
{
dt.Columns.Add(colName, typeof(string));
}
DataRow dr = dt.NewRow();
foreach (KeyValuePair<string, string> item in dicDep)
{
dr[item.Key] = item.Value;
}
dt.Rows.Add(dr);
return dt;
}