Issue with mdmysql.Parameters.AddWithValue for string value

Question

When I try to insert a string value using mdmysql.Parameters.AddWithValue it generates an input format string exception. Following is the code which produces the error:

cmdmysql.Parameters.AddWithValue("@p_mode", MySqlDbType.VarChar).Value = "ccc";

I tried with varchar, string, text but nothing is working. Also if I put null in place of "ccc" then the record gets inserted into the table. The variable type for p_mode in table is varchar. What is the reason for this exception?

You are attempting to assign string to number or something like that. — KV Prajapati
– KV Prajapati, Commented Jan 3, 2012 at 6:33

aweis · Accepted Answer · 2012-01-03 06:50:38Z

1

The AddWithValue function takes only two inputs, 1. The parametername and 2. the value

cmdmysql.Parameters.AddWithValue("@p_mode", "ccc");

If you want to use the definition of types you must use the normal Add function:

cmdmysql.Parameters.Add("@p_mode", MySqlDbType.VarChar).Value = "ccc";

I would guess that the exception comes from your second input where you parse an MySqlDbType to the function and not the acutal value you want the returned mysqlparameter to have.

edited Jan 3, 2012 at 6:50

answered Jan 3, 2012 at 6:28

aweis

5,6564 gold badges37 silver badges54 bronze badges

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

3 Comments

dna Over a year ago

thnx the one with addvalue is working, but the other with add is giving the same error

dna Over a year ago

thnx it is working now with addwithvalue but giving same error if i use add

aweis Over a year ago

Can you show use some more code to set it into context and possibly also show the table structure, just the create statement for the table you insert into?

reshma k · Accepted Answer · 2012-01-03 06:29:47Z

0

Try this

cmdmysql.Parameters.AddWithValue("@p_mode","ccc");

answered Jan 3, 2012 at 6:29

reshma k

5441 gold badge3 silver badges11 bronze badges

2 Comments

KV Prajapati Over a year ago

No! this is not answer. "CCC" is string constant.

dna Over a year ago

thnx it is working now with addwithvalue but giving same error if i use add

Collectives™ on Stack Overflow

Issue with mdmysql.Parameters.AddWithValue for string value

2 Answers 2

3 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related