过滤DataTable的Rows的重复值

最新推荐文章于 2022-09-20 12:08:23 发布

baoshan

最新推荐文章于 2022-09-20 12:08:23 发布

阅读量1k

点赞数

分类专栏： C#.Net Asp.Net 文章标签： table

C#.Net Asp.Net 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

// 方法1
string sFormater = "{0}, {1}";
string sKeys = null;
string sPrevKeys = null;
// Key项目排序
DataRow[] rows = table.Select("", "Key0, Key1");
foreach (DataRow row in rows)
...{
sKeys = string.Format(sFormater, row["Key0"].ToString(), row["Key1"].ToString());
if (!sKeys.Equals(sPrevKeys))
...{
tagetTable.ImportRow(row);
}
sPrevKeys = sKeys;
}

// 方法2
string sSelectFormater = "{0}, {1}";
foreach (DataRow row in table.Rows)
...{
if (tagetTable.Select(string.Format(sSelectFormater, "Key0", "Key1")).Length == 0)
...{
tagetTable.ImportRow(row);
}
}

table = tagetTable;

// 方法3
string sFormater = "{0}, {1}";
DataRow row;
string sSelectFormater = "Key0 = {0}, Key1 = {1}";
for (int i = 0; i < table.Rows.Count; i++)
{

    row = table.Rows[i];
   if (table.Select(string.Format(sSelectFormater, row["Key0"].ToString(), row["Key1"].ToString())).Length > 1)
{
      table.Rows.Remove(row);
        i--;
    }
}

// 方法4
DataView view = table.DefaultView;
DataTable tagetTable= view.ToTable(true, "column1", "column2", ...);