XML Dataset question

[Tim Field]

If I had two datatables.

e.g.

Car and Passengers.

Car
CarID, Colour, Type
1      , Red,    Jaguar
2      , Blue,    Lotus

Passengers
PassengerID, PassengerName, CarID
1               , John,                1
2               , Phil,                  2
3               , Paul,                 2

And wanted to output these in XML with Car as the master node what would use in C# ??

Thanks, Tim

 

[Machaira]

Do a Select with a join on the two tables and export the resulting dataset.

 

[Tim Field]

Thanks v. much!