private void TxtCariBarang_TextChanged(object sender, EventArgs e)
{
//cari nama barang
SqlConnection conn = konn.GetConn();
conn.Open();
cmd = new SqlCommand("execute cari_barang '" + TxtCariBarang.Text + "'", conn);
ds = new DataSet();
da = new SqlDataAdapter(cmd);
da.Fill(ds, "barang");
ListBarang.DataSource = ds;
ListBarang.DataMember = "barang";
ListBarang.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");
ListBarang.DataSource = ds;
ListBarang.DataMember = "barang";
ListBarang.Refresh();
}
catch (Exception e) {
MessageBox.Show(e.ToString());
}
finally {
conn.Close();
}
}
