public bool myExecuteReader(string sqlString, CommandType type, ref GiaoVien giaoVien) { bool canExecute; if (connection.State == ConnectionState.Open) { connection.Close(); } connection.Open(); command.CommandText = sqlString; command.CommandType = type; try { SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { giaoVien.MaGV = reader.GetString(0); giaoVien.HoTen = reader.GetString(1); giaoVien.GioiTinh = reader.GetString(2); giaoVien.NgaySinh = reader.GetDateTime(3); giaoVien.DiaChi = reader.GetString(4); giaoVien.DienThoai = reader.GetString(5); giaoVien.Mon = reader.GetString(6); } canExecute = true; } catch { canExecute = false; } finally { connection.Close(); } return(canExecute); }
public bool myExecuteReader(string sqlString, CommandType type, ref List <GiaoVien> giaoViens) { bool canExecute; if (connection.State == ConnectionState.Open) { connection.Close(); } connection.Open(); command.CommandText = sqlString; command.CommandType = type; try { SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { GiaoVien giaoVien = new GiaoVien(); giaoVien.MaGV = reader.GetString(0); giaoViens.Add(giaoVien); } canExecute = true; } catch { canExecute = false; } finally { connection.Close(); } return(canExecute); }
partial void UpdateGiaoVien(GiaoVien instance);
partial void DeleteGiaoVien(GiaoVien instance);
partial void InsertGiaoVien(GiaoVien instance);