Error in inserting statement when inserting
<p>I am working on c# project and using winform. </p>

<p>Here the problem is the query was working previously but now it is not working </p>

<p>Here the <code>todaydate</code> is a <code>datetimePicker</code> which is set to short date format
and my datatype of column is <code>smalldatetime</code> the error i am getting is</p>

<pre><code> The conversion of a nvarchar data type to a
     smalldatetime data type resulted in an out-of-range value.
    The statement has been terminated.
</code></pre>

<p>if i have two date time picker one for date and second for time then how can i insert? please can you guide me</p>
