xml

[Andy]

i am trying to externalize a connection string using xml.

here is my xml:

<?xml version='1.0'?>
<Settings>
  <Connection>
	<UserID>sa</UserID>
	<DataSource>Server</DataSource>
	<InitialCatalog>Database</InitialCatalog>
  </Connection>
</Settings>

here is some code i'm trying to get the date with:

Imports System.Xml
Module Module1
 
    Sub Main()
        Dim reader As XmlTextReader = New XmlTextReader("Settings.xml")
        While reader.Read()
            If reader.NodeType = XmlNodeType.Text Then
                Console.WriteLine(reader.Value)
            End If
        End While
 
        Console.ReadLine()
    End Sub
End Module

how can i build the connection string using 'UserID', 'DataSource', and 'InitialCatalog'?

connectionObject.ConnectionString = (xml files userid, datasource, initial catalog)

i'm lost

[Aman010]

Hi, try this

    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