loading xml data from xml documenet to dataset tables

EDN Admin

Well-known member
Joined
Aug 7, 2010
Messages
12,794
Location
In the Machine
This topic seems pretty repeating but I searched what I need and I couldnt find so excuse me if I am repeating a beat up question..
What I am trying to do is to write a cosole application which will load an xml document and do some transformation / calculation and write out a flat file for each XML document. The XML document and the generated flat file are way too complex to handle just
in XSLT.
The XML document that I am trying to load comes with its own XSD and is pretty complex has about 12 or 13 sub sections each one having its own nested elements and attributes on almost all the elements. And the attribute names and element names have been
reused in different sections adding even more complexity... due to this, the XSD that came with the document creates too many meaningless tables.. So tomake a long story short, how can I control the tables that are created and how do I map the table columns
to the correct element/attributes ... I was hoping to create the XSD by hand to create the tables I needed and map the columns to the XML element/attributes using XPath ..
Could someone please help me/point me in the right direction.. I am kind of on a scale 1 to 10, say 7 on XML Style sheet creation, 3 on C#, 5 in XSD, XPath ..
Thanks
Sankar

View the full article
 
Back
Top