private void btnMasukkan_Click(object sender, EventArgs e)
{
string SQLCommand;
string peringatan = "Apakah anda sudah yakin dengan datanya???";
DialogResult dr = MessageBox.Show(peringatan, "Konfirmasi Tambah", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation);
if (dr == DialogResult.Yes)
{
SQLCommand = "INSERT INTO DataBuku (No_Seri_Buku, Nama_Buku, Nama_Penulis, Sisa) VALUES ('" + txtNoSeriBuku.Text + "', '" + txtNamaBuku.Text + "', '" + txtNamaPenulis.Text + "', '" + txtJumlah.Text + "')";
cmd = new OleDbCommand(SQLCommand, dbConnection);
try
{
dbConnection.Open();
if (cmd.ExecuteNonQuery() > 0)
{
DataBuku databuku = new DataBuku();
databuku.NoSeriBuku = txtNoSeriBuku.Text;
databuku.NamaBuku = txtNamaBuku.Text;
databuku.NamaPenulis = txtNamaPenulis.Text;
databuku.Sisa = Int32.Parse(txtJumlah.Text);
lblDataBuku.Visible = false;
lblJumlah.Visible = false;
lblNamaBuku.Visible = false;
lblNamaPenulis.Visible = false;
lblNoSeriBuku.Visible = false;
txtJumlah.Visible = false;
txtNamaBuku.Visible = false;
txtNamaPenulis.Visible = false;
txtNoSeriBuku.Visible = false;
btnMasukkan.Visible = false;
Insert(databuku);
}
dbConnection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
dbConnection.Close();
}
finally
{
dbConnection.Close();
}
btnHapus.Visible = true;
}
}
private void ViewBuku(string ParameterValue)
{
dgvBuku.Rows.Clear();
try
{
String sqlCommand = "SELECT ID, No_Seri_Buku, Nama_Buku, Nama_Penulis, Sisa FROM DataBuku";
// Buat objek baru dari connection database
cmd = new OleDbCommand(sqlCommand, dbConnection);
// buka database Access
dbConnection.Open();
adapter = new OleDbDataAdapter(cmd);
adapter.Fill(dataTable);
foreach (DataRow barisTabel in dataTable.Rows)
{
DataBuku databuku = new DataBuku();
databuku.Id = Int32.Parse(barisTabel[0].ToString());
databuku.NoSeriBuku = barisTabel[1].ToString();
databuku.NamaBuku = barisTabel[2].ToString();
databuku.NamaPenulis = barisTabel[3].ToString();
databuku.Sisa = Int32.Parse(barisTabel[4].ToString());
Populate(databuku);
}
dataTable.Rows.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
dbConnection.Close();
}
}
private void Insert(DataBuku databuku)
{
dgvBuku.Rows.Add(databuku.Id, databuku.NoSeriBuku, databuku.NamaBuku, databuku.NamaPenulis, databuku.Sisa);
}
