How to use OdbcParameter for MySQL?
This is my current attempt:
command.Parameters.Add(new OdbcParameter("@username", username.Text));
command.Parameters.Add(new OdbcParameter("@password", password.Text));
command.CommandText = "INSERT INTO test.test (`user`,`password`) VALUES (@username,@password);";
command.ExecuteNonQuery();
but it seems to be not working. The database does create a new row, but it's values are NULL.
This works: (but I really need the parameters for other stuff)
command.CommandText = "INSERT INTO test.test (`user`,`password`) VALUES (`" + username.Text + "`,`" + password.Text + "`);";
command.ExecuteNonQuery();
What am I doing wrong?
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…