Can I load an XPath result XmlNodeList into a Dataset/DataGrid?

[jack80918]

I'm writing a C# Windows/.Net 2.0 app which will take a large XML document as an initial input. My form has 4 basic controls: 3 comboboxes (Country, State, and City) for filtering the XML data and a DataGrid to display the results. The XML doc has this format: I have no problem using XPath queries to extract the values to populate the Country, State, and City comboboxes; each selection drives the data in the subsequent combobox. Upon selection in the City combobox, I can query for a resulting set of 'locations'. My problem is how to stuff this XmlNodeList into a DataSet which I can then use with my DataGrid. I have no problem reading an entire document into a DataSet DataSet ds = new DataSet(); ds.ReadXml("Test.Search.xml"); but have no idea how to stuff an XmlNodeList into one. Thanks. Jack80918

[George L Jackson]

As you probably already know, an XmlNodeList is really a collection XmlNodes. You have mentioned you can read an XML document directly into a DataSet. So, I can give you a some suggestions. 1. You can create an XmlDocument populating it with XmlNodes cloned from the XmlNodeList. 2. You can create an XmlDocument using XSLT with the same criteria you used to create the XmlNodeList. 3. You can create a DataTable (or DataTables) that corresponds to your XmlNodeList and extract data from your XmlNodes into the appropriate rows and columns. There are certainly other ways of doing this. So, search the web for ideas or just be creative.

"We make a living by what we get, we make a life by what we give." --Winston Churchill