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

[ReactiveX]

Unfortunately, I don't think there is currently support on the NodeList or Navigator objects to do that. Besides, I would recommend that you rather create the appropriate DataTables and DataColumns manually for this operation and then use the Iterator to populate your DataSet manually. It won't be alot of work and you still have the power to specify your types to the column.

Daniel Minnaar Lead Software Developer