public void loadbirthDay_Dropdowns()
    {
        getstates();

        for (int i = 1; i < 32; i++)
        {

            dropdownDay.Items.Insert((i - 1), new ListItem(i.ToString(), i.ToString()));

        }
        int j = 0;

        for (int i = 1900; i < 2015; i++)
        {

            dropdownyears.Items.Insert(j, new ListItem(i.ToString(), i.ToString()));
            j++;
        }

        int c = DateTime.Now.Year;
        int c2 = c - 45;
        j = 1;
        for (int i = c; i >= c2; i--)
        {
            dropdownExamYear.Items.Insert(j, new ListItem(i.ToString(), i.ToString()));
            dropdownListexamyear2.Items.Insert(j, new ListItem(i.ToString(), i.ToString()));
            j++;
        }

        c2 = c - 35;
        j = 1;
        for (int i = c; i >= c2; i--)
        {
            dropdownJambExamYear_Previous.Items.Insert(j, new ListItem(i.ToString(), i.ToString()));
            dropdownyearCompleted_Previous.Items.Insert(j, new ListItem(i.ToString(), i.ToString()));
            dropdownIndustrialTrainingEndYear.Items.Insert(j, new ListItem(i.ToString(), i.ToString()));
            dropdownIndustrialTrainingYearStart2.Items.Insert(j, new ListItem(i.ToString(), i.ToString()));
            j++;
        }

        //j=1;

        //for (int x = c; x < c + 20; x++)
        //{
        //    dropdownIndustrialTrainingEndYear.Items.Insert(j, new ListItem(x.ToString(), x.ToString()));
        //    dropdownIndustrialTrainingYearStart2.Items.Insert(j, new ListItem(x.ToString(), x.ToString()));
        //    j++;
        //}
        //dropdownJambExamYear_Previous


        DatabaseFunctions db = new DatabaseFunctions();
        DataSet ds = new DataSet();
        ds = db.getdates_CBT(Convert.ToInt32(ViewState["programID"]));

        if (ds.Tables[0].Rows.Count > 0)
        {
            dropdownScheduleDate.DataSource = ds.Tables[0];
            dropdownScheduleDate.DataBind();
        }
        else
        {
            dropdownScheduleDate.Items.Clear();
            dropdownScheduleDate.Items.Insert(0, new ListItem("Select Date", ""));
            dropdownScheduleDate.DataBind();
        }

    }
    public void loadDates_CBT()
    {
        DatabaseFunctions db = new DatabaseFunctions();
        DataSet ds = new DataSet();
        ds = db.getdates_CBT(Convert.ToInt32(ViewState["programID"]));

        if (ds.Tables[0].Rows.Count > 0)
        {
            dropdownScheduleDate.DataSource = ds.Tables[0];
            dropdownScheduleDate.DataBind();
        }
        else
        {
            dropdownScheduleDate.Items.Clear();
            dropdownScheduleDate.Items.Insert(0, new ListItem("Select Date", ""));
            dropdownScheduleDate.DataBind();
        }

    }