XML string to dataset

[cmhunt]

Hi

I'm using a webservice which returns a string which contains an XML fragment. All I need to do is read this into a dataset but I can't figure out how to do it. If I write the string to a file and then read the XML file in to the dataset using ReadXml() it works fine.

I'm sure it can't be hard. Any help would be appreciated.

Thanks

Chris

 

[JohnYingling]

Here is what I used for String.

           dsRsp.Namespace = ""

            ' Get XML response into a DataSet
            Dim dsXmlTr As System.Xml.XmlTextReader
            Try
                dsXmlTr = New System.Xml.XmlTextReader _
                    (New IO.StringReader(sXML))
                dsRsp.ReadXml(dsXmlTr, XmlReadMode.IgnoreSchema)
            Catch ex As Exception
                Dim myex As New System.ApplicationException( _
                    "HandleAceResponse: " & dsRsp.DataSetName & ": Response=" & sXML, ex)
                ei.FailureCode = RPFailureCode.DataSetReadXmlError
                ei.ErrorCode = "XX"
                ei.ErrorMessage = myex.ToString
                LogAbendMessage(ei.ErrorMessage)
                Return ei
            Finally
                Try
                    ' Close XMLTextReader and underlying StreamReader
                    dsXmlTr.Close()
                Catch
                End Try

http://www.VBResizer.com

Forms/Controls Resizing/Tabbing

http://www.VBCompare.com

Compare Code

http://www.VBSortGen.com

Generate Sort Class in VB

http://www.Vbcompare.com/Check.Htm(1979

Check To MS)