Pete,

If you assign a PK column in each the DataTable (look at the PrimaryKey property of a DataTable), then you should be able to use the DataSet.Merge() method to merge the two DataSets.

~~Bonnie



>Hello there, thought I'd throw this in before going off in the wrong direction, I have a situation where I need to retrieve data from two different sources - SQL Server 2000 and VFP, the SQL and VFP tables both have the same PK, but, there the similarity ends
>
>

>SLQ table
>
>f1(PK) char(10)
>f2 int
>f3 anothertype
>.
>.
>.
>
>
>Fox table
>f1(PK) char(10)
>f2 string
>f3 anothertype
>.
>.
>.
>
>

>what I need to do is, add the VFP data to the corresponding PK record in SQL, hope that makes sense