DataSet.XMLRead not making any tables

Hi all,

I'm trying to turn the xml below into a dataset / datatable so I can display it in a gridview but it's returning 0 tables? Anythoughts?

<configuration>
    <system>
        <login>
            <user>
                <name>joeuser</name>
                <uid>2001</uid>
                <class>xyz</class>
                <authentication>
                    <encrypted-password>askldjfc;acmealsiefja;flcnsdlkm</encrypted-password>
                </authentication>
            </user>
			<user>
                <name>bobuser</name>
                <uid>2002</uid>
                <class>xyz</class>
                <authentication>
                    <encrypted-password>askldjfc;acmealsiefja;flcnsdlkm</encrypted-password>
                </authentication>
            </user>
			<user>
                <name>joeuser</name>
                <uid>2002</uid>
                <class>xyz</class>
                <authentication>
                    <encrypted-password>askldjfc;acmealsiefja;flcnsdlkm</encrypted-password>
                </authentication>
            </user>
        </login>
    </system>
</configuration>

       Dim objXMLSR As System.IO.StringReader = New System.IO.StringReader(xmlResponseString)
        Dim objDS As New DataSet
        objDS.ReadXml(objXMLSR, XmlReadMode.IgnoreSchema)
        gridOutput.DataSource = objDS.Tables("user")

Re: DataSet.XMLRead not making any tables

Try this

Dim xmlDocument = New XmlDocument()
xmlDocument.Load("Ur xml path") ' or xmlDocument.LoadXml(xmlResponseString)
Dim xmlReader = New XmlNodeReader(xmlDocument)
Dim dataSet = New DataSet()
dataSet.ReadXml(xmlReader)
Dim userTable = dataSet.Tables("user")

Re: DataSet.XMLRead not making any tables

Hi,

Try referencing this code

 Dim myDataSet as New DataSet() myDataSet.ReadXml(Server.MapPath("xyx.xml"))
        dg.DataSource = myDataSet
        dg.DataBind()

Thanks!

Re: DataSet.XMLRead not making any tables

bluelinenetworks
I'm trying to turn the xml below into a dataset / datatable so I can display it in a gridview but it's returning 0 tables? Anythoughts?

Hello

I think you should simplify your root tag to only oneand you can use DataSet.ReadXml to import the whole xml contents into a DataTable by referring its public property ofDataSet.Tables[0]please check this out

<configuration>
  <user>
    <name>joeuser</name>
    <uid>2001</uid>
    <class>xyz</class>
    <authentication>askldjfc;acmealsiefja;flcnsdlkm</authentication>
  </user>
  <user>
    <name>bobuser</name>
    <uid>2002</uid>
    <class>xyz</class>
    <authentication>your value2</authentication>
  </user>
  <user>
    <name>joeuser</name>
    <uid>2002</uid>
    <class>xyz</class>
    <authentication>your value3</authentication>
  </user>
</configuration>

And here's your code contents

DataSet ds = new DataSet()
ds.ReadXml("c:\\xxx.xml")

'fetch the DataTable instance to be used anyway……

ds.Tables(0)

Re: DataSet.XMLRead not making any tables

Ramesh T

Try this

Dim xmlDocument = New XmlDocument()
xmlDocument.Load("Ur xml path") ' or xmlDocument.LoadXml(xmlResponseString)
Dim xmlReader = New XmlNodeReader(xmlDocument)
Dim dataSet = New DataSet()
dataSet.ReadXml(xmlReader)
Dim userTable = dataSet.Tables("user")

Sorry but your answer isn't correct——Have you tried before pasting them outAnd your output cannot output the value of

authenticationit's 0

The reason is just the xml formation cannot be recognized by the XmlDocument or DataSet directly

Re: DataSet.XMLRead not making any tables

Hello Decker

Your xml formation doesn't seem rightwould you mind re-formatting them

Re: DataSet.XMLRead not making any tables

TimoYang

Hello Decker

Your xml formation doesn't seem rightwould you mind re-formatting them

Hi TimoYang

My codes have been all well-formattedand here's my codesthe xml contents are also formatted well aboveSo you can check it out

Module A
   
    Public Sub main()
        Dim xmlDocument = New XmlDocument()
        xmlDocument.Load("abc.xml")
        Dim xmlReader = New XmlNodeReader(xmlDocument)
        Dim dataSet = New DataSet()
        dataSet.ReadXml(xmlReader)
        Dim userTable = dataSet.Tables("user")

        For Each r As DataRow In userTable.Rows
            For Each c As DataColumn In userTable.Columns
                Console.Write(r(c).ToString() & "<===>")
            Next
            Console.WriteLine()
        Next
    End Sub
