Mysql query not working in C# but does in MySql Work Bench

Question

Would anyone be able to explain to me why this MySQL query doesn't work, I have tested the query in MySQL Work Bench and it works fine, I have also used the same C# code many times in other parts of this form application to pass the Data Base a query and that also works fine. Thanks.

public void addComboBox(ref Dictionary<string, string> folders)
            {
                comboBox1.Items.Clear();
                comboBox2.Items.Clear();
                string sqlGetFolders = "Select FolderName, FolderPath From folder, users Where folder.ID = users.ID and folder.ID = '@uID';";
                MySqlCommand command = new MySqlCommand(sqlGetFolders, connection);
                command.Parameters.AddWithValue("@uID", ID);
                MySqlDataReader reader = command.ExecuteReader();
                if (reader.HasRows)//bugging purposes
                {
                    MessageBox.Show("Has Rows");//bugging purposes
                    while (reader.Read())
                    {
                        folders.Add((reader[0]).ToString(), (reader[1]).ToString());//folders is a dictionary 
                        comboBox1.Items.Add((reader[0]).ToString());//lists
                        comboBox2.Items.Add((reader[0]).ToString());//lists
                        MessageBox.Show((reader[0]).ToString());//bugging purposes
                    }
                }
                else
                {
                    MessageBox.Show("No Rows");//bugging purposes
                }
                reader.Close();
            }

mybirthname · Accepted Answer · 2016-10-26 15:38:22Z

2

string sqlGetFolders = "Select FolderName, FolderPath From folder, users Where folder.ID = users.ID and folder.ID = @uID";

Your @uID parameter should not be in quotes. The quotes will be added automatically when the parameters are added.

edited Oct 26, 2016 at 15:38

answered Oct 26, 2016 at 15:35

mybirthname

18.2k3 gold badges35 silver badges59 bronze badges

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

2 Comments

User1 Over a year ago

Wow that was easy, Thanks.

mybirthname Over a year ago

@User1 you are welcome you can mark the question as correct.

Collectives™ on Stack Overflow

Mysql query not working in C# but does in MySql Work Bench

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related