protected void DrpdlstCategory_SelectedIndexChanged(object sender, EventArgs e)
    {
        category = new CategoryBL();
        DrpdlstSubcategory.DataSource = category.GetSubCategory(Convert.ToInt32(DrpdlstCategory.SelectedItem.Value));
        DrpdlstSubcategory.DataBind();



        //if (DrpdlstCategory.SelectedItem.Value.ToString() == "Web Development")
        //{
        //    DrpdlstCategory.SelectedIndex = 1;
        //    DrpdlstSubcategory.Items.Clear();
        //    DrpdlstSubcategory.Items.Add(new ListItem("Web Design", "Web Design"));
        //    DrpdlstSubcategory.Items.Add(new ListItem("Web Programming", "Web Programming"));
        //    DrpdlstSubcategory.Items.Add(new ListItem("Ecommerce", "Ecommerce"));
        //    DrpdlstSubcategory.Items.Add(new ListItem("UI Design", "UI Design"));
        //    DrpdlstSubcategory.Items.Add(new ListItem("Website QA", "Website QA"));
        //    DrpdlstSubcategory.Items.Add(new ListItem("Website Project Management", "Website Project Management"));
        //    DrpdlstSubcategory.Items.Add(new ListItem("Other - Web Development", "Other - Web Development"));
        //}
        //else if (DrpdlstCategory.SelectedItem.Value.ToString() == "Software Development")
        //{
        //    DrpdlstCategory.SelectedIndex = 2;
        //    DrpdlstSubcategory.Items.Clear();
        //    DrpdlstSubcategory.Items.Add(new ListItem("Desktop Applications", "Desktop Applications"));
        //    DrpdlstSubcategory.Items.Add(new ListItem("Game Development", "Game Development "));
        //    DrpdlstSubcategory.Items.Add(new ListItem("Scripts & Utilities", "Scripts & Utilities"));
        //    DrpdlstSubcategory.Items.Add(new ListItem("Software Plug-ins ", "Software Plug-ins "));
        //    DrpdlstSubcategory.Items.Add(new ListItem("Mobile Apps", "Website QA"));
        //    DrpdlstSubcategory.Items.Add(new ListItem("Software QA", "Software QA"));
        //    DrpdlstSubcategory.Items.Add(new ListItem("Other - Software Development", "Other - Software Development"));
        //}
        //else if (DrpdlstCategory.SelectedItem.Value.ToString() == "Networking & Information Systems")
        //{
        //    DrpdlstCategory.SelectedIndex = 3;
        //    DrpdlstSubcategory.Items.Clear();
        //    DrpdlstSubcategory.Items.Add(new ListItem("Network Administration", "Network Administration"));
        //    DrpdlstSubcategory.Items.Add(new ListItem("DBA - Database Administration", "DBA - Database Administration"));
        //    DrpdlstSubcategory.Items.Add(new ListItem("Server Administration", "Server Administration"));
        //    DrpdlstSubcategory.Items.Add(new ListItem("ERP / CRM Implementation", "ERP / CRM Implementation"));
        //    DrpdlstSubcategory.Items.Add(new ListItem("Other - Networking & Information Systems", "Other - Networking & Information Systems"));
        //}
        //else if (DrpdlstCategory.SelectedItem.Value.ToString() == "Writing & Translation")
        //{
        //    DrpdlstCategory.SelectedIndex = 4;
        //    DrpdlstSubcategory.Items.Clear();
        //    DrpdlstSubcategory.Items.Add(new ListItem("Technical Writing", "Technical Writing"));
        //    DrpdlstSubcategory.Items.Add(new ListItem("Website Content", "Website Content"));
        //    DrpdlstSubcategory.Items.Add(new ListItem("Blog & Article Writing", "Blog & Article Writing"));
        //    DrpdlstSubcategory.Items.Add(new ListItem("Copywriting", "Copywriting"));
        //    DrpdlstSubcategory.Items.Add(new ListItem("Translation", "Translation"));
        //    DrpdlstSubcategory.Items.Add(new ListItem("Creative Writing", "Creative Writing"));
        //    DrpdlstSubcategory.Items.Add(new ListItem("Other - Writing & Translation", "Other - Writing & Translation"));
        //}
        //else if (DrpdlstCategory.SelectedItem.Value.ToString() == "Administrative Support")
        //{
        //    DrpdlstCategory.SelectedIndex = 5;
        //    DrpdlstSubcategory.Items.Clear();
        //    DrpdlstSubcategory.Items.Add(new ListItem("Data Entry", "Data Entry"));
        //    DrpdlstSubcategory.Items.Add(new ListItem("Personal Assistant", "Personal Assistant"));
        //    DrpdlstSubcategory.Items.Add(new ListItem("Web Research", "Web Research"));
        //    DrpdlstSubcategory.Items.Add(new ListItem("Transcription", "Transcription"));
        //    DrpdlstSubcategory.Items.Add(new ListItem("Other - Administrative Support", "Other - Administrative Support"));
        //}
        //else if (DrpdlstCategory.SelectedItem.Value.ToString() == "Design & Multimedia")
        //{
        //    DrpdlstCategory.SelectedIndex = 6;
        //    DrpdlstSubcategory.Items.Clear();
        //    DrpdlstSubcategory.Items.Add(new ListItem("Graphic Design", "Graphic Design"));
        //    DrpdlstSubcategory.Items.Add(new ListItem("Logo Design", "Logo Design"));
        //    DrpdlstSubcategory.Items.Add(new ListItem("Illustration", "Illustration"));
        //    DrpdlstSubcategory.Items.Add(new ListItem("Print Design", "Print Design"));
        //    DrpdlstSubcategory.Items.Add(new ListItem("3D Modeling & CAD", "3D Modeling & CAD"));
        //    DrpdlstSubcategory.Items.Add(new ListItem("Audio Production", "Audio Production"));
        //    DrpdlstSubcategory.Items.Add(new ListItem("Video Production", "Video Production"));
        //    DrpdlstSubcategory.Items.Add(new ListItem("Animation", "Animation"));
        //    DrpdlstSubcategory.Items.Add(new ListItem("Presentations", "Presentations"));
        //    DrpdlstSubcategory.Items.Add(new ListItem("Other - Design & Multimedia", "Other - Design & Multimedia"));

        //}
        //else if (DrpdlstCategory.SelectedItem.Value.ToString() == "Sales & Marketing")
        //{
        //    DrpdlstCategory.SelectedIndex = 7;
        //    DrpdlstSubcategory.Items.Clear();
        //    DrpdlstSubcategory.Items.Add(new ListItem("Advertising", "Advertising"));
        //    DrpdlstSubcategory.Items.Add(new ListItem("Email Marketing", "Email Marketing"));
        //    DrpdlstSubcategory.Items.Add(new ListItem("SEO - Search Engine Optimization", "SEO - Search Engine Optimization"));
        //    DrpdlstSubcategory.Items.Add(new ListItem("SEM - Search Engine Marketing", "SEM - Search Engine Marketing"));
        //    DrpdlstSubcategory.Items.Add(new ListItem("SMM - Social Media Marketing", "SMM - Social Media Marketing"));
        //    DrpdlstSubcategory.Items.Add(new ListItem("Telemarketing & Telesales", "Telemarketing & Telesales"));
        //    DrpdlstSubcategory.Items.Add(new ListItem("Market Research & Surveys", "Market Research & Surveys"));
        //    DrpdlstSubcategory.Items.Add(new ListItem("Sales & Lead Generation", "Sales & Lead Generation"));
        //    DrpdlstSubcategory.Items.Add(new ListItem("Other - Sales & Marketing", "Other - Sales & Marketing"));
        //}
        //else if (DrpdlstCategory.SelectedItem.Value.ToString() == "--- Select Category ---")
        //{
        //    DrpdlstCategory.SelectedIndex = 1;
        //    DrpdlstSubcategory.Items.Clear();
        //}
    }