Question

C# 怎么根据DataTable中的某一列，来将另外一列合并起来？

如图所示，如何根据a列将b列合并起来并用，号隔开？

Answer 1

开Linq 用group by into ，再select new个匿名，中间用lamb ToArray()一下，Join
var list1 = new[] {
new { A="a1", B= "0" },
new { A="a2", B= "0" },
new { A="a1", B= "1" },
new { A="a3", B= "1" },
};

var k = from x in list1
group x by x.A into g
select new
{
A = g.Key,
B = String.Join(",", g.Select(c=>c.B).ToArray())
};
dataGridView1.DataSource = k.ToList();