Re: date from MySql into text box dropping leading zeros SOLVED

[Terri Kelley]

I wasn't sure if this was a deal with MySql, the connector or .NET. I guess it is with .NET where the leading 0 is dropped in a string? Found the same to be true when hashing a password. If the hex value had a leading 0 then it got dropped so had to code for that. Anyway, back to this problem, I finally solved it by the following code:
Dim mydate As Date = Convert.ToDateTime(rowSel("dob").tostring)
Dim mydatedob as String = mydate.ToString("MMddyyyy")
txtMaskDob.Text = mydatedob
That displayed the date correctly. Maybe the long way to do it but it works.

tk