C#

string strConn = "Provider=SQLOLEDB;Data Source=(local)\\NetSDK;" +
                 "Initial Catalog=Northwind;Trusted_Connection=Yes;";
OleDbConnection cn = new OleDbConnection(strConn);
string strSQL = "SELECT CustomerID, CompanyName FROM Customers";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);

<br />
using System;<br />
using System.Xml;<br />
<br />
namespace DomNodeList<br />
{<br />
  class Program<br />
  {<br />
    static void Main(string[] args)<br />
    {<br />
      XmlDocument doc = new XmlDocument();<br />
      doc.Load(@"D:\workjjf\scripts\xml\MajorKeys.xml"); //<path to XML here><br />
      XmlNodeList majorKeyList = doc.SelectNodes(@"/Root/MajorKey");<br />
      foreach (XmlNode majorKeyNode in majorKeyList)<br />
      {<br />
        XmlElement majorElement = majorKeyNode as XmlElement;<br />
        string majorAttValue = "<null>";<br />
        if (majorElement != null)<br />
        {<br />
          string attValue = majorElement.GetAttribute("att");<br />
          if (attValue != null)<br />
          {<br />
            majorAttValue = attValue;<br />
          }<br />
        }<br />
        Console.WriteLine(majorAttValue);<br />
        XmlNodeList minorKeyList = majorKeyNode.SelectNodes(@"MinorKey");<br />
        foreach (XmlNode minorKeyNode in minorKeyList)<br />
        {<br />
          XmlElement minorElement = minorKeyNode as XmlElement;<br />
          string minorAttValue = "<null>";<br />
          if (minorElement != null)<br />
          {<br />
            string attValue2 = minorElement.GetAttribute("att");<br />
            if (attValue2 != null)<br />
            {<br />
              minorAttValue = attValue2;<br />
            }<br />
          }<br />
          Console.WriteLine("\t" + minorAttValue);<br />
          XmlNodeList valueList = minorElement.SelectNodes("Value");<br />
          foreach (XmlNode valueNode in valueList)<br />
          {<br />
            Console.WriteLine("\t\t" + valueNode.InnerText);<br />
          }<br />
        }<br />
      }<br />
      Console.ReadLine();<br />
    }<br />
  }<br />
}<br />

string TrimmedString = YourString.Trim();

Muammar© wrote:

you can use Christian's suggestion replacing white spaces.

string strTabs = "a\t\t\tb";
MessageBox.Show("Before: "+str);
MessageBox.Show("After: "+str.Replace("\t",@"<tab>"));

string strNewLines = "a\n\n\nb";
MessageBox.Show("Before: "+str);
MessageBox.Show("After: "+str.Replace("\n",@"<enter>"));