62,074
社区成员
发帖
与我相关
我的任务
分享
#region 索引
// Press ButtonSearch on enter
Page.RegisterHiddenField("__EVENTTARGET", "btnIndex");
if (!IsPostBack)
{
if (this.Query != null)
{
search();
DataBind();
table = groupPurchaseItem.GetGroupPurchaseIndex("%" + txtIndex.Text.Trim() + "%");
Pagereturn();
Indexer.IntranetIndexer indexer = new Indexer.IntranetIndexer(Server.MapPath("index"));
indexer.AddDirectory(new DirectoryInfo(Server.MapPath("1.4")), "*.*");//添加索引数据文件
indexer.Close();
}
}..........
#endregion
CREATE PROCEDURE ProcT_BOOKSearch_BookInfo
@WhereStr varchar(50)
AS
exec(' SELECT * FROM T_BOOK where ' + @WhereStr)
GO
string commandText="select ,,, from tablename where 1=1 ";
if(condition1!=""){
commandText+="and column1 = @condition1";
}
if(condition2!=""){
commandText+="and column2 = @condition2";
}