Hi,

I'm trying to create a new dataset from two existing datasets. The new dataset (dataset3) should contain the rows from dataset1 where date is in dataset 2.

dataset1:
date price
---- -----
01/01/2005 1.5
02/01/2005 2.5
03/01/2005 3.5

dataset2:
date price
---- -----
01/01/2005 4.5
03/01/2005 5.5

dataset3: (what I want)
date price
---- -----
01/01/2005 1.5
03/01/2005 3.5

Any help would be greatly appreciated!

Thanks,
Wai

Problem solved:
1. Use DataTable select method on dataset2 using the date from dataset1
2. If row is found then add row to dataset3 else do nothing

Just to clarify, are you looking to create 1 dataset from 2 or add a dataset's table to another dataset? Can't you just use the dataset.Table.Add() method? Are you confusing DataSets with DataTables?

-Peter

Peter,

Sorry for the confusion! I was attempting to create a new datatable from 2 existing. I used the datatable.Rows.Add() method.

Wai