如何将Dictionary转换成datatable-CSDN论坛

Question

如题所述

Answer 1

DepartmentManage dm = new DepartmentManage();
  Dictionary<string, DepartmentInfo> dicDep = new Dictionary<string, DepartmentInfo>();
  private void DepartmentForm_Load(object sender, EventArgs e)
  {
  dicDep = (Dictionary<string,DepartmentInfo>)dm.query().RetValue;
  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 (KeyValuePair<string,DepartmentInfo> item in dicDep)
  {
       DataRow dr = dt.NewRow();
       dr["ID"] = ...;
       dr["DID"] = ...;
       dr["DEPARTMENTNUM"] = ...;
       dr["DEPARTMENTNAME"] = ...;
       dr["REMARKS"] = ...;
 
       dt.Rows.Add(dr);
        
  }
  }