private void Fill_combo() { CRUD.sql = "SELECT * FROM teacher_attendance.teachers"; CRUD.cmd = new MySqlCommand(CRUD.sql, CRUD.con); Teachers.ValueMember = "id"; Teachers.DisplayMember = "name"; DataTable dt_teacher = CRUD.PreformCRUD(CRUD.cmd); Teachers.DataSource = dt_teacher; CRUD.sql = "SELECT * FROM teacher_attendance.courses"; CRUD.cmd = new MySqlCommand(CRUD.sql, CRUD.con); Courses.ValueMember = "id"; Courses.DisplayMember = "name"; DataTable dt_course = CRUD.PreformCRUD(CRUD.cmd); Courses.DataSource = dt_course; CRUD.sql = "SELECT * FROM teacher_attendance.rooms"; CRUD.cmd = new MySqlCommand(CRUD.sql, CRUD.con); Rooms.ValueMember = "id"; Rooms.DisplayMember = "name"; DataTable dt_room = CRUD.PreformCRUD(CRUD.cmd); Rooms.DataSource = dt_room; }
private void LoadData() { CRUD.sql = "SELECT * FROM teacher_attendance.courses"; CRUD.cmd = new MySqlCommand(CRUD.sql, CRUD.con); CRUD.cmd.Parameters.Clear(); DataTable dt = CRUD.PreformCRUD(CRUD.cmd); dvg1.DataSource = dt; }
private void ShowTeacher_Click(object sender, EventArgs e) { frteacher teacher = new frteacher(); teacher.ShowDialog(); Fill_combo(); CRUD.sql = "DELETE FROM teacher_attendance.attendance_management WHERE teacher_id NOT IN (SELECT teachers.id FROM teacher_attendance.teachers)"; CRUD.cmd = new MySqlCommand(CRUD.sql, CRUD.con); dvg1.DataSource = CRUD.PreformCRUD(CRUD.cmd); LoadData(); Reset(); }
private void execute(string mysql, string param) { CRUD.cmd = new MySqlCommand(mysql, CRUD.con); addparameters(param); DataTable dt = CRUD.PreformCRUD(CRUD.cmd); }