Can someone tell me if it is possible to merge DataSets to a DataTable?
DataTable _dtAllData;DataTable _dtCustomers;// ***** POPULATE _dtCustomers *****foreach (DataRow row in _dtCustomers.Rows)
{
string _CustomerID = row["customer_id"].ToString();
string _sql = String.Format("select field1,field2,field3 from myDbTable where reference='{0}'", _CustomerID);
DataSet _dsOutput = DAL.getDataSet(_sql);
_dtAllData = _dsOutput.Tables[0];
}
This doesn't work as the final statement obviously overwrites _dtAllData.
Thanks
Go to the complete details ...