How To utilize an XML based dataset in a DataGrid

[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

 

[William Ryan eMVP]

Datasets are datasets regardless of how they are filled and binding them to
a grid is binding them to a grid (I'm full of wonderful insights this
morning).

Anyway, you can use a DataRelation object to link those feilds in the two
tables http://www.knowdotnet.com/articles/datarelation.html that that should
do it for you.

HTH,

Bill

--
W.G. Ryan MVP Windows - Embedded

http://forums.devbuzz.com
http://www.knowdotnet.com/dataaccess.html
http://www.msmvps.com/williamryan/

 

[Val Mazur]

Hi,

Since you cannot execute any SQL statements against that DataSet, you would
need to create some sort of a helper class, which will simulate joining. See
next KB about it

http://support.microsoft.com/default.aspx?scid=kb;en-us;325688

 

[Dev]

Thanks for your help, it is useful!

Dev

Hi,

Since you cannot execute any SQL statements against that DataSet, you would
need to create some sort of a helper class, which will simulate joining. See
next KB about it

http://support.microsoft.com/default.aspx?scid=kb;en-us;325688