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
– Al Kepp, Commented Jan 26, 2011 at 8: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. — Steven Spielberg
– Steven Spielberg, Commented Jan 26, 2011 at 8:33
This question seems to have addressed the problem you're having. — Chris W
– Chris W, Commented Jan 26, 2011 at 9:00

Cheng Chen · Accepted Answer · 2011-01-26 08:16:26Z

0

Are you using something like:

cmd.ExecuteScalar()

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

cmd.ExecuteReader()

instead.

answered Jan 26, 2011 at 8:16

Cheng Chen

43.7k18 gold badges118 silver badges184 bronze badges

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

Comments

Brent Muir · Accepted Answer · 2011-01-26 08:36:06Z

0

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

answered Jan 26, 2011 at 8:36

Brent Muir

111 bronze badge

Harish · Accepted Answer · 2011-01-26 08:39:42Z

0

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

answered Jan 26, 2011 at 8:39

Harish

2,3344 gold badges24 silver badges28 bronze badges