我现在想做一个这个的查询:
用一个DropDownList1,与一个textbox,来控制查询方式,DropDownList1中可以几个选项,
我的方法是用一个存储过程,语句如下:@type 由DropDownList1.SelectedValue来值create Procedure Search
(
@Search nvarchar(255),
@type nvarchar(16)
)
ASSELECT
BookID,
BookName,
ISBN,
SalePrice,
BookImageFROM
BookWHERE
@type LIKE '%' + @Search + '%'GOCopyBookstore.BookStore search =new BookStore(); //做一个专门的函数 this.DataGrid1.DataSource=search.SearchBook(this.DropDownList1.SelectedValue,this.TextBox1.Text);
this.DataGrid1.DataBind();各位牛哥帮我看看吧!
用一个DropDownList1,与一个textbox,来控制查询方式,DropDownList1中可以几个选项,
我的方法是用一个存储过程,语句如下:@type 由DropDownList1.SelectedValue来值create Procedure Search
(
@Search nvarchar(255),
@type nvarchar(16)
)
ASSELECT
BookID,
BookName,
ISBN,
SalePrice,
BookImageFROM
BookWHERE
@type LIKE '%' + @Search + '%'GOCopyBookstore.BookStore search =new BookStore(); //做一个专门的函数 this.DataGrid1.DataSource=search.SearchBook(this.DropDownList1.SelectedValue,this.TextBox1.Text);
this.DataGrid1.DataBind();各位牛哥帮我看看吧!
http://singlepine.cnblogs.com/articles/391292.html
现在我这样做不能成功,请大家提几个方法。
public SqlDataReader SearchBook(string ctype, string searchtext)
{
SqlConnection cn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionStr"]);
SqlCommand com=new SqlCommand("search",cn);
com.CommandType=CommandType.StoredProcedure;
SqlParameter parameteSearch=new SqlParameter("@search",SqlDbType.NVarChar,255);
parameteSearch.Value=searchtext;
com.Parameters.Add(parameteSearch);
SqlParameter parametectype =new SqlParameter("@type",SqlDbType.NVarChar,50);
parametectype.Value=ctype;
com.Parameters.Add(parametectype);
cn.Open();
SqlDataReader result=com.ExecuteReader(CommandBehavior.CloseConnection);
return result; }