作者为:麦克马纳斯,鲁迅
在以这个作者为关键字搜索的时候找不到数据,原因是中间有了个逗号BookPostSearch.aspx?BookAuthor={0}", Eval( "BookAuthor").ToString().Trim())%>sql += " select * from Lib_BookIsbnInfo where BookAuthor like '%" + Request.QueryString["BookAuthor"].Replace("'", "''") + "%'";如何处理,假如作者有三个或者只有一个的情况也要考虑,求教
在以这个作者为关键字搜索的时候找不到数据,原因是中间有了个逗号BookPostSearch.aspx?BookAuthor={0}", Eval( "BookAuthor").ToString().Trim())%>sql += " select * from Lib_BookIsbnInfo where BookAuthor like '%" + Request.QueryString["BookAuthor"].Replace("'", "''") + "%'";如何处理,假如作者有三个或者只有一个的情况也要考虑,求教
解决方案 »
- oracle数据库和IIS7安装在同一台机器上,asp.net mvc web项目部署有什么要求?
- 求一正则,急
- DropDownList去掉重复的记录
- 高分求助,(WebForm)GridView点击某一行,然后,弹出窗口,然后在新窗口中更新数据,提交后新窗口关闭,母窗口GridView数据进行更新
- 请问关于串口的网络实时监控问题
- asp.net
- 在线等,怎么让服务器端控件TextBox在每输入一个字符时都响应Textchanged事件
- treeview为何刷新之后再在初始化时建的树上再建一遍的树??
- 为什么在DataGrid中,编辑(或者是,换页)等,总是按两下才能执行?
- 招聘:如果你有数据库开发的经验,欢迎加盟!!!
- 我遇到了想不通的难题了,关于页面传参数
- 数据源“SqlDataSource1”仅支持名为“DefaultView”的单个视图。您也可以将视图名称(也称为数据成员)保留为空以选择默认视图
if(Request.QueryString["BookAuthor"]!=null)
{
sql += " and(1=2";
foreach(var author in Request.QueryString["BookAuthor"].Split(","))
sql += " or BookAuthor like '%" + author.Replace("'", "''") + "%'";
sql += “)";
}
sql += " select * from Lib_BookIsbnInfo where BookAuthor in('"+Request.QueryString["BookAuthor"].ToString()+"');
BookPostSearch.aspx?BookAuthor={0}", Eval( "BookAuthor").ToString().Trim())%>sql += " select * from Lib_BookIsbnInfo where CHARINDEX(','+BookAuthor+',',',Request.QueryString["BookAuthor"],')>0 ";
string str= Request.QueryString["BookAuthor"].Replace("'", "''") ;
sql += " select * from Lib_BookIsbnInfo where 1=1 and BookAuthor ";
foreach(string s in Regex.Split(str, ","))
{
sql+=" and (BookAuthor like '%" +s.Replace("'", "''") + "%')";
}
BookPostSearch.aspx?BookAuthor={0}", Eval( "BookAuthor").ToString().Trim())%>sql += " select * from Lib_BookIsbnInfo where CHARINDEX(','+BookAuthor+',',','+'"+ Request.QueryString["BookAuthor"]+"'+',')>0 ";