how to insert newline after word in sql table in c#
<p>I am trying to insert New Line after word car but it is not working with folowing solution</p>

<ol>
<li><code>Char(13)</code> - not working  </li>
<li><code>Environment.NewLine</code> - when i use this it works but appends '(' this char in sql rows like 'Car ( Rate:2CR' </li>
<li><code>\n\r</code> - not working </li>
</ol>

<p>Code:</p>

<pre><code>cmd.Parameters.AddWithValue("@ColumnCar", Car + "char(13)" + "Rate:2CR"; 
  //cmd.Parameters.AddWithValue("@ColumnCar", Car + "\n\r" + "Rate:2CR"; 
  //cmd.Parameters.AddWithValue("@ColumnCar", Car + Environment.NewLine + "Rate:2CR"; 

cmd.ExecuteNonQuery(); 
</code></pre>

<p>Need output in sql table <code>ColumnCar</code> row value as follows:</p>

<pre><code>Car
Rate:2cr  
</code></pre>

<p>Note : here after Car there will be a newline and then Rate:2Cr will be added</p>