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