How do I populate a DataSet from a XML string?

[Goldsworth_Systems]

I have a string containing valid XML.
How do I populate a dataset based on the string, without reference to an XML
schema or writing the XML to file and reading it back in again?

[Martin Honnen]

Goldsworth_Systems wrote:

I have a string containing valid XML.
How do I populate a dataset based on the string, without reference to an XML
schema or writing the XML to file and reading it back in again?

You need an XML schema I think that describes the structure of the XML,
then it is no problem to read in the XML into an XmlDataDocument. But
without a schema it is not possible to associate the XML with a DataSet,
whether the XML is read from a file or from a string doesn't really matter.

--

Martin Honnen
http://JavaScript.FAQTs.com/

[Goldsworth_Systems]

Hi - I think I've cracked it - the following code seems to work:

Public Shared Function bDSOpenFromXML(ByVal vsXML As String, ByRef wdsReturn
As DataSet) As Boolean
' Creates a dataset based on the specified XML string
' Returns true for success

Dim rdr As New System.IO.StringReader(vsXML)
wdsReturn = New DataSet
wdsReturn.ReadXml(rdr)

bDSOpenFromXML = True
End Function

"Martin Honnen" wrote:

Goldsworth_Systems wrote:

I have a string containing valid XML.
How do I populate a dataset based on the string, without reference to an XML
schema or writing the XML to file and reading it back in again?

You need an XML schema I think that describes the structure of the XML,
then it is no problem to read in the XML into an XmlDataDocument. But
without a schema it is not possible to associate the XML with a DataSet,
whether the XML is read from a file or from a string doesn't really matter.

--

Martin Honnen
http://JavaScript.FAQTs.com/