Grar, wish I could help more, but I've never touched a DataTable in my life.
I really think there's a missing link from the information you told me. Ideally, that's XmlElement -to- (Something the XMLTextReader can lock onto) -to- XmlTextReader -to- DataTable.
Failing that, all I can see is prepping a DataTable with the proper schema (which you already know), and then inputting the data manually, but this is not robust, unless you can you can create a function given a known schema (How do you contain your schemas anyway? What object do you use?) and then figuring out an algorithm to assign data from the XMl to the proper columns.
Comments 2
I really think there's a missing link from the information you told me. Ideally, that's XmlElement -to- (Something the XMLTextReader can lock onto) -to- XmlTextReader -to- DataTable.
Failing that, all I can see is prepping a DataTable with the proper schema (which you already know), and then inputting the data manually, but this is not robust, unless you can you can create a function given a known schema (How do you contain your schemas anyway? What object do you use?) and then figuring out an algorithm to assign data from the XMl to the proper columns.
Once you have that, you should be all set.
Reply
thank you so much!
Reply
Leave a comment