vb.net - Convert date time (dd/MM/yyyy) -


In a Data Gridviewview named DTO (Date of Birth), I have a datatyme and it has been replaced with MM / DD /.

Yyyy and I want to change it in this style (DD / MM / YAY). I have created this code and the "integer" type for "dd / mm / yyyy" is not valid for the conversion of string as "error" to me.

This is the SQL string

myCommand = "Update Doctor Basic Set" & amp; _ "DOB = Convert (datetime, '& amp; convert_fill (DGV1 (9, 0) Value.tostring (" dd / MM / yyyy "), # 1/1 / 1900 #) & amp;"' , 103) "& amp; _" Where DoctorId = "& amp; DGV1 (0, 0) Value

DGV1 = Datagram Convert_Nool is a sub that I did not find error when the field is zero and I have to make some changes and save it.

I do not understand what is wrong .. And what is the integer type in error.


Comments

Popular posts from this blog

python - Overriding the save method in Django ModelForm -

html - CSS autoheight, but fit content to height of div -

qt - How to prevent QAudioInput from automatically boosting the master volume to 100%? -