获取对固定列不重复的新DataTable

时间:2021-10-26 13:30:56

获取对固定列不重复的新DataTable 

    ///<summary>
    /// 获取对固定列不重复的新DataTable
    /// </summary>
    ///<param name="dt">
    ///含有重复数据[shu ju]的DataTable  </param>
    ///<param name="colName">  需要验证[yan zheng]重复的列名  </param>
    ///<returns>  新的DataTable,colName列不重复,表格式保持不变  </returns>
    private DataTable GetDistinctTable(DataTable dt, string colName)
    {
        DataView dv = dt.DefaultView;
        DataTable dtCardNo = dv.ToTable(true, colName);
        DataTable Pointdt = new DataTable();
        Pointdt = dv.ToTable();
        Pointdt.Clear();
        for (int i = 0; i < dtCardNo.Rows.Count; i++)
        {
            DataRow dr = dt.Select(colName + "='" + dtCardNo.Rows[i][0].ToString() + "'")[0];
            Pointdt.Rows.Add(dr.ItemArray);
        } return Pointdt;
    }