visual basic data type mismatch in criteria expression??

[chili007]

i cant find the problem can anyone help me pls???


If userNameTextBox.Text <> "" Then
Dim sqlQRY As String = "INSERT INTO SalesOrder Values ('" & salesNoTextBox.Text & "', '" & orderDateTextBox.Text & "', '" & userNameTextBox.Text & "', '" & productCodeTextBox.Text & "', '" & quantityTextBox.Text & "')"
Try
conn.Open()
Dim cmd As OleDbCommand = New OleDbCommand(sqlQRY, conn)
cmd.ExecuteNonQuery()
Catch ex As OleDbException
MsgBox("Error: " & ex.ToString & vbCrLf)
Finally
conn.Close()
End Try
saveButton.Enabled = False
Else
MsgBox("Please select customer")
userNameTextBox.Focus()
End If

[Rabbit]

It's probably because you're trying to insert a string into that date field. But I have no idea because you haven't told us what the data types are for your fields.

[chili007]

i am doing a sales order form. pls help!!!

[Rabbit]

I did help. I helped all I could given the information that was provided.

[chili007]

so may i know which code i have to change?

[Rabbit]

I don't know what you have to change. I can only guess at the error because I don't have everything I need to know to pinpoint the error.

[nirgunpratik]

Try this and let me know if it works.....

"INSERT INTO SalesOrder Values ('" & salesNoTextBox.Text & "', '" & Convert.ToDateTime(orderDateTextBox.Text) & "', '" & userNameTextBox.Text & "', '" & productCodeTextBox.Text & "', '" & quantityTextBox.Text & "')"

[Killer42]

I wonder whether putting hashes (#) around the date value might help.

But yeah, what we really need is more info about the circumstances.