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();
        }
    }