xml fields parsed in numeric order

[DarwinIT]

I have a database driven project which allows the app to take data coming in from multiple sources and process it in the manner desired. This was column based so text files, excel worksheets, etc. work just fine. Now a new request has come down the pipeline and the vendor is sending me xml data. Is there any way to parse xml to extract fields 1,2,3 in order so I can continue to use column numbers to identity the source for my data? If not, I'll have to revamp my existing app and add custom functionality for xml based on field name. Thanks.

 

[DarwinIT]

I have come up with a solution. I use the dataset object with the ReadXml method to put the data into a dataset. Then I can walk the second table and use my column numbers to pick up the desired data.