Getting Node values from the XML file using C# is pretty
simple, Read the XML file as shown below, then read the node and child nodes
that you have placed the values, Here I am getting the Connection string from
the XML file.
Previously we have seen how to Read the full content of XML file and place it to Datatable
XML
<BATCHEXTRACT>
<DBDETAILS>
<SQLCONNECTIONSTRING>server=dev.com.lpg;database=Oscar;uid=s_os;pwd=l@cto</SQLCONNECTIONSTRING>
<CONNECTIONTIMEOUT>6000</CONNECTIONTIMEOUT>
</DBDETAILS>
</BATCHEXTRACT>
C#
using System;
using System.Collections.Generic;
using System.Xml;
namespace COSTING_PURGE_BATCH
{
public class Common
{
public string
GetSQLConnectionString()
{
XmlDocument Docs = new
XmlDocument();
try
{
Docs.Load("CPB_Constants.xml");//file in Debug Folder
string ConString =
Docs.SelectSingleNode("//BATCHEXTRACT/DBDETAILS/SQLCONNECTIONSTRING").InnerText.ToString();
return ConString;
}
catch (Exception
ex)
{
throw ex;
}
}
}
}