Question

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

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