DataTable table; //数据源
//方式1.根据Order_No、Client_Code 两个字段去重,distinct之后的table只保留括号内写的字段
DataTable DtHeadDis = table.DefaultView.ToTable(true, "Order_No", "Client_Code");
//方式2.根据字段Ord_OrderNo去重,字段可以加,distinct之后的table保留全字段
var dt=table.AsEnumerable().ToList();
DataTable DtNewHead = dt.Where((x, i) => dt.FindIndex(z => z["Ord_OrderNo"] == x["Ord_OrderNo"]) == i).CopyToDataTable();
//方式3.手动筛选
DataTable DtHeadDis = table.Clone();
foreach (DataRow item in table.Rows)
{
DataRow[] drs= DtHeadDis.Select("Client_Code='" + item["Client_Code"].ToString() + "' and Order_No='" + item["Order_No"].ToString() + "'");
if (drs.Count() == 0)
{
DtHeadDis.ImportRow(item);
}
}
foreach (DataRow Row in DtHeadDis.Rows)
{
Row.AcceptChanges();
Row.SetAdded();
}
C# DataTable去重
于 2023-11-24 14:06:26 首次发布