public List<Employee> GetDBEmployeeAbove30000() { employees = new List<Employee>(); using(SqlConnection conn = new SqlConnection()) { conn.ConnectionString = @"Server=USER-PC\SQLEXPRESS; Database=myDatabase; User Id=hao; Password=1234;"; conn.Open(); //create command SqlCommand com = new SqlCommand("select * from mytable where salary>=@minium",conn); //Creat a parameter // Add the parameters com.Parameters.Add(new SqlParameter("minium", 3000)); using (SqlDataReader reader = com.ExecuteReader()) { while(reader.Read()) { var employee = new Employee(); employee.ID = (int)reader[0]; employee.FirstName =(string) reader[1]; employee.LastName = (string)reader[2]; employee.Salary = (int)reader[3]; employees.Add(employee); } } } return employees; }
public List<Employee> GetDBEmployees() { employees = new List<Employee>(); using(SqlConnection conn = new SqlConnection()) { conn.ConnectionString = @"Server=USER-PC\SQLEXPRESS; Database=myDatabase; User Id=hao; Password=1234;"; conn.Open(); SqlCommand com = new SqlCommand("select * from mytable", conn); using(SqlDataReader reader = com.ExecuteReader()) { while(reader.Read()) { var employee = new Employee(); employee.ID = (int)reader["id"]; employee.FirstName = (string)reader["firstname"]; employee.LastName = (string)reader["lastname"]; employee.Salary = (int)reader["salary"]; employees.Add(employee); } } } return employees; }
public List<Employee> GetDBEmployeeUseWebConfig() { employees = new List<Employee>(); using(SqlConnection conn = new SqlConnection()) { conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["Test"].ConnectionString; conn.Open(); SqlCommand com = new SqlCommand("select * from mytable where salary>=@minium", conn); //Creat a parameter // Add the parameters com.Parameters.Add(new SqlParameter("minium", 3000)); using (SqlDataReader reader = com.ExecuteReader()) { while (reader.Read()) { var employee = new Employee(); employee.ID = (int)reader[0]; employee.FirstName = (string)reader[1]; employee.LastName = (string)reader[2]; employee.Salary = (int)reader[3]; employees.Add(employee); } } } return employees; }
public List<Employee> GetEmployees() { employees = new List<Employee>(); var emp = new Employee(); emp.FirstName = "Johnson"; emp.LastName = "Doe"; emp.Salary = 40000; employees.Add(emp); emp = new Employee(); emp.FirstName = "michael"; emp.LastName = "jackson"; emp.Salary = 16000; employees.Add(emp); emp = new Employee(); emp.FirstName = "robert"; emp.LastName = " pattinson"; emp.Salary = 20000; employees.Add(emp); return employees; }