Foxpro Question

[Pete Kane]

Hello there, just been thrown in the deep end with .NET, I need to perform
the equivalent of "Set Relation" using CSharp and ADO.NET on two Foxpro
tables. My basic needs are: Open two Foxpro tables, relate them using two
common fields, scan through every record ( loads of logic goes here... )
create and write to an output table. I know how to open, read, and write,
but am at a loss as to how to join them on their common fields ( or if it's
possible !?)

any help much appreciated
Regards,
Peter J. Kane

[Nicholas Paldino [.NET/C# MVP]]

Peter,

This is easy. First, you want to load the data from the two tables into
DataTable instances in the same data set (you have to do this because data
in .NET is not ambient, like it is in FoxPro, but I believe you know this).

Once you do that, you can create DataRelation instances which indicate
which table is the parent, which is the child, and the fields that are used
to bind the two tables.

Then, while cycling through the rows in the parent table, you can call
the GetChildRows method on the DataRow, passing in the DataRelation object,
and it will give you the records in the child table that are related to that
row in the parent table.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Pete Kane" <pj**********@uku.co.uk> wrote in message
news:%2****************@TK2MSFTNGP14.phx.gbl...

Hello there, just been thrown in the deep end with .NET, I need to perform
the equivalent of "Set Relation" using CSharp and ADO.NET on two Foxpro
tables. My basic needs are: Open two Foxpro tables, relate them using two
common fields, scan through every record ( loads of logic goes here... )
create and write to an output table. I know how to open, read, and write,
but am at a loss as to how to join them on their common fields ( or if
it's
possible !?)

any help much appreciated
Regards,
Peter J. Kane

[Pete Kane]

very helpful, thanks very much
regards

Pete Kane
*** Sent via Developersdex http://www.developersdex.com ***

[Pete Kane]

thanks Nicholas, very helpful

"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.com> wrote in
message news:u2**************@TK2MSFTNGP09.phx.gbl...

Peter,

This is easy. First, you want to load the data from the two tables into DataTable instances in the same data set (you have to do this because data
in .NET is not ambient, like it is in FoxPro, but I believe you know this).
Once you do that, you can create DataRelation instances which indicate
which table is the parent, which is the child, and the fields that are used to bind the two tables.

Then, while cycling through the rows in the parent table, you can call
the GetChildRows method on the DataRow, passing in the DataRelation object, and it will give you the records in the child table that are related to that row in the parent table.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Pete Kane" <pj**********@uku.co.uk> wrote in message
news:%2****************@TK2MSFTNGP14.phx.gbl...

Hello there, just been thrown in the deep end with .NET, I need to perform the equivalent of "Set Relation" using CSharp and ADO.NET on two Foxpro
tables. My basic needs are: Open two Foxpro tables, relate them using two common fields, scan through every record ( loads of logic goes here... )
create and write to an output table. I know how to open, read, and write, but am at a loss as to how to join them on their common fields ( or if
it's
possible !?)

any help much appreciated
Regards,
Peter J. Kane