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(); } }