dataset 与 datatable 中复制数据

--从dataset 中取部分数据到第二个dataset 中

string where = "[Location] LIKE '%"+Location+"%' And [ServerName] LIKE '%"+ServerName+"%' And [PriceArea] LIKE '%"+PriceArea+"%' And [Language] LIKE '%"+language+"%'";
   DataTable dt = new DataTable();
   DataSet ds = new DataSet();
   ds = GetGoldPriceList();//取原始数据
   DataRow[] dr = ds.Tables[0].Select(where);
   DataSet ds2 = new DataSet();
   ds2.Merge(dr);

--- end---

---

DataSet ds;
   DataTable dt = new DataTable();
    ds = gp.GetGoldPriceListByCache(); //取原始数据

   
   DataRow[] dr;

   dr = ds.Tables[0].Select("location='EURO' and language='English' and faction='alliance'");

   dt = ds.Tables[0].Clone();
   for(int i=0;i<dr.Length-1;i++)
   {
    dt.ImportRow(dr[i]);
   }