mysql 参数查询,MySQL选择带有参数的查询

I am trying to use MYSQL select query with c#.

Following query for searching "ID" is working fine:

conn = new MySqlConnection(cs);

conn.Open();

cmd = conn.CreateCommand();

cmd.CommandText = "select * from catalog_product_entity where entity_id = ?Id";

MySqlDataAdapter adp = new MySqlDataAdapter(cmd);

cmd.Parameters.Add("?Id", SqlDbType.Text).Value = ProductList[i].ProductId.ToString();

adp.Fill(MagentoProduct);

Now, I want to search exact string value in table. I am using following code and its giving empty result:

My Code:

conn = new MySqlConnection(cs);

conn.Open();

cmd = new MySqlCommand("select * from catalog_category_entity_varchar where value = @Value;", conn);

cmd.Parameters.AddWithValue("@Value", "Storybooks");

MySqlDataReader r = cmd.ExecuteReader();

while (r.Read())

{

log.WriteEntry(r.GetString("value"));

}

解决方案

You could try SQL Reader

c = new MySqlCommand("select * from catalog_product_entity where column_nam = @Value;", conn);

c.Parameters.AddWithValue("@Value", your string);

MySqlDataReader r = c.ExecuteReader();

and then use Reader methods like reader.GetString("column_name"), ....