private void Formcd_Load(object sender, EventArgs e)
{
ds = new DataSet();
conn = new connection();
try
{
string query = "Select * from cd where 1=1";
da = new MySqlDataAdapter(query, conn.myconnection());
da.Fill(ds, "cd");
dataGridView1.DataSource = ds.Tables["cd"];
dataGridView1.Refresh();
}
catch (Exception ex)
{
}
}
private void Formbuku_Load(object sender, EventArgs e)
{
ds = new DataSet();
conn = new connection();
try
{
string query = "Select * from buku where 1=1";
da = new MySqlDataAdapter(query, conn.myconnection());
da.Fill(ds, "buku");
dataGridView1.DataSource = ds.Tables["buku"];
dataGridView1.Refresh();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
private void formpengembalian_Load(object sender, EventArgs e)
{
conn = new connection();
ds = new DataSet();
da = new MySqlDataAdapter();
try
{
string query = "SELECT m.nama_mhs ,b.judul,( CASE WHEN p.STATUS = 1 THEN 'sedang pinjam' ELSE 'sudah dikembalikan' END ) AS 'status peminjaman',p.tgl_peminjaman FROM peminjaman p JOIN buku b ON b.kode = p.kode_buku LEFT JOIN mahasiswa m ON m.nrp = p.kode_peminjam WHERE 1 = 1 and p.status=1";
da = new MySqlDataAdapter(query, conn.myconnection());
da.Fill(ds, "peminjaman");
dataGridView1.DataSource = ds.Tables["peminjaman"];
dataGridView1.Refresh();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
private void btnsearch_Click(object sender, EventArgs e)
{
ds = new DataSet();
conn = new connection();
string query = "Select * from cd where 1=1";
try
{
query += " and judul='" + tbpencarian.Text + "'";
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
da = new MySqlDataAdapter(query, conn.myconnection());
//ds.Tables["buku"].Clear();
da.Fill(ds, "cd");
dataGridView1.DataSource = ds.Tables["cd"];
dataGridView1.Refresh();
}
private void databuku_Load(object sender, EventArgs e)
{
conn = new connection();
ds = new DataSet();
loadbuku();
}
private void databukuta_Load(object sender, EventArgs e)
{
conn = new connection();
loadbukuta();
}
private void peminjamanTA_Load(object sender, EventArgs e)
{
connection conn = new connection();
}
private void login_Load(object sender, EventArgs e)
{
conn = new connection();
}
private void datacd_Load(object sender, EventArgs e)
{
conn = new connection();
loadcd();
}
private void formhistory_Load(object sender, EventArgs e)
{
conn = new connection();
}