>Hi
>
>I'm doing an app that has to join data from a VFP free table with data stored in SQL Server.
>I have the VFP data in a datatable.
>I'm using SQLCommand to access the SQL Server data and have that in a datatable.
>Any suggestions as to the best and most efficient way to join the data so that I can use the joined results as the datasource of a datagridview?
>
>
>
>.
I am not the expert on ADO but if you add both DataTables to a DataSet you can then set a relation in the Dataset between them.
Tim
Timothy Bryan