Reading XML and inserting into a table.

[dymadarlin]

I want to read a xml file from internet and put it into a table.

This is my code:


Dim xmlFilename As String = "

http://www.mydomain.com/myfile.xml"

Dim fsReadXml As New System.IO.FileStream(xmlFilename, System.IO.FileMode.Open)

dim MyDataTable as New DataTable

MyDataTable.DataSet.ReadXml(fsReadXml)

And it produces the following error:

An unhandled exception of type 'System.ArgumentException' occurred in mscorlib.dll

Additional information: URI formats are not supported.

 

[dymadarlin]

How can I fix it?

 

[ThatRickGuy]

Was the myfile.xml written with dataset.writeXML?

-Rick

----------------------

http://www.ringdev.com

I believe in killer coding ninja monkeys.

 

[dymadarlin]

no, its made by ms access

 

[ThatRickGuy]

See if it has the schema in the XML, if so, you may by able to use Dataset.readxmlschema. If not, you may have to read in the file via an XML Reader object, then build the dataset for it. Thanks to the wide variety of uses for XML, it's hard to have a standard format.

-Rick

----------------------

http://www.ringdev.com

I believe in killer coding ninja monkeys.