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 :D

[Machaira]

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

[Tim Field]

Thanks v. much!