Insert string value to datetime column
<p>I have two columns named exam_date (string nvarchar) and submitted_date(Date Time). The exam_date will always be "dd-MM-yyyy" format.Now I want to insert exam_date to submitted date. How is it possible? 
I have tried like below but shows "String was not recognized as a valid DateTime."</p>

<pre><code> string submitted_date="12-04-2016";
 cmd111.Parameters.AddWithValue("@submitted_date",Convert.ToDateTime(submitted_date));
</code></pre>