110,538
社区成员
发帖
与我相关
我的任务
分享
Dictionary<string,List<string>> list = new Dictionary<string,List<string>>();
//循环数据库数据
if(list.ContainsKey ("列1")){
list["列1"].Add("列2");
}else{
list["列1"]=new List<string>();
list["列1"].Add("列2");
}
var query = from y in (from x in DataTable.Cast<DataRow>()
select new { a = x["列1"].ToString(), b = x["列2"].ToString() })
group y by y.a into g
select new { key = g.Key, values = g.Select(z => z.b).ToArray() };
Dictionary<string, List<string>> list = query.ToDictionary(x => x.key, x => x.values.ToList());
var query = from y in (from x in DataTable.Cast<DataRow>()
select new { a = x["列1"].ToString(), b = x["列2"].ToString() })
group y by y.a into g
select new { key = g.Key, values = g.Select(z => z.b).ToArray() };
foreach (var item in query)
{
string name = item.key;
string[] values = item.values;
...//你可以处理,已经归类放入数组了
}