c# Mysql query

See more:

C#

Okay so I can't seem to figure out what is wrong with the query I'm trying to do.

Here is the code I have

string name;
name = cbxnames.SelectedValue.ToString();
myConnection.GetConnection();
MySqlCommand cmd = new MySqlCommand("SELECT * FROM users WHERE name= "'+name+'", myConnection.GetConnection());

What i need the query to look like to actually return somthing from my db is

"SELECT * FROM users WHERE name = 'randomname'"

But I cannot figure out how to escape the strings to make it do that.