private void DDLyear1() { try { using (OracleConnection sqlConn = new OracleConnection(strConn)) { using (OracleCommand sqlCmd = new OracleCommand()) { sqlCmd.CommandText = "select * from INS_YEAR"; sqlCmd.Connection = sqlConn; sqlConn.Open(); OracleDataAdapter da = new OracleDataAdapter(sqlCmd); DataTable dt = new DataTable(); da.Fill(dt); DDLyear.DataSource = dt; DDLyear.DataValueField = "YEAR_ID"; DDLyear.DataTextField = "YEAR_ID"; DDLyear.DataBind(); sqlConn.Close(); DDLyear.Items.Insert(0, new ListItem("--กรุณาเลือก ปี--", "0")); } } } catch { } }
protected void FillYear() { string year = DateTime.Now.Year.ToString(); List <string> years = new List <string>(); years.Add(year); DDLyear.DataSource = years; DDLyear.DataBind(); DDLyear.Items.Insert(0, new ListItem("שנה")); }
protected void FillYear() { int year = 1930; List <string> years = new List <string>(); for (int i = 0; year < 2011; i++, year++) { years.Add(year.ToString()); } DDLyear.DataSource = years; DDLyear.DataBind(); DDLyear.Items.Insert(0, new ListItem("שנה")); }
private void attachDDL(int id) { list l = BLL.BLL.getCommand(id); ArrayList yearList = new ArrayList(); ArrayList dayList = new ArrayList(); List <string> monthList = months.ToList(); ArrayList hourList = new ArrayList(); ArrayList minutesSecondsList = new ArrayList(); for (int i = 1; i < 99; i++) { yearList.Add(i + 2000); if (i <= 30) { dayList.Add(i); } if (i <= 24) { hourList.Add(i - 1); } if (i <= 60) { minutesSecondsList.Add(i - 1); } } DDLyear.DataSource = yearList; DDLyear.SelectedValue = l.time.Year.ToString(); DDLyear.DataBind(); DDLmonth.DataSource = monthList; DDLmonth.SelectedValue = months[l.time.Month - 1]; DDLmonth.DataBind(); DDLday.DataSource = dayList; DDLday.SelectedValue = l.time.Day.ToString(); DDLday.DataBind(); DDLhour.DataSource = hourList; DDLhour.SelectedValue = l.time.Hour.ToString(); DDLhour.DataBind(); DDLminute.DataSource = minutesSecondsList; DDLminute.SelectedValue = l.time.Minute.ToString(); DDLminute.DataBind(); DDLsecond.DataSource = minutesSecondsList; DDLsecond.SelectedValue = l.time.Second.ToString(); DDLsecond.DataBind(); ArrayList states = new ArrayList(); states.Add("ON"); states.Add("OFF"); DDLstate.DataSource = states; DDLstate.SelectedValue = l.state ? "ON" : "OFF"; DDLstate.DataBind(); }