date function problem
-
Hi , i took datetimepicker its format is dd-MMM-yyyy Command.Parameters.Add("@DOB", SqlDbType.DateTime, 50).Value = Format(dtpCustDOB.Value, "YYYY-MM-DD") i am getting "Failed to convert parameter value from a String to a DateTime Kindly suggest. i tried with cdate Thanks.
-
Hi , i took datetimepicker its format is dd-MMM-yyyy Command.Parameters.Add("@DOB", SqlDbType.DateTime, 50).Value = Format(dtpCustDOB.Value, "YYYY-MM-DD") i am getting "Failed to convert parameter value from a String to a DateTime Kindly suggest. i tried with cdate Thanks.
soniasan wrote:
Command.Parameters.Add("@DOB", SqlDbType.DateTime, 50).Value = Format(dtpCustDOB.Value, "YYYY-MM-DD") i am getting "Failed to convert parameter value from a String to a DateTime
The errors suggests that you pass a DateTime object. So, why are you converting the DateTime object the Date Time picker gave you in to a string first?
Upcoming FREE developer events: * Developer Day Scotland Recent blog posts: * Mixins in C#3.0 My website | Blog