protected void ListBCatFilterOne_SelectedIndexChanged(object sender, EventArgs e)
    {
        string name;

        // Take customNumber from screen
        try
        {
            name = ListBCatFilterOne.Text;
        }
        catch
        {
            name = "";
        }

        ProductCategoryService.serProductCategory categorynumber = new ProductCategoryService.serProductCategory();
        DataSet dataset = categorynumber.ProductCategory_GetProdOneFilterNumber(name);

        // Create a DataSet from Database

        if (dataset.Tables[0].Rows.Count > 0)
        {
            // Move data from data row to screen
            DataRow dr = dataset.Tables[0].Rows[0];

            tbMatchingCategory.Text = dr["productcategoryId"].ToString();
        }
        else
        {
            //setInitialValues();
            lbErr.Text = "No cat numb not selected";
        }
    }
    protected void ListBoxMainCategory_SelectedIndexChanged(object sender, EventArgs e)
    {
        string name;

        // Take customNumber from screen
        try
        {
            name = ListBoxMainCategory.Text;
        }
        catch
        {
            name = "";
        }

        ProductCategoryService.serProductCategory category = new ProductCategoryService.serProductCategory();
        DataSet dataset = category.ProductCategory_GetProdFilteronename(name);

        // Create a DataSet from Database

        ListBCatFilterOne.Items.Clear();

        foreach (DataRow dr in dataset.Tables[0].Rows)
        {
            string s = dr["name"].ToString();
            ListItem listItem = new ListItem();
            listItem.Text = s;
            listItem.Value = dr["name"].ToString();
            ListBCatFilterOne.Items.Add(listItem);
        }
    }
    protected void ListBoxMainCategory_SelectedIndexChanged(object sender, EventArgs e)
    {
        string name;

        // Take customNumber from screen
        try
        {
            name = ListBoxMainCategory.Text;
        }
        catch
        {
            name = "";
        }

        ProductCategoryService.serProductCategory category = new ProductCategoryService.serProductCategory();
        DataSet dataset = category.ProductCategory_GetProdFilteronename(name);

        // Create a DataSet from Database

        ListBCatFilterOne.Items.Clear();

        foreach (DataRow dr in dataset.Tables[0].Rows)
        {
            string   s        = dr["name"].ToString();
            ListItem listItem = new ListItem();
            listItem.Text  = s;
            listItem.Value = dr["name"].ToString();
            ListBCatFilterOne.Items.Add(listItem);
        }
    }
    private void populateCategory()
    {
        ProductCategoryService.serProductCategory category = new ProductCategoryService.serProductCategory();
        DataSet dataset = category.ProductCategory_GetAll();


        ListBoxMainCategory.Items.Clear();

        foreach (DataRow dr in dataset.Tables[0].Rows)
        {
            string   s        = dr["name"].ToString();
            ListItem listItem = new ListItem();
            listItem.Text  = s;
            listItem.Value = dr["name"].ToString();
            ListBoxMainCategory.Items.Add(listItem);
        }
    }
    private void populateCategory()
    {
        ProductCategoryService.serProductCategory category = new ProductCategoryService.serProductCategory();
        DataSet dataset = category.ProductCategory_GetAll();
  

        ListBoxCategory.Items.Clear();

        foreach (DataRow dr in dataset.Tables[0].Rows)
        {
            string s = dr["name"].ToString();
            ListItem listItem = new ListItem();
            listItem.Text = s;
            listItem.Value = dr["name"].ToString();
            ListBoxCategory.Items.Add(listItem);
        }
    }
    private void populateFashionCategory1()
    {
        ProductCategoryService.serProductCategory getfascategoryone = new ProductCategoryService.serProductCategory();
        DataSet dataset = getfascategoryone.ProductCategoryOne_GetAll();


        ListBoxF1.Items.Clear();

        foreach (DataRow dr in dataset.Tables[0].Rows)
        {
            string   s        = dr["name"].ToString();
            ListItem listItem = new ListItem();
            listItem.Text  = s;
            listItem.Value = dr["name"].ToString();
            ListBoxF1.Items.Add(listItem);
        }
    }
    protected void ListBCatFilterOne_SelectedIndexChanged(object sender, EventArgs e)
    {
        string name;

        // Take customNumber from screen
        try
        {
            name = ListBCatFilterOne.Text;
        }
        catch
        {
            name = "";
        }

        ProductCategoryService.serProductCategory categorynumber = new ProductCategoryService.serProductCategory();
        DataSet dataset = categorynumber.ProductCategory_GetProdOneFilterNumber(name);

        // Create a DataSet from Database

        if (dataset.Tables[0].Rows.Count > 0)
        {
            // Move data from data row to screen 
            DataRow dr = dataset.Tables[0].Rows[0];

            tbMatchingCategory.Text = dr["productcategoryId"].ToString();

        }
        else
        {
            //setInitialValues();
            lbErr.Text = "No cat numb not selected";
        }
    }
    private void populateFashionCategory1()
    {

        
        ProductCategoryService.serProductCategory getfascategoryone = new ProductCategoryService.serProductCategory();
        DataSet dataset = getfascategoryone.ProductCategoryOne_GetAll();
       

        ListBoxF1.Items.Clear();

        foreach (DataRow dr in dataset.Tables[0].Rows)
        {
            string s = dr["name"].ToString();
            ListItem listItem = new ListItem();
            listItem.Text = s;
            listItem.Value = dr["name"].ToString();
            ListBoxF1.Items.Add(listItem);
        }
    }