how to read XML from vb code and how to store that data in a dataset

[Vivek611]

Hi all,

Im working with Xml and VB, hre im facing a big problem,that-
I want read Xml file by VB code and that( read data collection) i have to put(store) in a dataset..,

I need code for this, plz send code ASPS...

Thanks,
Vivek

[Torgg]

Have you tried using this? I think the link below will get you started.

http://msdn2.microsoft.com/en-us/lib...yd(VS.71).aspx

Torgg

[ajayvaram]

this is not exactly useful, because here in code
string xmlData = "<XmlDS><table1><col1>Value1</col1></table1><table1><col1>Value2</col1></table1></XmlDS>";

directly giving whole string of the xml,
but we need to load dataset from xml ,by giving url( path in local system)

plz send needful code as require.............

Have you tried using this? I think the link below will get you started.

http://msdn2.microsoft.com/en-us/lib...yd(VS.71).aspx

Torgg

[Torgg]

I got this from techfarmer @ ITtoolbox Blogs

        'load xml into a dataset to use here
        Dim dSet As New DataSet
        Dim fs As FileStream
 
        'open the xml file so we can use it to fill the dataset
        Try
            fs = New FileStream("C:\test.xml", FileMode.Open)
        Catch ex As Exception
            Debug.WriteLine(e)
        End Try
 
        'fill the dataset
        Try
            dSet.ReadXml(fs)
        Catch ex As Exception
            Debug.WriteLine(ex)
        Finally
            fs.Close()
        End Try

I tested this code and it populated a Dataset with the xml data. Hope this helps

Torgg

[ajayvaram]

hi Togg,
ur code is working,but now my task is, i need to read whole Xml and that i have to put in a String,

example Xml:
<book genre="philosophy" publicationdate="1991" ISBN="1-861001-57-6">
<title Name="The Gorgias" title/>
<author name="Plato" author/>
</book>


then Suppose 'S' is string ,i need to store xml in S as
S ="<book genre="philosophy" publicationdate="1991" ISBN="1-861001-57- 6"> <title Name="The Gorgias" title/><author name="Plato" author/></book>"

atually im using bellow code to loadxml and to find required attibute values..
Set Xml = New DOMDocument30
Xml.async = False
Xml.loadXML (S)

send me code as required......


Thanks

[Plater]

So what you really want is to read the entire contents of an XML file into a single string?
What do you have need for a DataSet then?