date saving in SQL using vb.net

Question

I m using the following code to save the date from a textbox and selecting the date using date picker.

 If (String.IsNullOrEmpty(DobTxt.Text)) Then
        SQLCmd.Parameters.Add("@DOB", SqlDbType.Date).Value = DBNull.Value
    Else
        Dim DOBDte As date= String.Format("{0:YYYY-MM-dd}", DobTxt.Text.Trim())
        SQLCmd.Parameters.Add("@DOB", SqlDbType.Date).Value = DOBDte
    End If

Now the code works just fine with dates like ""

but when you go for a date like "10/01/2016" I get this error:

Conversion from string "10/30/2016" to type 'Date' is not valid

could you please help

I think you should learn about DateTime.TryParse and DateTime.TryParseExact. — mason
– mason, Commented Apr 6, 2017 at 20:12

dana · Accepted Answer · 2017-04-06 20:20:45Z

2

Use TryParse to convert the text value to a date.

Dim dateValue As Date
If String.IsNullOrWhiteSpace(DobTxt.Text) Then
    SQLCmd.Parameters.Add("@DOB", SqlDbType.Date).Value = DBNull.Value
ElseIf Date.TryParse(DobTxt.Text.Trim(), dateValue) Then
    SQLCmd.Parameters.Add("@DOB", SqlDbType.Date).Value = dateValue
Else
    ' alert the user that there is invalid input
End If

edited Apr 6, 2017 at 20:20

answered Apr 6, 2017 at 20:13

dana

18.3k7 gold badges71 silver badges91 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Seano666 Over a year ago

So anything that doesn't parse as a DateTime is null? That doesn't exactly help with his current problem, which is a date formatting issue. In addition, this would hide any date format error.

dana Over a year ago

Fair enough... I added another condition to alert the user on bad input. The value does need to be converted to a date at some point.

Daniel AG · Accepted Answer · 2017-04-06 20:27:32Z

-1

If you're using jQuery date picker, and your date format is not mm-dd-yy you should configure datepicker to that format:

$( ".selector" ).datepicker({
  dateFormat: "yy-mm-dd"
});

edited Apr 6, 2017 at 20:27

answered Apr 6, 2017 at 20:21

Daniel AG

3602 silver badges10 bronze badges

4 Comments

mason Over a year ago

How do you know jQuery date picker is being used?

Daniel AG Over a year ago

He said so in his post.

mason Over a year ago

He said "date picker". I imagine there's hundreds of date pickers out there.

JSON Over a year ago

ok, its a Jquery issue, this format works, 'M/dd/yyyy' other ones gimme the same error

Collectives™ on Stack Overflow

date saving in SQL using vb.net

2 Answers 2

2 Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related