private void BindPeriodYear() { DropDownListPeriodYear.DataSource = PeriodYear.GetPeriodYearList(); DropDownListPeriodYear.DataTextField = "Description"; DropDownListPeriodYear.DataValueField = "PeriodYearId"; DropDownListPeriodYear.DataBind(); DropDownListPeriodYear.Items.Insert(0, new ListItem("Please select", "0")); }
public static List <PeriodYear> GetPeriodYearList() { List <PeriodYear> list = new List <PeriodYear>(); Database db = DatabaseFactory.CreateDatabase("ProfitPlan"); string sqlCommand = "GetPeriodYearList"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { PeriodYear PeriodYear = new PeriodYear(); PeriodYear.PeriodYearId = Convert.ToInt32(dataReader["redPeriodYearId"]); PeriodYear.Description = dataReader["Year"].ToString(); list.Add(PeriodYear); } } return(list); }