在做项目的时候遇到使用like参数查询,结合网上的例子..下面是常用的方法...测试成功
public static DataSet GetQuestionsBySubject(string subject)
{
if (string.IsNullOrEmpty(subject))
return null;
StringBuilder strb = new StringBuilder("select * from Question where subject like N'%'+@subject+'%'");
List<SqlParameter> list_Params = new List<SqlParameter>();
list_Params.Add(new SqlParameter("@subject", subject));;
return DBUtility.SqlHelper.ExecuteDataSet(new SqlConnection(Access.ConnectionString), strb.ToString(), list_Params.ToArray());
}
{
if (string.IsNullOrEmpty(subject))
return null;
StringBuilder strb = new StringBuilder("select * from Question where subject like N'%'+@subject+'%'");
List<SqlParameter> list_Params = new List<SqlParameter>();
list_Params.Add(new SqlParameter("@subject", subject));;
return DBUtility.SqlHelper.ExecuteDataSet(new SqlConnection(Access.ConnectionString), strb.ToString(), list_Params.ToArray());
}