DataTable 使用sort和Distinct

  • 9398
  • 0

DataTable 使用sort和Distinct

DataTable dtTemp = Project.getTable();

DataView DV= dtTemp.DefaultView;

DV.Sort = "Column1 Desc"; //反序

DV.Sort = "Column1 "; //預設為正序

DataTable dt = DV.ToTable("tb1", true, "Column1");//取Column1欄位唯一值,重新命名為tb1