Replace string with another in DataColumn of DataTable
<p>I have <code>DataTable</code> which retrieves multiple columns and rows. One of its column ("Comments") Contains data <code>*</code>. I want replace that character with <code>\n</code>.</p>

<pre><code>dtOutput = Generix.getTickets(DateTime.Parse("1-1-1900"), DateTime.Now,"",iTicket, "", "", "", "","",iDispatched,uCode);
string sOutput = "";
foreach (DataRow drOutput in dtOutput.Rows)
{
   sOutput += ((sOutput == "") ? "" : "~");
   foreach (DataColumn dcOutput in dtOutput.Columns)
   {                                    
      sOutput += ((sOutput == "") ? "" : "|") + Convert.ToString(drOutput[dcOutput]);
   }
}
</code></pre>

<p>I am able to merge all columns in one String.
But how to replace character with another in store it in Same string as of <code>"sOutput"</code>.</p>
