c# MySqlCommand doesn't appear to be resolving Parameters

Question

I'm trying to run a MySqlCommand with a parameter, but when I look in the SQL logs, the parameter is showing up.

I've tried with both @ and ?, tried with 'old syntax=yes' in my sqlconnection string also.

Here's my code.

bool CheckLoginDetails(string username, string password){
    DataTable dt = new DataTable ();
    MySqlCommand command = new MySqlCommand ("select * from `accounts` where `username` = '@username';", SL.Database.connection);
    command.Parameters.AddWithValue ("@username", username);
    dt.Load (command.ExecuteReader());
}

Here's the SQL logs.

150823  3:19:50    22 Connect   root@localhost on unity_test
       22 Query SHOW VARIABLES
       22 Query SHOW COLLATION
       22 Query SET character_set_results=NULL
       22 Init DB   unity_test
150823  3:19:52    22 Query select * from `accounts` where `username` = '@username'

I'm using .net 2.0 and I'm unsure of the mysql dll version, I found that here: http://forum.unity3d.com/threads/reading-database-and-or-spreadsheets.11466/

I'm unable to upgrade .net due to Unity. Any advice would be greatly appreciated!

paulsm4 · Accepted Answer · 2015-08-23 02:43:31Z

1

Suggestion (not tested):

bool CheckLoginDetails(string username, string password){
    string sql = select * from accounts where username = ?";
    MySqlCommand command  = new MySqlCommand(sql);
    command.Parameters.Add(new MySqlParameter("", username));
    MySqlDataReader r = command.ExecuteReader();
    ...
}

The main point is that "?" should work.

answered Aug 23, 2015 at 2:43

paulsm4

123k23 gold badges175 silver badges245 bronze badges

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

1 Comment

Thource Over a year ago

This one worked, thanks a lot! New code is like so, for anyone wondering.

MySqlCommand command = new MySqlCommand ("select * from accounts where username = ?username", SL.Database.connection); 		command.Parameters.Add(new MySqlParameter("username", username))

Ahmad Tijani · Accepted Answer · 2015-08-23 03:03:03Z

0

Try command.Parameters.Add("@username", MysqlDbType.Varchar).Value = username;

Should work !

answered Aug 23, 2015 at 3:03

Ahmad Tijani

4224 silver badges10 bronze badges

Comments

fraser jordan · Accepted Answer · 2015-08-23 03:54:28Z

0

Try this, change

MySqlCommand command = new MySqlCommand ("select * from `accounts` where `username` = '@username';", SL.Database.connection);
command.Parameters.AddWithValue ("@username", username);

to

MySqlCommand command = new MySqlCommand ("select * from accounts where username = @username;", SL.Database.connection);
command.Parameters.Add("@username", username);

answered Aug 23, 2015 at 3:54

fraser jordan

1142 silver badges10 bronze badges

Comments

Akshay · Accepted Answer · 2015-08-23 07:18:36Z

0

Try this(suggestion)

bool CheckLoginDetails(string username, string password){
DataTable dt = new DataTable ();
MySqlCommand command = new MySqlCommand ("select * from accounts where username = @username;", SL.Database.connection);
command.Parameters.AddWithValue ("@username", username);
dt.Load (command.ExecuteReader());

}

answered Aug 23, 2015 at 7:18

Akshay

711 silver badge7 bronze badges

Collectives™ on Stack Overflow

c# MySqlCommand doesn't appear to be resolving Parameters

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related