private List <SelectListItem> getdepartment() { MTSHRDataLayer.Employee data_dep = new MTSHRDataLayer.Employee(); List <SelectListItem> departmentlist = new List <SelectListItem>(); try { var employeeDepartment = data_dep.getDepartment(); departmentlist.Add(new SelectListItem() { Value = "", Text = "---- Select Department----" }); for (int i = 0; i < employeeDepartment.Tables[0].Rows.Count; i++) { departmentlist.Add(new SelectListItem() { Value = employeeDepartment.Tables[0].Rows[i]["id"].ToString(), Text = employeeDepartment.Tables[0].Rows[i]["Department"].ToString() }); } } catch (Exception exec) { BaseExceptionHandler.HandleException(ref exec); } return(departmentlist); }