Employee Model public class EmpModel { public int EmployeeId { get; set; } public string EmployeeName { get; set; } public int EmployeeStatus { get; set; } } public List<EmpModel> GetAllEmployees() { connection(); List<EmpModel> EmpList = new List<EmpModel>(); SqlCommand com = new SqlCommand("GetEmployees", con); com.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(com); DataTable dt = new DataTable(); con.Open(); da.Fill(dt); con.Close(); foreach (DataRow dr in dt.Rows) { EmpList.Add( new EmpModel { EmployeeId = Convert.ToInt32(dr["EmployeeId"]), EmployeeName = Convert.ToString(dr["EmployeeName"]), EmployeeStatus = Convert.ToInt32(dr["EmployeeStatus"]) } ); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)