Loading data from an XML string to a dataset

[Thomas]

I just cannot find a code sample showing how to load data from an XML string
to a dataset! Everything out there has samples loading from a file but not
from a string. Does anyone has a sample loading from a string to a stream,
to a dataset???

Alternatively, when using the DataSet() property of an XmlDataDocument, one
must first load the Schema. Here again it is looking for a stream?

Help! this is driving me nuts.

[Paul Mc]

G'day Thomas.

>I just cannot find a code sample showing how to load data from an XML string
>to a dataset!

Easily done (Note that you will have to supply the XML string yourself ie
the GetXML() function) :

Dim s As String = GetXML()
Dim ds As System.Data.DataSet = New System.Data.DataSet()
Dim StringReader As System.IO.StringReader = New System.IO.StringReader(s)
ds.ReadXml(StringReader)

Or, in shorter form:

Dim ds As System.Data.DataSet = New System.Data.DataSet()
ds.ReadXml(New System.IO.StringReader(GetXML()))



HTH,
Cheers,
Paul