Membuat Aplikasi sederhana
menggunakan C# dan database Mysql :
Dalam pembuatan aplikasi ini,
sayang menggunakan aplikasi adalah sebagai berikut :
-
Microsoft
Visual Studio 2012 Ultimate C#
-
Xampp
– phpmyadmin untuk mengelola database MySQL “xampp-win32-1.8.3-beta1-VC11-installer”
-
mysql-connector-net-6.7.4
Adapun Tahapan untuk membuat
aplikasi adalah sebagai Berikut :
1. Membuat database Menggunakan Code
SQl
CREATE DATABASE karyawan
2. Membuat Table untuk Login :
3. Membuat Desain Login dan source Code
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using MySql.Data.MySqlClient;
namespace DataKaryawan
{
public partial class LoginForm : Form
{
public LoginForm()
{
InitializeComponent();
}
MySqlConnection conn = new MySqlConnection("server=localhost;username=root;password=root;");
public bool trylogin (string username, string password)
{
MySqlCommand cmd = new MySqlCommand("select * from
karyawan.user where username='" +
username + "' and
password='" + password + "' ;");
cmd.Connection = conn;
conn.Open();
MySqlDataReader reader = cmd.ExecuteReader();
if (reader.Read() != false)
{
if (reader.IsDBNull(0) == true)
{
cmd.Connection.Close();
reader.Dispose();
cmd.Dispose();
return true;
}
else
{
cmd.Connection.Close();
reader.Dispose();
cmd.Dispose();
return true;
}
}
else
{
return false;
}
}
private void btn_login_Click(object sender, EventArgs e)
{
if (trylogin(txt_username.Text, txt_password.Text) == true)
{
MessageBox.Show("Selamat Datang");
this.Hide();
EntryData f2 = new EntryData();
f2.Show();
}
else
{
MessageBox.Show("User dan Password Salah");
}
}
}
}
4.
Membuat Database
Untuk Entry Data
5. Membuat Desain Entry Data dan
Source Code
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using MySql.Data.MySqlClient;
using System.IO;
namespace DataKaryawan
{
public partial class EntryData : Form
{
public EntryData()
{
InitializeComponent();
DBCombo();//Membuat Public ComboBox
}
void DBCombo()//Koneksi
Ke Database Melalui Combo Box dan menapilakannya
{
try
{
conn.Open();
string Lihat_data = "select * from data_kar;";
MySqlCommand cmd =
new MySqlCommand(Lihat_data,
conn);
MySqlDataReader
BacaData;
BacaData =
cmd.ExecuteReader();
while (BacaData.Read())
{
string ListNama =
BacaData.GetString("nama");
tampildata_combo.Items.Add(ListNama);
}
conn.Close();
cmd.Dispose();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
//Koneksi
Ke Database
MySqlConnection conn = new MySqlConnection("server=localhost;username=root;password=root;database=karyawan;");
//
Untuk Pilihan Radio Button Jenis Kelamin
string Jenis_Kelamin;
private void lk_btn_CheckedChanged(object sender, EventArgs e)
{
Jenis_Kelamin = "Laki - Laki";
}
private void pr_btn_CheckedChanged(object sender, EventArgs e)
{
Jenis_Kelamin = "Perempuan";
}
//
Untuk Pilihan Radio Button Status Perkawinan
string Status_Perkawinan;
private void BlmNkh_btn_CheckedChanged(object sender, EventArgs e)
{
Status_Perkawinan = "Belum Menikah";
}
private void nkh_btn_CheckedChanged(object sender, EventArgs e)
{
Status_Perkawinan = "Menikah";
}
private void cerai_btn_CheckedChanged(object sender, EventArgs e)
{
Status_Perkawinan = "Cerai";
}
//Untuk Memilih Gambar dan
Disimpan pada Database
private void plh_gmbr_btn_Click(object sender, EventArgs e)
{
OpenFileDialog DialogImg = new OpenFileDialog();
DialogImg.Filter = "JPG Files (*.jpg)|*.jpg|PNG Files
(*.png)|*.png|All Files (*.*)|*.*";
if (DialogImg.ShowDialog() == DialogResult.OK)
{
string ImgLoc =
DialogImg.FileName.ToString();
Img_Loc_txt.Text = ImgLoc;
Img_Foto.ImageLocation = ImgLoc;
}
}
//Private Untuk
membersihkan layar ketika disimpan, edit atau delete
private void BersihLayar()
{
nik_txt.Text = "";
nama_txt.Text = "";
tmpt_lhr_txt.Text = "";
tgl_lhr_timepicker.Text = "";
alamat_txt.Text = "";
Img_Foto.Image = null;
Img_Loc_txt.Text = "";
}
//Untuk
Menyimpan Data Kedalam Database MySQL
private void simpan_btn_Click(object sender, EventArgs e)
{
byte[] ImgByte = null;
FileStream FStream = new FileStream(Img_Loc_txt.Text,FileMode.Open, FileAccess.Read);
BinaryReader br = new BinaryReader(FStream);
ImgByte = br.ReadBytes((int)FStream.Length);
try
{
conn.Open();
string simpan_data = "insert into data_kar
(id,nik,nama,tmpt_lhr,tgl_lhr,jns_klmn,stat_kwn,alamat,picture) values
('" + null + "','" + nik_txt.Text + "','" + nama_txt.Text + "','" + tmpt_lhr_txt.Text + "','" + tgl_lhr_timepicker.Text + "','" +
Jenis_Kelamin + "','" + Status_Perkawinan + "','" + alamat_txt.Text + "',@Picture)";
MySqlCommand cmd =
new MySqlCommand(simpan_data,
conn);
cmd.Parameters.Add(new MySqlParameter("@Picture",
ImgByte));
cmd.ExecuteReader();
conn.Close();
MessageBox.Show("Data Berhasil Simpan");
BersihLayar();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
//Untuk Mengedit Data
Kedalam Database MySQL
private void edit_btn_Click(object sender, EventArgs e)
{
byte[] ImgByte = null;
FileStream FStream = new FileStream(Img_Loc_txt.Text, FileMode.Open, FileAccess.Read);
BinaryReader br = new BinaryReader(FStream);
ImgByte = br.ReadBytes((int)FStream.Length);
try
{
conn.Open();
string edit_data = "update data_kar set nik='" + nik_txt.Text + "',nama='" + nama_txt.Text + "',tmpt_lhr='" + tmpt_lhr_txt.Text + "',tgl_lhr='" + tgl_lhr_timepicker.Text + "',jns_klmn='"
+ Jenis_Kelamin + "',stat_kwn='" + Status_Perkawinan + "',alamat='" + alamat_txt.Text + "',picture=@Picture
where nik='" + nik_txt.Text + "'";
MySqlCommand cmd = new MySqlCommand(edit_data, conn);
cmd.Parameters.Add(new MySqlParameter("@Picture",
ImgByte));
cmd.ExecuteReader();
conn.Close();
MessageBox.Show("Data Berhasil Edit");
BersihLayar();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
//Untuk Menghapus Data dari
Database MySQL
DialogResult HapusResult;
private void hapus_btn_Click(object sender, EventArgs e)
{
try
{
conn.Open();
string Hapus_data = "delete from data_kar where nik='" + nik_txt.Text + "'";
MySqlCommand cmd =
new MySqlCommand(Hapus_data,
conn);
cmd.ExecuteReader();
conn.Close();
HapusResult = MessageBox.Show("Apakah Anda Ingin Menghapus Data","Konfirmasi",MessageBoxButtons.YesNo);
if (HapusResult == DialogResult.Yes)
{
string hapus_query =
Hapus_data;
BersihLayar();
}
else
{
MessageBox.Show
("Data Tidak Dihapus");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
//Untuk Keluar Dari
Aplikasi
private void keluar_btn_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Benarkah
Anda Ingin Keluar Dari Aplikasi Ini", "Konfirmasi",
MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
Application.Exit();
}
}
//Untuk Menampilkan Data
dari Database MySQL melalui ComboBox
private void tampildata_combo_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
conn.Open();
string LihatData = "select * from data_kar where nama='"+tampildata_combo.Text+"'";
MySqlCommand cmd =
new MySqlCommand(LihatData,
conn);
MySqlDataReader BacaData;
BacaData =
cmd.ExecuteReader();
while (BacaData.Read())
{
string SNik =
BacaData.GetInt32("nik").ToString();
string SNama =
BacaData.GetString("nama");
string STmpt_lhr =
BacaData.GetString("tmpt_lhr");
string STgl_lhr =
BacaData.GetString("tgl_lhr");
string SJns_Klmn =
BacaData.GetString("jns_klmn");
string SStat_Kwn = BacaData.GetString("stat_kwn");
string SAlamat =
BacaData.GetString("alamat");
nik_txt.Text = SNik;
nama_txt.Text = SNama;
tmpt_lhr_txt.Text = STmpt_lhr;
tgl_lhr_timepicker.Text =
STgl_lhr;
alamat_txt.Text =
SAlamat;
// Jenis Kelamin
if ((SJns_Klmn) == "Laki - Laki")
{
lk_btn.Checked = true;
}
else
{
pr_btn.Checked = true;
}
//Status Perkwinan
if ((SStat_Kwn) == "Belum
Menikah")
{
BlmNkh_btn.Checked = true;
}
else if ((SStat_Kwn) == "Menikah")
{
nkh_btn.Checked = true;
}
else
{
cerai_btn.Checked = true;
}
//Menampilkan Gambar
byte[] TampilGambar =
(byte[])(BacaData["picture"]);
if (TampilGambar == null)
Img_Foto.Image = null;
else
{
MemoryStream
MStream = new MemoryStream(TampilGambar);
Img_Foto.Image =
System.Drawing.Image.FromStream(MStream);
}
}
conn.Close();
cmd.Dispose();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}
|
