<div>
Try..<br />
<br />
AddParamater(&quot;@EffectiveDa<wbr />te&quot;, DateTime.Now , DbType.DateTime)<br />
<br />
Data Type in Database should be - DATETIME
</div>


Try..

AddParamater("@EffectiveDate", DateTime.Now , DbType.DateTime)

Data Type in Database should be - DATETIME

<div>
Thanks Pawan, this works to also pass today's date. I need to pass the selected date from the DateTimePicker.<br />
I tested it. so when I select a date, the value in the table defaults to today's date, which is my exact problem.<br />
thanks, please try to assist further, thanks
</div>


Thanks Pawan, this works to also pass today's date. I need to pass the selected date from the DateTimePicker.
I tested it. so when I select a date, the value in the table defaults to today's date, which is my exact problem.
thanks, please try to assist further, thanks

<div>
<div class="content wysiwyg-content">
I have a DateTimePicker as a calendar column inside a datagrid.<br />
testing the parameter with &quot;Today.Date&quot; then the record commits.<br />
When trying to use the date time Picker, it fails.<br />
my question is &quot;How do I pass a parameter to a Stored Procedure using a DateTimePicker from a calendar column (The calendar colum is obviously inside a datagridview)<br />
<br />
This is my current test code to pass the SP to the SQL table:<br />
<br />

<pre><code id="code-10-28978609-1">AddParamater(&quot;@EffectiveDate&quot;, Today.Date, DbType.Date)</code></pre>
</div>
</div>


I have a DateTimePicker as a calendar column inside a datagrid.
testing the parameter with "Today.Date" then the record commits.
When trying to use the date time Picker, it fails.
my question is "How do I pass a parameter to a Stored Procedure using a DateTimePicker from a calendar column (The calendar colum is obviously inside a datagridview)

This is my current test code to pass the SP to the SQL table:

(CODE)

How do I pass a Date value from a Calendar column using a Stored Procedure

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.