public bool updateData(modul k) { bool stat = false; try { Connection ConnG = new Connection(); ConnG.Konek(); strQuery = new MySqlCommand(); strQuery.Connection = ConnG.Conn; strQuery.CommandType = CommandType.Text; strQuery.CommandText = "UPDATE tblmodul SET MODUL=@MODUL"; strQuery.Parameters.AddWithValue("@MODUL", k.MODUL); strQuery.ExecuteNonQuery(); ConnG.Putus(); stat = true; } catch { } return(stat); }
//------------------CRUD public bool insertData(modul k) { bool stat = false; try { Connection ConnG = new Connection(); ConnG.Konek(); strQuery = new MySqlCommand(); strQuery.Connection = ConnG.Conn; strQuery.CommandType = CommandType.Text; strQuery.CommandText = "INSERT INTO tblmodul(MODUL) VALUES(@MODUL)"; strQuery.Parameters.AddWithValue("@MODUL", k.MODUL); strQuery.ExecuteNonQuery(); stat = true; ConnG.Putus(); } catch (Exception ex) { MessageBox.Show(ex.Message); } return(stat); }