//去掉重复行  DataView dv = table.DefaultView;  table = dv.ToTable(true, new string[] { "name", "code" });  此时table 就只有name、code无重复的两行了，如果还需要id值则  table = dv.ToTable(true, new string[] { "id","name", "code" });//第一个参数true 启用去重复，类似distinct

id   name   code     张三    123     李四    456     张三    456    张三     123

id   name   code     张三    123     李四    456     张三    456

table = dv.ToTable(true, new string[] { "name"});

name 张三  李四 

 id   name   code 1    张三    123 2    李四    456

#region 删除DataTable重复列，类似distinct          /// <summary>            /// 删除DataTable重复列，类似distinct            /// </summary>            /// <param name="dt">DataTable</param>            /// <param name="Field">字段名</param>            /// <returns></returns>            public static DataTable DeleteSameRow(DataTable dt, string Field)          {              ArrayList indexList = new ArrayList();              // 找出待删除的行索引                for (int i = 0; i < dt.Rows.Count - 1; i++)              {                  if (!IsContain(indexList, i))                  {                      for (int j = i + 1; j < dt.Rows.Count; j++)                      {                          if (dt.Rows[i][Field].ToString() == dt.Rows[j][Field].ToString())                          {                              indexList.Add(j);                          }                      }                  }              }              // 根据待删除索引列表删除行                for (int i = indexList.Count - 1; i >= 0; i--)              {                  int index = Convert.ToInt32(indexList[i]);                  dt.Rows.RemoveAt(index);              }              return dt;          }          /// <summary>            /// 判断数组中是否存在            /// </summary>            /// <param name="indexList">数组</param>            /// <param name="index">索引</param>            /// <returns></returns>            public static bool IsContain(ArrayList indexList, int index)          {              for (int i = 0; i < indexList.Count; i++)              {                  int tempIndex = Convert.ToInt32(indexList[i]);                  if (tempIndex == index)                  {                      return true;                  }              }              return false;          }          #endregion