hi experts
i m facing a problem ,
i m using these code for inserting data, but showing error
“The Conversion of the char data type to a date time resulted in an out-of-rang date time value . The Statement Has been terminated “
Their is "ro_date" is datetime type field ins sql-server
Try
cmd.CommandText = "insert into ro_entry (ro_date) values ('" & DateTimePicker1.Value & " ')"
cn.Open()
cmd.ExecuteNonQuery()
Catch ex As Exception
MessageBox.Show(ex.Message)
Finally
cn.Close()
cmd.Parameters.Clear()
End Try