protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Session["supportUnit"] = null; RetrieveFromDB rtrvDB = new RetrieveFromDB(); DataSet fiscalYears = rtrvDB.GetFiscalYears(); int lastRecord = fiscalYears.Tables[0].Rows.Count - 1; String mostRecentFY = fiscalYears.Tables[0].Rows[lastRecord][0].ToString(); Session["MostRecentFY"] = mostRecentFY; // CategoryDropDownList.Items.Insert(0, new ListItem("Historical Percent Change", "0")); //CategoryDropDownList.Items[0].Attributes.Add("style", "color: silver"); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DataTable years = new DataTable(); years.Columns.Add("Text", typeof(String)); years.Columns.Add("Value", typeof(String)); DataRow row = years.NewRow(); row["Text"] = "Select"; row["Value"] = "Select"; years.Rows.Add(row); for (int i = 0; i <= 10; i++) { int year = 2010; DataRow row2 = years.NewRow(); row2["Text"] = (year + i).ToString(); row2["Value"] = (year + i).ToString(); years.Rows.Add(row2); } YearDropDownList.DataSource = years; YearDropDownList.DataTextField = "Text"; YearDropDownList.DataValueField = "Value"; YearDropDownList.DataBind(); RetrieveFromDB rtrvDB = new RetrieveFromDB(); DataSet fiscalYears = rtrvDB.GetFiscalYears(); //RetriveFiscalYears("All"); // DataSet fiscalYearsByCategory = rtrvDB.RetriveFiscalYearsAllCategories(); for (int i = 0; i < YearDropDownList.Items.Count; i++) { foreach (DataRow row2 in fiscalYears.Tables[0].Rows) { String fiscalYear = row2[0].ToString(); if (fiscalYear.GetLast(4) == YearDropDownList.Items[i].Value.ToString()) { // YearDropDownList.Items[i].Text = fiscalYear.GetLast(4) + " (draft)"; YearDropDownList.Items[i].Attributes.Add("style", "color: silver"); } } //foreach (DataRow row3 in fiscalYearsByCategory.Tables[0].Rows) //{ // String fiscalYear = row3[0].ToString(); // if (fiscalYear.GetLast(4) == YearDropDownList.Items[i].Value.ToString()) // { // // YearDropDownList.Items[i].Text = fiscalYear.GetLast(4) + " (completed)"; // YearDropDownList.Items[i].Attributes.Add("style", "color: silver"); // } //} } } }