DataTable去重

最新推荐文章于 2024-08-09 14:37:55 发布

无盐海

最新推荐文章于 2024-08-09 14:37:55 发布

阅读量609

点赞数

分类专栏： ASP.NET C#

本文链接：https://blog.csdn.net/Fanbin168/article/details/108430798

版权

C# 同时被 2 个专栏收录

115 篇文章 4 订阅

订阅专栏

ASP.NET

110 篇文章 2 订阅

订阅专栏

DataTable去重

#region datatable去重
/// <summary>
/// datatable去重
/// </summary>
/// <param name="dtSource">需要去重的datatable</param>
/// <param name="columnNames">依据哪些列去重</param>
/// <returns></returns>
public static DataTable GetDistinctTable(DataTable dtSource, params string[] columnNames)
{
    DataTable distinctTable = dtSource.Clone();
    try
    {
        if (dtSource != null && dtSource.Rows.Count > 0)
        {
            DataView dv = new DataView(dtSource);
            distinctTable = dv.ToTable(true, columnNames);
        }
    }
    catch (Exception ee)
    {
    }
    return distinctTable;
}

/// <summary>
/// datatable去重
/// </summary>
/// <param name="dtSource">需要去重的datatable</param>
/// <returns></returns>
public static DataTable GetDistinctTable(DataTable dtSource)
{
    DataTable distinctTable = null;
    try
    {
        if (dtSource != null && dtSource.Rows.Count > 0)
        {
            string[] columnNames = GetTableColumnName(dtSource);
            DataView dv = new DataView(dtSource);
            distinctTable = dv.ToTable(true, columnNames);
        }
    }
    catch (Exception ee)
    {
    }
    return distinctTable;
}

#endregion

#region 获取表中所有列名
public static string[] GetTableColumnName(DataTable dt)
{
    string cols = string.Empty;
    for (int i = 0; i < dt.Columns.Count; i++)
    {
        cols += (dt.Columns[i].ColumnName + ",");
    }
    cols = cols.TrimEnd(',');
    return cols.Split(',');
}
#endregion