DateTime Conversion Error asp.net with sql server
<pre><code>&lt;asp:TextBox ID="txtBox" runat="server"&gt;
&lt;/asp:TextBox&gt;
&lt;asp:CalendarExtender ID="ce" runat="server" TargetControlID="txtBox" Format="dd-MMM-yyyy"&gt;
&lt;/asp:CalendarExtender&gt;

using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Connection239"].ToString()))
{
    SqlCommand cmd = new SqlCommand("insert into tbl_testing(dttm) values('"+DateTime.Parse(txtBox.Text)+"')", con);
    con.Open();
    cmd.ExecuteNonQuery();
}
</code></pre>

<p>when i execute following error is coming. In which format should I send the date to sql server</p>

<p><strong>The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
The statement has been terminated.</strong>
Thanks in advance</p>
