C#MySQL像查询不带参数 [英] c# MySQL like query not taking parameters

问题描述

我正在使用查询来查找特定字段中的关键字，当我将@parameter放到具有值的addparameter中时，它不起作用，但是当我直接输入该值时，它可以工作，任何人都可以帮助我将值传递为我查询的参数好吗?以下是我的代码:

I am using a query to find keywords in a particular field, when i put the @parameter and then addparameter with value it does not work, however when i input the value directly, it works, anyone can help me pass value as parameter to my query please? below are my codes:

这有效并检索标题中带有我"一词的任何记录.

This works and retrieves any record with the word "My" in its title.

string cmdText = "SELECT  * FROM tblshareknowledge where title LIKE '%My%'";
cmd = new MySqlCommand(cmdText, con);
//cmd.Parameters.AddWithValue("@myTitle", title);

这是行不通的:

string cmdText = "SELECT  * FROM tblshareknowledge where title LIKE '@myTitle'";
cmd = new MySqlCommand(cmdText, con);
cmd.Parameters.AddWithValue("@myTitle", title); 

推荐答案

您当前正在将参数放在引号中，这意味着它不再用作参数.我怀疑你想要

You're currently putting your parameter within quotes, which means it's no longer being used as a parameter. I suspect you want:

string cmdText = "SELECT * FROM tblshareknowledge where title LIKE @myTitle";
cmd = new MySqlCommand(cmdText, con);
cmd.Parameters.AddWithValue("@myTitle", "%" + title + "%");

这篇关于C#MySQL像查询不带参数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！