从DataTable获取一列转List

从DataTable获取一列转List

DataTable dt = ...

List<string> list = dt.AsEnumerable().Select(r => r.Field<string>("name")).ToList();

 

从List取一个字段

string [] nameArr = list.Select(p=>p.Name).Distinct().ToArray();
string details = string.Join(",", nameArr);