private void bCari_Click(object sender, RoutedEventArgs e) { try { koneksi c = new koneksi(); c.IntCon(); string QuerySelect = "Select * from barang where nama_barang like '%" + TCari.Text + "%'"; SQLiteCommand createCommend = new SQLiteCommand(QuerySelect); createCommend.ExecuteNonQuery(); SQLiteDataAdapter MysqlDtA = new SQLiteDataAdapter(createCommend); DataTable dt = new DataTable("barang"); MysqlDtA.Fill(dt); dataGrid.ItemsSource = dt.DefaultView; MysqlDtA.Update(dt); c.IntCon(); } catch (SQLiteException ex) { MessageBox.Show(ex.Message); } }
private void bsimpan_Click(object sender, RoutedEventArgs e) { koneksi c = new koneksi(); c.IntCon(); try { string QuerySelect = "insert into barang values('" + Tbarcode.Text + "', ('" + s + "'),'" + tnama.Text + "', '" + tmodal.Text + "','" + tharga.Text + "','" + tstok.Text + "')"; SQLiteCommand createCommend = new SQLiteCommand(QuerySelect, c.cn); createCommend.ExecuteNonQuery(); MessageBox.Show("penyimpana sukses"); } catch (SyntaxErrorException) { MessageBox.Show("Save has been failed"); } }
public void load() { koneksi c = new koneksi(); c.IntCon(); string QuerySelect = " Select * from barang "; SQLiteCommand createCommend = new SQLiteCommand(QuerySelect, c.cn); createCommend.ExecuteNonQuery(); SQLiteDataAdapter MysqlDtA = new SQLiteDataAdapter(createCommend); DataTable dt = new DataTable("barang"); MysqlDtA.Fill(dt); dataGrid.ItemsSource = dt.DefaultView; MysqlDtA.Update(dt); }
private void TCari_TextChanged(object sender, TextChangedEventArgs e) { koneksi c = new koneksi(); c.IntCon(); string QuerySelect = "Select * from barang where barcode like '%" + TCari.Text + "%'"; SQLiteCommand createCommend = new SQLiteCommand(QuerySelect, c.cn); createCommend.ExecuteNonQuery(); SQLiteDataAdapter MysqlDtA = new SQLiteDataAdapter(createCommend); DataTable dt = new DataTable("barang"); MysqlDtA.Fill(dt); dataGrid.ItemsSource = dt.DefaultView; MysqlDtA.Update(dt); }
private void button_Click_1(object sender, RoutedEventArgs e) { koneksi c = new koneksi(); c.IntCon(); string QuerySelect = "Select * from barang where barcode= '" + TCari.Text + "'"; SQLiteCommand createCommend = new SQLiteCommand(QuerySelect, c.cn); createCommend.ExecuteNonQuery(); SQLiteDataReader re; re = createCommend.ExecuteReader(); while (re.Read()) { string base64 = re.GetString(1); image.Source = ByteToImage(Convert.FromBase64String(base64)); } }
private void BTest_Click(object sender, RoutedEventArgs e) { koneksi cn = new koneksi(); cn.IntCon(); }