using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class Recherche_RechercheAvancee : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        SqlDataSource2.FilterExpression = "Productid = -1";
    }
    protected void Btchercher_Click(object sender, EventArgs e)
    {
        
        
        string filtre = "";
        if (TBproduit.Text != "") 
        {
            filtre = "Productname like '%" + TBproduit.Text+ "%'";
        }
        Lrecherche.Text = filtre;

        if (DropDownList1.SelectedValue != "-1")
        {
            if (filtre != "") filtre += " and ";
            filtre += "categoryid = " + DropDownList1.SelectedValue.ToString();
        }
        Lrecherche.Text = filtre;

        if (TBprix.Text != "")
        {
            if (filtre != "") filtre += " and ";
            filtre += " unitprice " + DDLprix.SelectedItem.Text+" "+ TBprix.Text;
        }
        Lrecherche.Text = filtre;

        SqlDataSource2.FilterExpression = filtre;
       
    }
}