adding column from a dataset to another dataset

I have a Dataset Ds1 and dataset Ds2 , DS1 has Product_ID, product information and ds2 has Product_ID, product_type.

for the matching product_id, I want to add the Product_tye column from ds2 to ds1 .

Note: Product_id is not primary key in ds 1, the result set has many products with same product_id. In ds 2, product_id is unique.

Re: adding column from a dataset to another dataset

yuvaratna
I have a Dataset Ds1 and dataset Ds2 , DS1 has Product_ID, product information and ds2 has Product_ID, product_type.

Sorry maybe it's DataTable instead of DataSetFor DataSet is a container that holds DataTables

yuvaratna
for the matching product_id, I want to add the Product_tye column from ds2 to ds1 .

Not understand what you meanPlease show us your two tables' values and structures and what you want to gain in the end

Reguards

Hi, You can use,

DataTable mytbl = new DataTable("Table1");
mytbl.Merge(ds.Tables[0], true);

ds2.Tables.Add(mytbl);

ds1.Tables.Add( ds2Table.Copy() );