private void FilterProducts(string categoryName)
{
DrillDownDataSet ddds = (Session["DrillDownDataSet"] as DrillDownDataSet);
ProductsTableAdapter pta = new ProductsTableAdapter();
ddds.Products.Clear();
pta.FillBy(ddds.Products, categoryName);
}
private void FilterOrderDetails(string productName)
{
DrillDownDataSet ddds = (Session["DrillDownDataSet"] as DrillDownDataSet);
Order_DetailsTableAdapter oda = new Order_DetailsTableAdapter();
ddds.Order_Details.Clear();
oda.FillBy(ddds.Order_Details, productName);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DrillDownDataSet ddds = new DrillDownDataSet();
CategoriesTableAdapter cta = new CategoriesTableAdapter();
cta.Fill(ddds.Categories);
Session["DrillDownDataSet"] = ddds;
Session["detailsLevel"] = 0;
ShowCategories();
}
}