- Reference nya harus ada mysql connector, Tutorial nya
- caranya install mysql connector, setelah selesai di install kemudian buka project yang ingin di connect menggunakan visual studio, lalu pada tampilan solution expolrer (ada di sebelah kanan atas setelah project dibuka) klik kanan di bagian reference > add reference > browse > pilih lokasi namespace mysql connector kalau saya ada di folder C:\Program Files (x86)\MySQL\MySQL Connector Net 6.8.8\Assemblies\v4.0\MySql.Data.dll > ok, selesai. masuk tahapan selanjutnya.
- Pertama buat design form nya, beri nama Pelajaran1.cs
- Lalu buat class koneksi ke database, nama class : Koneksi.cs
- Lalu code di form nya fungsi apa saja yang diinginkan
==========================================================================
CLASS KONEKSI KE DATABASE NYA, nama class : Koneksi.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using MySql.Data.MySqlClient;
using System.Windows.Forms;
namespace Latihan
{
class Koneksi
{
public static MySqlConnection getConnection()
{
MySqlConnection conn = new MySqlConnection("server=localhost; user=root; password=; database=dbmahasiswa;");
try
{
conn.Open();
Console.WriteLine("database ok");
}
catch (MySqlException e)
{
MessageBox.Show("error :" + e.Message);
}
return conn;
}
public static void Close()
{
if (getConnection() != null)
{
getConnection().Close();
}
}
public static void cekKoneksi()
{
MySqlConnection conn = new MySqlConnection("server=localhost; user=root; password=; database=dbmahasiswa;");
try
{
conn.Open();
MessageBox.Show("terkoneksi");
}
catch (MySqlException e)
{
MessageBox.Show("error :" + e.Message);
}
}
}
}
==========================================================================
STRUKTUR DATABASE NYA
==========================================================================
TAMPILAN FORM PELAJARAN1
Komponen2 dalam Form Pelajaran 1
- textbox tNAMA
- textbox tNIM
- textbox tALAMAT
- combobox cbAGAMA (items : Buddha, Kristen, Hindu, Katolik, Islam, Kong Hu Cu) supaya tidak bisa mengetik manual untuk inputnya, pada properties combobox ini dropdownstyle nya diganti menjadi dropdownlist
- radiobutton rbLAKI berada dalam radiogroup jk , supaya hanya bisa di pilih salah satu saja
- radiobutton rbPEREMPUAN berada dalam radiogroup jk , supaya hanya bisa di pilih salah satu saja
- checklistbox clHOBI (items : Lari, Renang, Masak, Musik, Seni Rupa, Film, Membaca)
- button bTAMPIL
- button bRESET
- button bKONEK
- button bINSERT
- button bSELECT
==========================================================================
FUNGSI DI FORM PELAJARAN 1
---------------------------------------------------------------------------------------------------------------------------------
NAMESPACES YANG DIPAKAI di form pelajaran 1
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using MySql.Data.MySqlClient;
MENAMPILKAN DATA YANG DIINPUT DI FORM :
private void bTAMPIL_Click(object sender, EventArgs e)
{
if (tNAMA.Text == "" || tNIM.Text == "" || tALAMAT.Text == "" || cbAGAMA.Text == "" || ((rbLAKI.Checked == false) && (rbPEREMPUAN.Checked == false)))
{
MessageBox.Show("belum terisi semua isi dulu form nya");
}
else
{
String nama = tNAMA.Text;
String nim = tNIM.Text;
String alamat = tALAMAT.Text;
String agama = cbAGAMA.Text;
String jenkel = "";
if (rbLAKI.Checked == true) { jenkel = "L"; }
else if (rbPEREMPUAN.Checked == true) { jenkel = "P"; }
else { jenkel = "-"; }
String hobi = "-";
for (int i = 0; i < clHOBI.Items.Count; i++)
{
if (clHOBI.GetItemCheckState(i) == CheckState.Checked)
{
hobi = hobi.TrimStart('-');
hobi += clHOBI.Items[i].ToString() + ",";
}
} hobi = hobi.TrimEnd(',');
MessageBox.Show("DATA\n" + nama + "\n" + nim + "\n" + alamat + "\n" + agama + "\n" + jenkel + "\n" + hobi + "\n");
}
}
INSERT DATA DI FORM KE DATABASE :
private void bINSERT_Click(object sender, EventArgs e)
{
if (tNAMA.Text == "" || tNIM.Text == "" || tALAMAT.Text == "" || cbAGAMA.Text == "" || ((rbLAKI.Checked == false) && (rbPEREMPUAN.Checked == false)))
{
MessageBox.Show("belum terisi semua isi dulu form nya");
}
else
{
String nama = tNAMA.Text;
String nim = tNIM.Text;
String alamat = tALAMAT.Text;
String agama = cbAGAMA.Text;
String jenkel = "";
if (rbLAKI.Checked == true) { jenkel = "L"; }
else if (rbPEREMPUAN.Checked == true) { jenkel = "P"; }
else { jenkel = "-"; }
String hobi = "-";
for(int i = 0; i < clHOBI.Items.Count; i++){
if (clHOBI.GetItemCheckState(i) == CheckState.Checked)
{
hobi = hobi.TrimStart('-');
hobi+= clHOBI.Items[i].ToString()+",";
}
} hobi = hobi.TrimEnd(',');
//MessageBox.Show("DATA\n" + nama + "\n" + nim + "\n" + alamat + "\n" + agama + "\n" + jenkel + "\n" + hobi + "\n");
String sql = "INSERT INTO mahasiswa (nama, nim, alamat, agama, jenkel, hobi) VALUES (@nama, @nim, @alamat, @agama, @jenkel, @hobi)";
MySqlCommand command = new MySqlCommand(sql, Koneksi.getConnection());
command.Parameters.AddWithValue("@nama", nama);
command.Parameters.AddWithValue("@nim", nim);
command.Parameters.AddWithValue("@alamat", alamat);
command.Parameters.AddWithValue("@jenkel", jenkel);
command.Parameters.AddWithValue("@agama", agama);
command.Parameters.AddWithValue("@hobi", hobi);
int d = command.ExecuteNonQuery();
if (d > 0)
{
Koneksi.Close();
MessageBox.Show("berhasil insert");
MessageBox.Show("DATA\n" + nama + "\n" + nim + "\n" + alamat + "\n" + agama + "\n" + jenkel + "\n" + hobi + "\n");
}
else {
MessageBox.Show("gagal insert");
}
}
}
SELECT DATA DARI DATABASE DAN MENAMPILKANNYA KE FORM :
private void bSELECT_Click(object sender, EventArgs e)
{
try
{
string query = "select * from mahasiswa Where nim = '" + tNIM.Text + "'";
MySqlDataReader reader = null;
MySqlCommand command = new MySqlCommand(query, Koneksi.getConnection());
reader = command.ExecuteReader();
while (reader.Read())
{
tNIM.Text = reader["nim"].ToString();
tNAMA.Text = reader["nama"].ToString();
tALAMAT.Text = reader["alamat"].ToString();
cbAGAMA.Text = reader["agama"].ToString();
String jkel = reader["jenkel"].ToString();
if(jkel == "L")
{ rbLAKI.Checked = true;}
else if(jkel == "P")
{rbPEREMPUAN.Checked = true;}
String hob = reader["hobi"].ToString();
if (hob.Contains("Lari") == true) {
clHOBI.SetItemCheckState(0, CheckState.Checked);
}
if (hob.Contains("Renang") == true)
{
clHOBI.SetItemCheckState(1, CheckState.Checked);
}
if (hob.Contains("Masak") == true)
{
clHOBI.SetItemCheckState(2, CheckState.Checked);
}
if (hob.Contains("Musik") == true)
{
clHOBI.SetItemCheckState(3, CheckState.Checked);
}
if (hob.Contains("Seni Rupa") == true)
{
clHOBI.SetItemCheckState(4, CheckState.Checked);
}
if (hob.Contains("Film") == true)
{
clHOBI.SetItemCheckState(5, CheckState.Checked);
}
if (hob.Contains("Membaca") == true)
{
clHOBI.SetItemCheckState(6, CheckState.Checked);
}
}
Koneksi.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
CEK KONEKSI KE DATABASE
private void bKONEK_Click(object sender, EventArgs e)
{
Koneksi.getConnection();
if (Koneksi.getConnection() != null)
{
MessageBox.Show("konek ke db");
}
else { MessageBox.Show("gagal konek ke db"); }
}
MERESET DATA DI FORM JADI KOSONG SEPERTI SAAT INISIASI APL
private void bRESET_Click(object sender, EventArgs e)
{
tNAMA.Text = "";
tNIM.Text = "";
cbAGAMA.Text = "";
rbLAKI.Checked = false;
rbPEREMPUAN.Checked = false;
tALAMAT.Text = "";
for (int i = 0; i < clHOBI.Items.Count; i++) {
clHOBI.SetItemCheckState(i, CheckState.Unchecked);}
}
