public void FillDDLYear() { try { DataTable dtyears = BLL_SCM_Report.GetVesselIssuesYears(); int minyear = int.MaxValue; int maxyear = int.MinValue; if (dtyears.Rows.Count > 0) { foreach (DataRow dr in dtyears.Rows) { int year = dr.Field <int>("ISSUE_CREATED_YEAR"); minyear = Math.Min(minyear, year); maxyear = Math.Max(maxyear, year); } Session["maxYear"] = maxyear.ToString(); } ddlYear.Items.Clear(); ddlYear.DataSource = dtyears; ddlYear.DataTextField = "ISSUE_CREATED_YEAR"; ddlYear.DataValueField = "ISSUE_CREATED_YEAR"; ddlYear.DataBind(); ListItem li = new ListItem("--SELECT ALL--", "0"); ddlYear.Items.Insert(0, li); } catch (Exception ex) { } }
public void FillDDLYear() { try { DataTable dtyears = BLL_SCM_Report.GetVesselIssuesYears(); ddlYear.Items.Clear(); ddlYear.DataSource = dtyears; ddlYear.DataTextField = "ISSUE_CREATED_YEAR"; ddlYear.DataValueField = "ISSUE_CREATED_YEAR"; ddlYear.DataBind(); ListItem li = new ListItem("--SELECT ALL--", "0"); ddlYear.Items.Insert(0, li); } catch (Exception ex) { } }