private List <SelectListItem> getdesignation() { MTSHRDataLayer.Employee data_emp = new MTSHRDataLayer.Employee(); List <SelectListItem> designationlist = new List <SelectListItem>(); try { var employeedesignation = data_emp.getDesignation(); designationlist.Add(new SelectListItem() { Value = "", Text = "---- Select Designation----" }); for (int i = 0; i < employeedesignation.Tables[0].Rows.Count; i++) { designationlist.Add(new SelectListItem() { Value = employeedesignation.Tables[0].Rows[i]["id"].ToString(), Text = employeedesignation.Tables[0].Rows[i]["Designation"].ToString() }); } } catch (Exception exec) { BaseExceptionHandler.HandleException(ref exec); } return(designationlist); }