Re: Datarow - Date type

[Terri Kelley]

I think this is what you are asking. I have a text box with mask for dob in a form. Sending it to mysql as a new row for instance I do the following:

newRow("dob") = Convert.ToDateTime(txtMaskDob.Text)

and it converts it to the proper format for mysql.

Problem I am having is coming from mysql to the textbox, like looking up a record. Coming from the db to the textbox it drops leading zeros so a dob of 05-15-1966 would look like 51-51-966 in the dob textbox. Haven't figured that one out yet.

Hope that helps

tk