Say I have this Xml taken from one of the threads as example:
To get the Xml text is:Code:<Settings> <Connection> <UserID>sa</UserID> <DataSource>Server</DataSource> <InitialCatalog>Database</InitialCatalog> </Connection> </Settings>
How about if i add in one time tag...Code:Dim m_xmld As XmlDocument Dim m_nodelist As XmlNodeList Dim m_node As XmlNode m_xmld = New XmlDocument() m_xmld.Load("Settings.xml") m_nodelist = m_xmld.SelectNodes("/Settings/Connection") For Each m_node In m_nodelist Dim UserID = m_node.ChildNodes.Item(0).InnerText Dim DataSource = m_node.ChildNodes.Item(1).InnerText Dim InitialCatalog = m_node.ChildNodes.Item(2).InnerText Next
How do i use the above node.ChildNodes method to get the "23" or "40" out from the Xml tag....Code:<Settings> <Connection> <UserID>sa</UserID> <DataSource>Server</DataSource> <InitialCatalog>Database</InitialCatalog> <Time hour="23" min="40"> </Connection> <Connection> <UserID>sa</UserID> <DataSource>Server</DataSource> <InitialCatalog>Database</InitialCatalog> <Time hour="23" min="40"> </Connection> </Settings>
I need to loop through all the nodes...and I am using XmlDocument...
Any suggestion or link will be appreciated...
Thanks




Reply With Quote