how to insert date and time into sqldatabase

[shivananda]

hope every one doing well
i am new to vb.net when iam try to insert datetime into sqldatabase it is not inserting here is my code.
here unable to convert the datetime while inserting into database logs table

 con.open()
 Dim cmd As New SqlCommand("INSERT INTO logs ([username],[date_time])VALUES(@username,@datetimepicker1)", con)
                    With cmd.Parameters
                        .AddWithValue("@username", username.Text)
                        .AddWithValue("@date_time",datetimepicker1.text)
                    End With
                    cmd.ExecuteNonQuery()
                    cmd.Dispose()
                    con.Close()

[Rabbit]

Your parameters are named differently.

[vijay6]

Hey shivananda, line number 5 in your code replace '@date_time' by '@datetimepicker1'.

[shivananda]

hi vijay
its working
thank you for the suggestion