can we add 2 datatables in dataset ?

[Satish Developer]

HI, Can we add 2 datatables in one dataset, each datatable from different database. If so, how we can add at a time. Suppose if i get the datatable using sqlserver database then dataset1 = sqldataset.tables[0]; If i get the datatable from Oracle database then dataset1 = oradataset.tables[0]; is it correct? if so, it doesn't overwrite?

G. Satish

[Sun Rays]

Hi, DataSet ds = new DataSet(); ds.Tables.Add(dataTable1); // from 1st database ds.Tables.Add(dataTable2); // from 2nd database

Thanks, Sun Rays To get something you must have to try once. My Articles

[neerubee]

DataSet1 ds1 = new DataSet(); ds1.Tables.Add(dt1); // from 1st database i.e from SQL ds1.Tables.Add(dt2); // from 2nd database i.e from Oracle If you want more info check in google

Thanks & Regards Niranjan