How To utilize an XML based dataset in a DataGrid

  • Thread starter Thread starter Dev
  • Start date Start date
D

Dev

Good Morning to all,

I have some XML files. Each one represent a single table of a database, and
some of them are related.

I want to use a simple example to explain my needs:

Supposed that I have a xml file named "people" with fields "id_people" and
"name" and an xml named "phone_number" with fields "id_phone", "id_people"
and "number". (phone_number.id_people is a foreign key verus
people.id_people, representing "this phone number is for this person" -
sorry for my english- )

I am able to load all the xml files in a dataset, and so creating 2 tables.

Suppose that now I want to display in a datagrid a listing of each phone
number with this format: | number | people |. I need to assign as datamember
of this grid a join query made against "number" and "people".

Obviously I need to create a join, but how is it possible having a dataset
with just two table?

Regards

Dev
 
Back
Top