private void barBtnPelanggan_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
ListPelanggan form = ListPelanggan.GetForm();
form.MdiParent = this;
form.Show();
form.Activate();
}
private void navBarItem15_LinkClicked(object sender, DevExpress.XtraNavBar.NavBarLinkEventArgs e)
{
ListPelanggan form = ListPelanggan.GetForm();
form.MdiParent = this;
form.Show();
form.Activate();
}
private void TxtCariPelanggan_TextChanged(object sender, EventArgs e)
{
//cari nama pelanggan
SqlConnection conn = konn.GetConn();
conn.Open();
cmd = new SqlCommand("execute cari_pelanggan '" + TxtCariPelanggan.Text + "'", conn);
ds = new DataSet();
da = new SqlDataAdapter(cmd);
da.Fill(ds, "pelanggan");
ListPelanggan.DataSource = ds;
ListPelanggan.DataMember = "pelanggan";
ListPelanggan.Refresh();
conn.Close();
}
//membuat prosedur atur pelanggan
void refresh_pelanggan()
{
SqlConnection conn = konn.GetConn();
try {
conn.Open();
cmd = new SqlCommand("select * from pelanggan", conn);
ds = new DataSet();
da = new SqlDataAdapter(cmd);
da.Fill(ds, "pelanggan");
ListPelanggan.DataSource = ds;
ListPelanggan.DataMember = "pelanggan";
ListPelanggan.Refresh();
}
catch (Exception e) {
MessageBox.Show(e.ToString());
}
finally {
conn.Close();
}
}
