private void add_Click(object sender, EventArgs e) { string name = RoomNumber.Text; if (name == null) { MessageBox.Show("Please Enter Room Name!"); } studyroomsModal stm = new studyroomsModal(); stm.Name = name; stm.add(); }
private void delete_Click(object sender, EventArgs e) { string name1 = RoomNumber.Text; if (name1 == null) { MessageBox.Show("Please Select a row!"); } studyroomsModal stm = new studyroomsModal(); stm.id = idd; stm.delete(); }
public void add(studyroomsModal std) { try { string Query = "insert into studyrooms(Name) values('" + std.Name + "');"; MySqlCommand MyCommand2 = new MySqlCommand(Query, cnn); MySqlDataReader MyReader2; cnn.Open(); MyReader2 = MyCommand2.ExecuteReader(); MessageBox.Show("Save Data"); while (MyReader2.Read()) { } cnn.Close(); } catch (Exception ex) { } }
public void delete(studyroomsModal std) { try { string Query = "delete from studyrooms where id='" + std.id + "';"; MySqlCommand MyCommand2 = new MySqlCommand(Query, cnn); MySqlDataReader MyReader2; cnn.Open(); MyReader2 = MyCommand2.ExecuteReader(); MessageBox.Show("Data Deleted"); while (MyReader2.Read()) { } cnn.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void update(studyroomsModal std) { try { string Query = "update studyrooms set Name='" + std.Name + "' where id='" + std.id + "';"; MySqlCommand MyCommand2 = new MySqlCommand(Query, cnn); MySqlDataReader MyReader2; cnn.Open(); MyReader2 = MyCommand2.ExecuteReader(); MessageBox.Show("Data Updated"); while (MyReader2.Read()) { } cnn.Close();//Connection closed here } catch (Exception ex) { MessageBox.Show(ex.Message); } }