void Button1Click(object sender, EventArgs e)
{
Koneksi sambung = new Koneksi();
try{
sambung.buka();
MessageBox.Show("Berhasil Koneksi Database", "Konfirmasi");
this.Hide();
FormOperationDML tampil = new FormOperationDML();
tampil.ShowDialog();
}
catch (MySqlException ex)
{
switch (ex.Number)
{
case 0:
{ MessageBox.Show("Koneksi Gagal", "Konfirmasi"); }
break;
case 1045:
{ MessageBox.Show("Username atau Password Salah", "Konfirmasi"); }
break;
}
}
}
void SavetodbClick(object sender, EventArgs e)
{
sambung = new Koneksi();
sql = "INSERT INTO mahasiswa (stb, nama, alamat, nilai_tugas, nilai_mid, nilai_final, nilai_akhir, " +
"nilai_huruf, keterangan) " +
"VALUES ('" + inputstb.Text + "', '" + inputnama.Text + "', '" + alamat.Text + "', " + inputNT.Text + ", " + inputMID.Text + ", " + inputFinal.Text + ", " + inputFinal.Text + ", '" + nilaihuruf.Text + "', " +
"'" + ket.Text + "')";
try{
sambung.buka();
query = new MySqlCommand(sql, sambung.koneksi);
adapter = new MySqlDataAdapter(query);
query.ExecuteNonQuery();
MessageBox.Show("Data Berhasil Disimpan !!", "information");
this.Close();
} catch (Exception er) {
MessageBox.Show(er.Message);
}
FormOperationDML show = new FormOperationDML();
show.Refresh();
show.TampilDalamTable();
sambung.tutup();
}