Class into an XML file into a DataSet vs. Reflection into a DataTable

[Former Member]

In order to serialize a class (SystemSetup) and load an XML file into a datatable and then a dataset I must:

1. Create an .XSD file using the XSD SDK tool.

2. DataTable.LoadSchemaFile

3. DataTable.LoadXml

4. Then add the datatable to a dataset.

Is this correct?

Another method using Reflection.

Reflect the SystemSetup class into a datatable.

Push the datatable->dataset to the crystal report.

Will this work?

Which one is preferable? Thx.,

Ajay

[Former Member · Accepted solution]

NOWHERE can I find the details on how to create a datatable from an XML file. Nor can i find it on these forums.

The current problem is when I use XSD with the /l:VB it converts the entire XML file elements to type string.

Any help will be greatly appreciated.

Sincerely,

Ajay

[Former Member · Accepted solution]

OK, i figured this much out:

Dim ds As New DataSet
        Dim myXmlReader As New System.Xml.XmlTextReader("C:\SystemSetup.xml")
        ds.ReadXml(myXmlReader, XmlReadMode.InferTypedSchema)
        mydatatable = ds.Tables(0)

[Former Member]

I had to manually change the data types even with Strong Type Inference option. Don't know of an alternative.

Edited by: Ajay Shah on Jan 28, 2009 10:37 PM

[Former Member]

null

Edited by: Ajay Shah on Jan 28, 2009 10:37 PM