Adding varchar parameter to MySQLCommand

Question

I'm trying to execute a MySQLCommand like so:

Dim comCommand As MySqlCommand

comCommand = New MySqlCommand("MyStoredProc", conConnection)
comCommand.CommandType = CommandType.StoredProcedure

myParam = New MySqlParameter("?myParam", SqlDbType.VarChar, 255) 'Error occurs here!
comCommand.Parameters.Add(myParam )
myParam .Value = "test"

comCommand.ExecuteNonQuery()

But I keep getting the following error when creating the "varchar" parameter:

"Invalid data type"

It seems to be something to do with the "size" parameter, but I don't see what is wrong with it. Can anyone help?

Try using MySqlDbType instead of SqlDbType?

Derek
– Derek

2011-08-22 13:06:43 +00:00
Commented Aug 22, 2011 at 13:06 — Derek
– Derek, Commented Aug 22, 2011 at 13:06
Thanks. That was the problem.

Urbycoz
– Urbycoz

2011-08-22 13:51:29 +00:00
Commented Aug 22, 2011 at 13:51 — Urbycoz
– Urbycoz, Commented Aug 22, 2011 at 13:51
i added it as an answer for the sake of completeness

Derek
– Derek

2011-08-22 13:54:08 +00:00
Commented Aug 22, 2011 at 13:54 — Derek
– Derek, Commented Aug 22, 2011 at 13:54

Derek · Accepted Answer · 2011-08-22 13:53:47Z

2

Try using MySqlDbType instead of SqlDbType?

answered Aug 22, 2011 at 13:53

Derek

23.5k8 gold badges55 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Andrej · Accepted Answer · 2011-08-22 13:13:40Z

1

Try to use without size

New MySqlParameter("?myParam", SqlDbType.VarChar)

answered Aug 22, 2011 at 13:13

Andrej

7,5041 gold badge22 silver badges22 bronze badges

1 Comment

Urbycoz Over a year ago

This does seem to work. But I think Derek's solution is probably the right one.

Collectives™ on Stack Overflow

Adding varchar parameter to MySQLCommand

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related