/// <summary> /// 執行DataTable中的查詢返回新的DataTable /// </summary> /// <param name="dt">源數據DataTable</param> /// <param name="condition">查詢條件</param> /// <returns></returns> PRivate DataTable GetNewDataTable(DataTable dt,string condition) { DataTable newdt = new DataTable(); newdt=dt.Clone(); DataRow[] dr = dt.Select(condition); for(int i=0;i<dr.Length;i++) { newdt.ImportRow((DataRow)dr[i]); } return newdt;//返回的查詢結果 }
另外,datatable.Select()多個條件選擇語句和SQL語句類似,如:DataTable.Select("ID=" + id +" and name='" +name + "'")
|
新聞熱點
疑難解答