protected void Page_Load(object sender, EventArgs e)
        {
            if (IsPostBack)
                return;

            Classes.Product objProduct = new Classes.Product();

            SqlDataReader categoryData = objProduct.getParentCategoies();

            if (categoryData == null)
                return;

            while (categoryData.Read())
            {
                ListItem categoryItem = new ListItem(categoryData["name"].ToString(), categoryData["id"].ToString());
                lstCategory.Items.Add(categoryItem);

                Classes.Product objProductB = new Classes.Product();
                SqlDataReader childCategory = objProductB.getChildCategories(Convert.ToInt32(categoryData["id"]));

                if (childCategory != null)
                    while (childCategory.Read())
                    {
                        categoryItem = new ListItem("!_"+childCategory["name"].ToString(), childCategory["id"].ToString());
                        lstCategory.Items.Add(categoryItem);
                    }

                objProductB.close();
            }

            objProduct.close();
        }