private void TxtCariBarang_TextChanged(object sender, EventArgs e)
{
//membuat perintah cari barang berdasarkan kode atau nama
SqlConnection conn = konn.GetConn();
cmd = new SqlCommand("select * from barang where NamaBarang like '%" +
TxtCariBarang.Text + "%' or KodeBarang like '%" + TxtCariBarang.Text + "%'", conn);
ds = new DataSet();
da = new SqlDataAdapter(cmd);
da.Fill(ds, "barang");
DataGridBarang.DataSource = ds;
DataGridBarang.DataMember = "barang";
DataGridBarang.Refresh();
conn.Close();
}
//prosedur refresh barang
void refresh_barang()
{
SqlConnection conn = konn.GetConn();
try {
conn.Open();
cmd = new SqlCommand("select * from barang", conn);
ds = new DataSet();
da = new SqlDataAdapter(cmd);
da.Fill(ds, "barang");
DataGridBarang.DataSource = ds;
DataGridBarang.DataMember = "barang";
DataGridBarang.Refresh();
}
catch (Exception e) {
MessageBox.Show(e.ToString());
}
finally {
conn.Close();
}
}
