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)
{
}
}