Mysql Connector .Net: FormatException when trying to execute a command with parameters.

Question

I am using Mysql .Net Connector to access a database in C#. I get an FormatException when I try to execute a statement with parameter. Here is my code:

MySqlCommand comm = connection.CreateCommand();
comm.CommandText = "SELECT id_ FROM journalarticle WHERE title LIKE ?title";
comm.Parameters.Add("?title", DbType.AnsiString).Value = title;
MySqlDataReader reader = comm.ExecuteReader();
while (reader.Read())
{
   id = reader.GetInt32(0);
}
comm.Dispose();
reader.Dispose();

Also, and this can sometimes be a preference thing, but if you didn't know about the using statement instead of calling dispose you should, it's marvellous in my opinion: ryanfarley.com/blog/archive/2004/03/18/447.aspx — Paul C
– Paul C, Commented Jul 29, 2011 at 13:34

Paul C · Accepted Answer · 2011-07-29 13:21:39Z

2

Isn't it an @ symbol not a '?'

answered Jul 29, 2011 at 13:21

Paul C

4,7967 gold badges41 silver badges56 bronze badges

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

6 Comments

Paul C Over a year ago

Does your SQL run on its own, as in returns expected result in MS SQL Manager?

Luke Over a year ago

What? I don't understand your question.

Paul C Over a year ago

If you open up Microsoft SQL Manager (Express if you don't have paid for) does your Select statement return the expected result? Select blah from blah where blah like blah

Paul C Over a year ago

I have to admit I might be being ignorant here but can you not just replace 'DbType.AnsiString' with 'title' as in comm.Parameters.Add("?title", title);

Paul C Over a year ago

Can you mark it up as the answer please =) Why were you using 'DbType.AnsiString' anyway?

|

Collectives™ on Stack Overflow

Mysql Connector .Net: FormatException when trying to execute a command with parameters.

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related