DataTable筛选以及根據Columns distinct

..........

DataSet ds = new DataSet();

da.Fill(ds );

 

 

//筛选

DataRow[] dr =ds.select("id=2","name Desc");

 

for(int j = 0;j < dr.Length;j++)

{

    Response.Write(dr[j]["name"].toString());

}

 

 

//根據Columns distinct

 

//獲取cOverdueDayDesc
string[] newColumns ={ "id", "sex" };//添加列名

DataRow[] drOverdueDayDesc = ds.Tables[0].DefaultView.ToTable(true, newColumns).Select("1=1", "id Desc");

 

....................................