Hi Pete,

You'll soon come to the conclusion that ADO.NET is totally different (and limiting) from VFP. You can't do this directly.

First there is no way of just opening a table alias "USE Mytable". You'll have to use SQL through ODBC or OLEDB to get at your data. Though ones the data of the two individual tables is downloaded, you can relate one table to another in ADO.NET, it probably makes more sense to use a SQL select with a join performing the relation.

Walter,


>Hello there, just been thrown in the deep end with .NET, I need to perform the equivalent of "Set Relation" using CSharp on two Foxpro tables. My basic needs are: Open two Foxpro tables, relate them using two common fields, ( loads of logic goes here... ) create an output table. I know how to open and read them, but am at a loss as to how to create and update a new table
>
>any help much appreciated