JJKazJr
Member
I have tried for quite a while on doing this, so I am hoping someone can give me an easy answer or tell me to stop trying because its not possible. I have a large xml file which has many nested objects (not great with xml termananology so dont want to confuse helpers by possibly using the wrong term). Now I only want to use a small amount of the information stored in the file. I am trying to get to the useful data. I have the idea of loading it into a table in order to eventully query against a lot of other data that I have. I have tried(and failed) many times to load the needed data into a dataset. I have successfully loaded the entire file into a dataset but I run into a few problems. The dataset ends up having 20 tables when it loads the xml which is a pain to work with since in order to get all the needed info I would need to work my way up multiple parent (or down children) relations to get the information that I need. I would really like to predefine one table, and have the file fill the columns that I dedicate while leaving the rest of the data out. All sites that I have looked at tell very little of the actual process. They say to load a schema for the dataset then load the dataset with the xml. I have tried setting up the table and relations but when I tell it to fill the table, no data fills in. How do I go about this. ANY ideas, suggestions, or links would be useful. I am starting to get fed up and resort to looping through the entire xml to get the information.
Thanks in advance
Thanks in advance