如何将Dictionary转换成datatable

csharp_弈剑听雨 2011-06-01 11:47:17
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)
{

}
}
...全文
818 7 打赏 收藏 转发到动态 举报
写回复
用AI写文章
7 条回复
切换为时间正序
请发表友善的回复…
发表回复
  • 打赏
  • 举报
回复
我要给winform的treeview控件绑定数据 不转换用Dictionary<string, DepartmentInfo>可以直接绑定吗
q107770540 2011-06-01
  • 打赏
  • 举报
回复

原理是一样的吧。。
foreach (KeyValuePair<string,DepartmentInfo> item in dicDep)
{
DepartmentInfo d=item.Value as DepartmentInfo ;
dt.Rows.Add(d.ID,d.PID,....);
}
  • 打赏
  • 举报
回复
[Quote=引用 2 楼 q107770540 的回复:]
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……
[/Quote]
Dictionary<string, DepartmentInfo> DepartmentInfo这是个model类 方法有区别吧 遍历的item.Value得到的是model类
lpingz 2011-06-01
  • 打赏
  • 举报
回复

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

}
}
xuexiaodong2009 2011-06-01
  • 打赏
  • 举报
回复
[Quote=引用 2 楼 q107770540 的回复:]

Dictionary<string, string> dict = new Dictionary<string, string>();
dict.Add("keyone", "one");
dict.Add("keytwo", "two");
DataTable dt = new DataTable();
DataColumn dc1 = new DataColumn("columnO……
[/Quote]同意
q107770540 2011-06-01
  • 打赏
  • 举报
回复
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);
}
kingdom_0 2011-06-01
  • 打赏
  • 举报
回复

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

110,534

社区成员

发帖
与我相关
我的任务
社区描述
.NET技术 C#
社区管理员
  • C#
  • Web++
  • by_封爱
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告

让您成为最强悍的C#开发者

试试用AI创作助手写篇文章吧