How do I execute a MySQL parameterized query in C#?

Question

When I run this command in MySQL:

SELECT * FROM v
WHERE v.firstname LIKE '%a%' OR middlename LIKE '%a%' OR lastname LIKE '%a%'

It returns 4 rows in the result set.

But when I run the same query using parameters in C# it returns only one.

SELECT * FROM v
WHERE v.firstname  LIKE ?word OR middlename LIKE ?word OR lastname 

cmd.Parameters.AddWithValue("word", '%'+key+'%');

I also tried '%' ?word '%' and adding the parameter (key) only, but this didn't work either.

How do I make this work?

How do you run your DbCommand? Show us the next statement after AddWithValue. — Al Kepp, Jan 26 '11 at 08:17
don't worry it's work the problem is not in query elsewhere. the codewar tag i make for testing that how it's work.if anyone have problem destroy them i have no objection on them. — , Jan 26 '11 at 08:33
This [question](http://stackoverflow.com/questions/664314/c-constructing-paramater-query-sql-like) seems to have addressed the problem you're having. — Chris W, Jan 26 '11 at 09:00

score 0 · Accepted Answer · answered Jan 26 '11 at 08:16

0

Are you using something like:

cmd.ExecuteScalar()

in your code? It will return only 1 record. Try

cmd.ExecuteReader()

instead.

answered Jan 26 '11 at 08:16

Cheng Chen

score 0 · Answer 2 · answered Jan 26 '11 at 08:36

0

It looks like you're missing "LIKE ?word" at then end of your second SQL statement.

answered Jan 26 '11 at 08:36

Brent Muir

score 0 · Answer 3 · answered Jan 26 '11 at 08:39

0

WHERE v.firstname LIKE ?word OR middlename LIKE ?word OR lastname are you missing lastname LIKE ?word ?

answered Jan 26 '11 at 08:39

Harish

3 Answers3