what is the return value of datetimepicker at VB.NET . My date variable at SQL is datetime and how does it synchronized with datetimepicker at my form?

Question

i'm getting issue with my code. what is the return value of datetimepicker at VB.NET . My date variable at SQL is datetime, and how does it synchronized with datetimepicker at my form?

here is the code

cmd.CommandText = "INSERT INTO PRODUCT(PRODUCT_ID, NAME, DATE_IN) VALUES ('" & Me.txtPRODUCT_ID.Text & "', '" & Me.txtNAME.Text & "', '" & _

Me.DateTimePicker1.Value.Date & "')"

thx in advance :)

Vulpes · Answer

Well Me.DateTimePicker1.Value.Date will return a DateTime but when converted to a string it may not be in a format which your SQL database recognizes. I'd try this modification which (in theory at least as it's an ISO standard) should always work: cmd.CommandText = INSERT INTO PRODUCT(PRODUCT_ID NAME DATE_IN) VALUES (' & Me.txtPRODUCT_ID.Text & ' ' & Me.txtNAME.Text & ' ' & _ Me.DateTimePicker1.Value.Date .ToString(yyyy-MM-dd) & ')

mohamad guntur · Answer

thx it works well :)