protected void DdlCategories_SelectedIndexChanged(object sender, EventArgs e)
{
string param = DdlCategories.SelectedValue;
Command cmd = new Command("select prod.ProductID, prod.ProductNumber, prod.Name, prix.ListPrice from Production.Product prod join Production.ProductListPriceHistory prix on prod.ProductID = prix.ProductID where prod.ProductSubcategoryID = @catID AND prix.EndDate is null order by ProductID");
cmd.AddParameter("@catID", param);
DataTable dt = conn.GetDataTable(cmd);
LabelNbrResults.Text = string.Format("{0} produits trouvés", dt.Rows.Count.ToString());
productListRepeater.DataSource = dt;
productListRepeater.DataBind();
}
