在做项目的时候遇到使用like参数查询,结合网上的例子..下面是常用的方法...测试成功
public static DataSet GetQuestionsBySubject(string subject)
{
if (string.IsNullOrEmpty(subject))
return null;
![](/Images/OutliningIndicators/InBlock.gif)
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());
}
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
注意 : SQL 语句的写法 like N'%'+@subject+'%' 都是单引号