Question

怎样把 “二维”datatable 转化为dictionary-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);

}
}