private void GetYear()
{
try
{
EmployeeBL obj = new EmployeeBL();
ddlFromYear.DataSource = obj.GetYear();
ddlFromYear.DataTextField = "year";
ddlFromYear.DataValueField = "year";
ddlFromYear.DataBind();
ddlFromYear.Items.Insert(0, new ListItem("Select", "Select"));
ddlFromYear.SelectedIndex = ddlFromYear.Items.IndexOf(ddlFromYear.Items.FindByText(System.DateTime.Now.ToString("yyyy")));
ddlToYear.DataSource = obj.GetYear();
ddlToYear.DataTextField = "year";
ddlToYear.DataValueField = "year";
ddlToYear.DataBind();
ddlToYear.Items.Insert(0, new ListItem("Select", "Select"));
ddlToYear.SelectedIndex = ddlToYear.Items.IndexOf(ddlToYear.Items.FindByText(System.DateTime.Now.ToString("yyyy")));
}
catch (Exception ex)
{
}
}