c# smalldate pass to sql server proc
<p>I am trying to pass date to a sql procedure,  the time is being passed, and causing the proc to fail, because the times do not match,  c# is passing date 12:00:00 database shows date 00:00:00</p>

<p>so here is my code</p>

<pre><code>public class
datetime dt_value;
</code></pre>

<p>get the date from the javascript calendar</p>

<pre><code>DT_Value = Convert.ToDateTime(Request.Form["TextBox_Tracking_ImportDate"]);
</code></pre>

<p>try to convert to mm/dd/yyyy</p>

<pre><code>string DT_Value2 = DT_Value.ToString("ddMMyyyy");
</code></pre>

<p>pass date to sql</p>

<pre><code>cmd.Parameters.Add(new SqlParameter("@import_date", DT_Value2));


ERROR: Error converting data type nvarchar to smalldatetime.
</code></pre>
