MySQL带有参数的选择查询 [英] MySQL select query with parameter
本文介绍了MySQL带有参数的选择查询的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试通过c#使用MYSQL选择查询.
I am trying to use MYSQL select query with c#.
以下用于搜索"ID"的查询工作正常:
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:
我的代码:
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"));
}
推荐答案
您可以尝试使用SQL Reader
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();
,然后使用Reader方法,例如reader.GetString("column_name"),....
and then use Reader methods like reader.GetString("column_name"), ....
这篇关于MySQL带有参数的选择查询的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文