private void showGrid()
{
try
{
string sql = "select * from rak order by id_rak desc";
DBClass db = new DBClass();
dgv.DataSource = db.read(sql); //set data gridview
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
private void showGrid()
{
try
{
String sql = "select * from barang order by id_barang desc";
DBClass db = new DBClass(); //panggil class DB
dgv.DataSource = db.read(sql);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
private void cariToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
String sql = "select * from barang where barang like '%" + toolStripTextBox1.Text + "%' order by id_barang desc";
DBClass db = new DBClass(); //panggil class DB
dgv.DataSource = db.read(sql);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
private void cariToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
string sql = "select * from rak where rak " +
"like '%" + toolStripTextBox1.Text + "%' " +
"order by id_rak desc";
DBClass db = new DBClass();
dgv.DataSource = db.read(sql); //set data gridview
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
private void loadBarang()
{
try
{
String sql = "SELECT * FROM barang order BY id_barang desc";
DBClass db = new DBClass();
DataTable dt = new DataTable();
dt = db.read(sql);
dgv.DataSource = dt;
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
private void loadRak()
{
try
{
String sql = "select * from rak order BY id_rak desc";
DBClass db = new DBClass();
DataTable dt = new DataTable();
dt = db.read(sql);
cbxRak.DataSource = new BindingSource(dt, null);
cbxRak.DisplayMember = "rak";
cbxRak.ValueMember = "id_rak";
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
void loadRak()
{
try
{
String sql = "select * from rak order by id_rak asc";
DBClass db = new DBClass();
DataTable dt = new DataTable();
dt = db.read(sql);
cb_filter_1.DataSource = new BindingSource(dt, null);
cb_filter_1.DisplayMember = "rak"; //kolom harus sesuai dengan tabel
cb_filter_1.ValueMember = "id_rak";
cb_filter_2.DataSource = new BindingSource(dt, null);
cb_filter_2.DisplayMember = "rak"; //kolom harus sesuai dengan tabel
cb_filter_2.ValueMember = "id_rak";
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}