How do I store / retrieve the connection string in / from an XML file?

Once you get the connection string, you can store the connection string in the text file or an xml file and later retrieve it. Let’s see some example code to write a connection string to an XML file and read it back

C# Version

	string connStr = "";
	// get connection string in the connStr variable
	// Write connection string to xml file
	XmlDocument xmlDoc = new XmlDocument();
	XmlNode xn = xmlDoc.CreateNode(XmlNodeType.Element, "ConnectionString", "");
	xn.InnerText = connStr;
	xmlDoc.AppendChild(xn);
	xmlDoc.Save(@"C:\ConnectionString.xml");
		
	// ...
	// Read connection string from the text file
	XmlDocument xmlDoc = new XmlDocument();
	xmlDoc.Load(@"C:\ConnectionString.xml");
	XmlNode xn = xmlDoc.SelectSingleNode("ConnectionString");
	connStr = xn.InnerText;

VB.Net Version

      Dim connStr As String = ""
      ' get connection string in the connStr variable
      ' Write connection string to xml file
      Dim xmlDoc As New XmlDocument
      Dim xn As XmlNode
      xn = xmlDoc.CreateNode(XmlNodeType.Element, "ConnectionString", "")
      xn.InnerText = connStr
      xmlDoc.AppendChild(xn)
      xmlDoc.Save("C:\ConnectionString.xml")
      ' ...
      ' Read connection string from the xml file
      Dim xmlDoc As New XmlDocument
      xmlDoc.Load("C:\ConnectionString.xml")
      Dim xn As XmlNode
      xn = xmlDoc.SelectSingleNode("ConnectionString")
      connStr = xn.InnerText

Back

 

Advertisement

Free Magazine