End Module

Re: DataSet.XMLRead not making any tables

@TimoYang

Yes, I did check and it works fine.

Wat do u mean?, posted xml is a well formed one.

can u clarify the below

authenticationit's 0?

The reason is just the xml formation cannot be recognized by the XmlDocument or DataSet directly?

Re: DataSet.XMLRead not making any tables

Ramesh T
Yes, I did check and it works fine.

RightSo sure

Now look at your result

joeuser<===>2001<===>xyz<===>0<===>0<===>
bobuser<===>2002<===>xyz<===>1<===>0<===>
joeuser<===>2002<===>xyz<===>2<===>0<===>

Can you see 0

And I've do some modifications to the codes from Decker to check your codes

Module A
    Public Sub main()
        Dim xmlDocument = New XmlDocument()
        xmlDocument.Load("abc.xml") ' or xmlDocument.LoadXml(xmlResponseString)
        Dim xmlReader = New XmlNodeReader(xmlDocument)
        Dim dataSet = New DataSet()
        dataSet.ReadXml(xmlReader)
        Dim userTable = dataSet.Tables("user")

        For Each row As DataRow In userTable.Rows
            For Each col As DataColumn In userTable.Columns
                Console.Write(row(col).ToString() + "<===>")
            Next
            Console.WriteLine()
        Next
    End Sub
End Module

Re: DataSet.XMLRead not making any tables

Sorry Mate, but did u explore the other tables in the dataset(output)?. There is an another table called 'Authentication' in it in which u could find the values/data u r expecting.

If u wanna see everything in the 'user' table then u should go with what Decker Dong suggested.

Re: DataSet.XMLRead not making any tables

Ramesh T

Sorry Mate, but did u explore the other tables in the dataset(output)?. There is an another table called 'Authentication' in it in which u could find the values/data u r expecting.

Not at all

Plz leave your email and I'll send you one sample

Re: DataSet.XMLRead not making any tables

Ramesh T
If u wanna see everything in the 'user' table then u should go with what Decker Dong suggested.

What's does that mean

Re: DataSet.XMLRead not making any tables

Ramesh T
Ramesh T

Wellif possibleplease put all of your complete codes for TimoYangnice contributor

Sorry that maybe you have a different kind of way but we cannot understand:( and I copied the TimoYang's sample to have a testthe result isn't actually right:(

Probably I've misunderstood youbut plz show us your real codes fully

timoYang
timoYang

I know that you are very careful and want to make contributions to the communitybut plz be kind and patient enough next time-

Re: DataSet.XMLRead not making any tables

Hi Ramesh T,

Sorry but to be very honest, your answer isn't rightYour user table doesn't include authentication values, and you've splitted values from xml contents into two tables, that's not what the author wanted!

Re: DataSet.XMLRead not making any tables

@TimoYang

I'm afraid, I don't have any other option to achieve this

So, u just have 2 options, either

- Reformat (simplify) xml as Decker Don suggessted (as below) and use the above suggessed code to see everything u expect in a single table ('User') and then bind it to any databound control

<configuration>
  <user>
    <name>joeuser</name>
    <uid>2001</uid>
    <class>xyz</class>
    <authentication>askldjfc;acmealsiefja;flcnsdlkm</authentication>
  </user>
  <user>
    <name>bobuser</name>
    <uid>2002</uid>
    <class>xyz</class>
    <authentication>your value2</authentication>
  </user>
  <user>
    <name>joeuser</name>
    <uid>2002</uid>
    <class>xyz</class>
    <authentication>your value3</authentication>
  </user>
</configuration>

- Use the input xml as it is and use the code we suggessted , which will output more than a table (User, Authentication, etc.). U could then construct a new datatable by merging whatever table u want and bind to any databound control. Please note that u have to merge tables manually as these tables have different schemas.

Re: DataSet.XMLRead not making any tables

Hi all,

Thanks for the responses. The problem with reformatting the xml is....I have no control over the XML as it comes from a query of a firewall.

I'm working on an application that I can query different portions of the configuration.

I do have the xsd files for the data, would applying that somehow make this more 'doable'? My concern there is that they are generally 40-50mb in size.

Re: DataSet.XMLRead not making any tables

bluelinenetworks
The problem with reformatting the xml is....I have no control over the XML as it comes from a query of a firewall.

Sorry to hear thatSo

1Either do what the contributor Richard's said

2Or you can output your whole xml contents into a temporary file and do modifications as what I saidand then Read them into a DataTable