private void button2_Click(object sender, EventArgs e) { Hide(); TimeTableAdmin timetable = new TimeTableAdmin(); timetable.ShowDialog(); Close(); }
private void button3_Click(object sender, EventArgs e) { GetConnection(); string sql = "update timetable set part1='" + part1txt.Text + "', major='" + majortxt.Text + "', subject='" + subjecttxt.Text + "', sbno='" + sbnotxt.Text + "', day='" + daytxt.Text + "',time='" + timetxt.Text + "',location='" + locationtxt.Text + "',credit=" + credittxt.Text + ",professor='" + proftxt.Text + "' where sbno='" + sbnotxt.Text + "'"; MySqlCommand cmd = new MySqlCommand(sql, conn); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); MessageBox.Show(subjecttxt.Text + "이/가 수정되었습니다."); Hide(); TimeTableAdmin timetable = new TimeTableAdmin(); timetable.ShowDialog(); Close(); }
private void button1_Click(object sender, EventArgs e) { GetConnection(); string sql = "insert into timetable(part1, major, subject, sbno, day, time, location, credit, professor) values ('" + part1txt.Text + "','" + majortxt.Text + "','" + subjecttxt.Text + "','" + sbnotxt.Text + "','" + daytxt.Text + "','" + timetxt.Text + "','" + locationtxt.Text + "'," + credittxt.Text + ",'" + proftxt.Text + "')"; MySqlCommand cmd = new MySqlCommand(sql, conn); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); MessageBox.Show(subjecttxt.Text + "이/가 추가되었습니다."); Hide(); TimeTableAdmin timetable = new TimeTableAdmin(); timetable.ShowDialog(); Close(); }
private void button4_Click(object sender, EventArgs e) { GetConnection(); string sql = "delete from timetable where sbno='" + sbnotxt.Text + "'"; MySqlCommand cmd = new MySqlCommand(sql, conn); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); MessageBox.Show(subjecttxt.Text + "이/가 삭제되었습니다."); Hide(); TimeTableAdmin timetable = new TimeTableAdmin(); timetable.ShowDialog(); Close(); }