单列: MyDataContext db = new MyDataContext(); var result = (from p in db.t_Personnel select p.FirstName).Distinct(); DataTable dt = new DataTable("SingleDistinct"); dt.Columns.Add("FirstName"); foreach (var item in result) { DataRow dr = dt.NewRow(); dr["FirstName"] = item.ToString(); dt.Rows.Add(dr); } dataGridView1.DataSource = dt; 多列: using System.Data; using System.Collections; namespace Test_Distinct { public class PersonDataRowComparer : IEqualityComparer<t_Personnel> { public bool Equals(t_Personnel t1, t_Personnel t2) { return (t1.ID == t2.ID && t1.FirstName