DataSet flexibility
Hi fellow programmers . I’m taking my first steps with the Dot Net technology. I use a DataSet to read data from an XML file. Life is great. Finally I got to the point where efficiency counts and here I hope to get some help from you. I get large XML files (~ 500 MB) to process. And I don’t need all the information from the file for the first step. I wish to “restrict” the depth of the XML reading. Currently I use myDataSet.ReadXml(filename) -> which loads all the data into memory. For example : Let’s say in my XML file I have a list of people , each of them with a name, address, telephone number and a list of books each of the books has its title , author and publisher. I want to extract to my dataset only the list of people (names , addresses and tel numbers) without the data regarding the books. In the second step – I’ll need a way to extract the books data for a specific person. Is there a way doing this ? I have implemented these tasks without the dataset object – reading from the file and filling the tables “manually” , but if the dataset object have the flexibility I explained (restricting the depth of the reading and extracting specific portion of the tables) I’d rather use it. Thanks