I have a database field that is stored as a dataset xml string in order to capture multiple and different data elements. I can successfully pull this information out of the database, format to a dataset and export it to an excel file.
My issue is that these are stored as datasets as opposed to datarows and because it is stored to a dataset it retains the dataset header info which I really do not need. I really would rather not have to manually parse this data so I am thinking that I could peel the data row out of each data set then plop them into a new dataset, yes?
View Complete Post