如何将Dictionary转换成datatable

Question

        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)
            {
                
            }
        }

Answer 1

            Dictionary<string, string> dict = new Dictionary<string, string>();
            dict.Add("keyone", "one");
            dict.Add("keytwo", "two");
            DataTable dt = new DataTable();
            DataColumn dc1 = new DataColumn("columnOne");
            DataColumn dc2 = new DataColumn("columnTwo");
            dt.Columns.Add(dc1);
            dt.Columns.Add(dc2);
            DataRow dr = dt.NewRow();
            dt.Rows.Add(dr);
            dt.Rows[0][0] = dict["keyone"];
            dt.Rows[0][1] = dict["keytwo"];
            Console.WriteLine(dt.Rows[0][0]);
            Console.WriteLine(dt.Rows[0][1]);

Answer 2

Dictionary<string, string> dict = new Dictionary<string, string>();
dict.Add("keyone", "one");
dict.Add("keytwo", "two");
DataTable dt = new DataTable();
DataColumn dc1 = new DataColumn("columnOne");
DataColumn dc2 = new DataColumn("columnTwo");
dt.Columns.Add(dc1);
dt.Columns.Add(dc2);
 foreach (KeyValuePair<string,string> item in dict)
{
dt.Rows.Add(item.Key,item.Value);
}

Answer 3

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);
       
  }
  }

Answer 4

Dictionary<string, DepartmentInfo>  DepartmentInfo这是个model类 方法有区别吧 遍历的item.Value得到的是model类

Answer 5

原理是一样的吧。。
 foreach (KeyValuePair<string,DepartmentInfo> item in dicDep)
  {
    DepartmentInfo d=item.Value as DepartmentInfo ;
dt.Rows.Add(d.ID,d.PID,....);
  }

Answer 6

我要给winform的treeview控件绑定数据 不转换用Dictionary<string, DepartmentInfo>可以直接绑定吗