Question

c#模糊查询数据库,SQL语句在数据库中可以运行,在控件中却不好用为什么?

UI层：DataSet ds = lcbll.FindcontrectByConditions(textBox1.Text, textBox2.Text);
dataGridView1.DataSource =ds.Tables[0];
BLL层：DataSet ds = LaborContractDal.FindByCondication(p, p_2);
return ds;
IDAL层： DataSet FindByCondication(string name, string number);
DAL层：public DataSet FindByCondication(string name, string number)
{List<SqlParameter> paramList = new List<SqlParameter>();
if (!string.IsNullOrWhiteSpace(name))
{sqlText += " and d.name like 'name'";
paramList.Add(new SqlParameter("@name", string.Format("%{0}%", name))); }
if (!string.IsNullOrWhiteSpace(number))
{sqlText += " and d.code like 'number'";
paramList.Add(new SqlParameter("@numbe", string.Format("%{0}%", number)));}
DataSet ds = ExecuteQuery(sqlText, paramList.ToArray());
return ds;

Answer 1

一定是传参数出了问题，个人建议，你既然采用了3层架构模式，那么你为何不使用SQL自带的存储过程呢？这样不仅【@xxx】参数和【xxx】参数不会搞混，传参数也方便，同时，在SQL里面写代码的难度一定比在程序中低，安全性也好，何乐而不为呢？ ^ ^

Answer 2

DAL层：public DataSet FindByCondication(string name, string number)
{List<SqlParameter> paramList = new List<SqlParameter>();
if (!string.IsNullOrWhiteSpace(name))

{sqlText += " and d.name like 'name'";//这里改成and d.name like @name

paramList.Add(new SqlParameter("@name", string.Format("%{0}%", name))); }
if (!string.IsNullOrWhiteSpace(number))

{sqlText += " and d.code like 'number'";//这里改成and d.code like @number

paramList.Add(new SqlParameter("@numbe", string.Format("%{0}%", number)));}
DataSet ds = ExecuteQuery(sqlText, paramList.ToArray());
return ds;

Answer 3

亲, dataGridView1.DataBind() 呢?