In addition, we should notice that we¡¯ve designed the "advanced search" function just for integrity, for it only searches goods that must meet the four given conditions at the same time, as is proved by the following SQL script for the stored procedure (i.e. Pr_AdvanceSearchProduct) we need here.

ALTER PROCEDURE Pr_AdvanceSearchProduct(

@Name varchar(200),

@Sell varchar(200),

@MinDate datetime,

@MaxDate datetime,

@MinPrice money,

@MaxPrice money

)

AS

SELECT

*

FROM

Product

WHERE

Name like '%' + @Name + '%' AND Sell like '%' + @Sell + '%'

AND SellInDate >= @MinDate AND SellInDate <= @MaxDate

AND OutPrice >= @MinPrice AND OutPrice <= @MaxPrice

Next, after the use populates the searching data and click button ¡®Start to search¡­¡¯, the following event handler will be invoked:

protected void CommitBtn_Click(object sender,EventArgs e){

Product product = new Product();

DataSet ds = new DataSet("Product");

ds.Tables.Add(product.AdvanceSearchProduct(Name.Text,Sell.Text,

DateTime.Parse(MinDate.Text),DateTime.Parse(MaxDate.Text),

Decimal.Parse(MinPrice.Text),Decimal.Parse(MaxPrice.Text)));

ProductView.DataSource = ds;

ProductView.DataBind();

ProductView.Visible = ProductView.Rows.Count <= 0 ? false : true;

lblHint.Visible = ProductView.Rows.Count <= 0 ? true : false;

}

Apparently, the key lies in the member function named AdvanceSearchProductof the Product class, which further calls the above mentioned stored procedure Pr_AdvanceSearchProductto finish the research. By attaching the result dataset to the ProductView control and making it visible we finally see the results as shown in the above Figure 23.