Re: Error using MySqlParameter

[Chris Cline]

A couple of thing to look into..

1. Is the column setup in your table to allow null values?

2. Unless you set a parameter you will need to change the "@" to a "?". The new .Net connector uses the "?" by default.

3. If you find the problem but need to have the insert return the new id add this to the end of the insert statement....

; SELECT LAST_INSERT_ID() AS id

and change

myCommand.ExecuteNonQuery()
to
myCommand..ExecuteScalar()

Just replace id with your unique or key column.

Give that a try