Hi Trent,

Say I have several tables related to each other and I want to create the hierarchy of the data such as parent child within the XML.

These are small tables where I store the data of menu options and sub options etc...
Then I use the XML file for the web site to display all options etc... I need to select only certain fields that hold the data for the menus. I have some other fields that are not needed for the XML.

I appreciate any feedback.

Thanks,

Doron

Hi Trent,

As Edhy indicated below there will be 3 tables involved. Parent, Child and Grand Child. So the hierarchy should be created based on that as well.
How would you add addtional tables to the XML and reflect the relations there as well?

Thanks,

Doron

You can still do this through ADO.NET. All you need to do is create a DataSet object, then add the the data tables into the data set. You will most likely want to create a clone or copy of the table within the BO otherwise you can have other issues. This will really be the only way to go about this. The XmlBasics class is not going to help you much in this situation.

Hi Trent,

Thanks for your reply.

Maybe that could an enhancement feature to the XMLBasic class, to have the capability of more then one table added into the XML!!

Regards,

Doron