title: C# Obeying the NewLine Character in a String Pulled from SQL server
body: <p>All (this is back-to-basics!), I have a string of information I am pulling from SQL Server. The string is something like</p>
  
  <pre><code>Hello, my name is Frank Butcher\n\n
  and I work at Watford Car lot, 
  and I am 65 years old.
  </code></pre>
  
  <p>The message is to be pulled into a message box to provide information on a process. I read the string using </p>
  
  <pre><code>SqlCommand cmd = new SqlCommand();
  cmd.Connection = conn;
  cmd.CommandTimeout = 0;
  cmd.CommandText = strSQL;
  strResult = cmd.ExecuteScalar().ToString();
  </code></pre>
  
  <p>this gets the string, but when I put this into my text box the message is displayed with <code>\n\n</code> not with the required double NewLine.</p>
  
  <p>I have tried using </p>
  
  <pre><code>strResult = strResult.Replace("\n", Environment.NewLine);
  </code></pre>
  
  <p>on the string but this does not help. Am I going mental, what am I doing wrong?</p>
  
  <p>Thanks for your time.</p>