C# 使用DataView实现Distinct效果-DISTINCT rows in a DataTable or DataView

C# 利用DataView来过过滤DataTable达到SQL Query的Distinct效果 DISTINCT rows in a DataTable or DataView

1. DataView dv = dtOriginalDataTable.DefaultView; //取得DataTable的数据 Get Data From DataTable
   
2. DataTable dt = dv.ToTable(true, "Category"); //你能添加更多 To add more if u want ToTable(true, "Category", "Product")
   
3. dv = dt.DefaultView;

复制代码