using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data;
using System.Data.OleDb;
namespace Ariandes_db1
{
public class Andes
{
public static OleDbConnection con;
public static OleDbCommand cmd;
public static OleDbDataReader dtr;
public static OleDbDataAdapter daBuku;
public static DataTable tblBuku = new DataTable();
public static OleDbConnection konek_db()
{
OleDbConnection con = new OleDbConnection
("provider=microsoft.ace.oledb.12.0; data source=Dbperpustakaan.accdb");
con.Open();
return con;
}
}
}
(coding form)
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 System.Data.OleDb;
namespace Ariandes_db1
{
public partial class FrmBuku : Form
{
public FrmBuku()
{
InitializeComponent();
}
void ambildata()
{
Andes.tblBuku.Clear();
Andes.daBuku.Fill(Andes.tblBuku);
}
void bersih()
{
txtKodeBuku.Clear();
txtJudulBuku.Clear();
txtPengarang.Clear();
}
private void FrmBuku_Load(object sender, EventArgs e)
{
this.KeyPreview = true;
Andes.con = Andes.konek_db();
Andes.daBuku = new OleDbDataAdapter
("select * from Buku", Andes.con);
ambildata();
dataGridView1.DataSource = Andes.tblBuku;
dataGridView1.ReadOnly = true;
dataGridView1.AllowUserToAddRows = false;
dataGridView1.Columns[0].HeaderText = "Kode Buku";
dataGridView1.Columns[0].Width = 120;
dataGridView1.Columns[1].HeaderText = "Judul Buku";
dataGridView1.Columns[1].Width = 150;
dataGridView1.Columns[2].HeaderText = "Pengarang";
dataGridView1.Columns[2].Width = 150;
}
private void btnSimpan_Click(object sender, EventArgs e)
{
Andes.cmd = new OleDbCommand
("select * from Buku where Kode_Buku='" + txtKodeBuku.Text + "'", Andes.con);
Andes.dtr = Andes.cmd.ExecuteReader();
if (Andes.dtr.HasRows)
{
MessageBox.Show("Buku tersebut sudah ada", "Pesan",
MessageBoxButtons.OK,
MessageBoxIcon.Exclamation);
txtKodeBuku.Clear();
txtKodeBuku.Focus();
}
else if (txtKodeBuku.Text.Trim() == "")
{
MessageBox.Show("Kode Buku Tidak Terisi", "Pesan",
MessageBoxButtons.OK,
MessageBoxIcon.Exclamation);
txtKodeBuku.Clear();
txtKodeBuku.Focus();
}
else
{
Andes.cmd = new OleDbCommand
("insert into Buku(Kode_Buku,Judul_Buku,Pengarang) " +
"values ('" + txtKodeBuku.Text + "'," +
"'" + txtJudulBuku.Text + "'," +
"'" + txtPengarang.Text + "')", Andes.con);
Andes.cmd.ExecuteNonQuery();
ambildata();
MessageBox.Show("Data sudah tersimpan", "Pesan",
MessageBoxButtons.OK,
MessageBoxIcon.Information);
bersih();
}
}
private void FrmBuku_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode==Keys.Enter)
{
SendKeys.Send("{TAB}");
}
}
private void btnHapus_Click(object sender, EventArgs e)
{
int brs;
string kode;
brs = dataGridView1.CurrentRow.Index;
kode = dataGridView1[0, brs].Value.ToString();
if (MessageBox.Show("Apakah buku dengan kode =" + kode + "\n" +
"ingin dihapus?", "Pesan",
MessageBoxButtons.OKCancel,
MessageBoxIcon.Question) == DialogResult.OK)
{
Andes.cmd = new OleDbCommand
("delete from Buku where Kode_Buku='" + kode + "'", Andes.con);
Andes.cmd.ExecuteNonQuery();
ambildata();
MessageBox.Show("Data sudah terhapus", "Pesan",
MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
}
private void btnKoreksi_Click(object sender, EventArgs e)
{
if (btnKoreksi.Text == "Koreksi")
{
btnKoreksi.Text = "Edit";
btnSimpan.Enabled = false;
btnHapus.Enabled = false;
txtKodeBuku.Enabled = false;
int brs;
brs = dataGridView1.CurrentRow.Index;
txtKodeBuku.Text = dataGridView1[0, brs].Value.ToString();
txtJudulBuku.Text = dataGridView1[1, brs].Value.ToString();
txtPengarang.Text = dataGridView1[2, brs].Value.ToString();
}
else if (btnKoreksi.Text == "Edit")
{
btnKoreksi.Text = "Koreksi";
btnSimpan.Enabled = true;
btnHapus.Enabled = true;
txtKodeBuku.Enabled = true;
Andes.cmd = new OleDbCommand
("update Buku set " +
"Judul_Buku ='" + txtJudulBuku.Text + "'," +
"Pengarang='" + txtPengarang.Text + "' where " +
"Kode_Buku ='" + txtKodeBuku.Text + "'", Andes.con);
Andes.cmd.ExecuteNonQuery();
ambildata();
MessageBox.Show("Data sudah terEdit", "Pesan",
MessageBoxButtons.OK,
MessageBoxIcon.Information);
bersih();
}
}
}
}
(Output)
Tidak ada komentar:
Posting Komentar