VB.Net Convert Large XML file to dataset

[rfemmer]

Can anyone tell me the best way to convert a large xml file to a dataset with VB.Net?

I've tried:
Dim ds As New DataSet
ds.ReadXml("C:\MyLargeXMLFile.xml")

Also tried using the XMLTextReader:

Dim myXMLfile As String = "C:\MyLargeXMLFile.xml"
Dim fsReadxml As System.IO.FileStream = New System.IO.FileStream(myXMLfile, System.IO.FileMode.Open)
Dim reader As XmlTextReader = Nothing
Dim xmlds = New DataSet
reader = New XmlTextReader(fsReadxml)
xmlds.ReadXml(reader)

These Both seem to take a long time to convert.

 

[tsuji]

Have you checked out documentation?

http://msdn2.microsoft.com/en-us/library/fx29c3yd(VS.80).aspx

I think you'll find significant improvement by first calling .BeginLoadData(), then ReadXML() and last calling .EndLoadData().