- ///<summary>
- ///执行DataTable中的查询返回新的DataTable
- ///</summary>
- ///<paramname="dt">源数据DataTable</param>
- ///<paramname="condition">查询条件</param>
- ///<returns></returns>
- publicstaticDataTableGetNewDataTable(DataTabledt,stringcondition)
- {
- DataTablenewdt=newDataTable();
- newdt=dt.Clone();
- DataRow[]dr=dt.Select(condition);
- for(inti=0;i<dr.Length;i++)
- {
- newdt.ImportRow((DataRow)dr[i]);
- }
- returnnewdt;//返回的查询结果
- }
- publicstaticDataSetGetNewDataSet(DataSetinputds,stringcondition)
- {
- DataTablenewdt=newDataTable();
- newdt=inputds.Tables[0].Clone();
- DataRow[]dr=inputds.Tables[0].Select(condition);
- for(inti=0;i<dr.Length;i++)
- {
- newdt.ImportRow((DataRow)dr[i]);
- }
- DataSetoutputds=newDataSet();
- outputds.Tables.Add(newdt);
- returnoutputds;
- }
执行一个查询返回新的datatable或dataset
最新推荐文章于 2021-02-17 02:27:06 发布