以集合中每一项作为查询条件，将查询到的所有数据形成一个表

        string sqlPid = "select medicine,name from pharmacyInfo where id= "+pharmacyid ;            dt = db.getDataTable(sqlPid);            medicine=dt.Rows[0][0].ToString();            medicinelist = medicine.Split(',');            DataTable dd = new DataTable();                  for (int i = 0; i < medicinelist.Length; i++)            {                   sqlStr = "select id,name,manufacturers,category,istop,new,indications=left(indications,27)+'...' from medicine  where name ='"+medicinelist[i]+"'";                dd = db.getDataTable(sqlStr);                if(i==0)                 ddss = dd.Clone();//克隆All的结构传递给dt                DataRow[] der=dd.Select(); //通过条件得到符合条件的行               for(int j=0;j<der.Length;j++) //将数组元素加入表...               {                  ddss.Rows.Add(der[j].ItemArray);  //出错提示为:该行已经属于另一个表 ddss.Rows.Add(der[i]);                  int x=ddss.Rows.Count;//查看条数               }

            }

转载于:https://www.cnblogs.com/Bachelor/archive/2011/09/08/2170806.html