private void button2_Click(object sender, EventArgs e) { try { SQLiteDatabaseOperations sqliteDb = new SQLiteDatabaseOperations(); if (mode == 'a') { if (textBox1.Text.ToString().Length < 1) { MessageBox.Show("Name can not be blank"); return; } sqliteDb.SaveImgSndRecord(img_arr1, snd_arr1, textBox1.Text); } if (mode == 'e') { sqliteDb.UpdateImgSndRecord(img_arr1, snd_arr1, listBox1.SelectedItem.ToString()); } if (mode == 'd') { sqliteDb.DeleteImgSndRecord(listBox1.SelectedItem.ToString()); } listBox1.DataSource = getKeys(); resetScreen(); resetVariables(); } catch (Exception ex) { MessageBox.Show(ex.Message); resetScreen(); resetVariables(); } }
static void Main() { Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); SQLiteDatabaseOperations db = new SQLiteDatabaseOperations(); Application.Run(new Form1()); }
private void ArrayToSound() { if (listBox1.SelectedItem.ToString().Length > 0) { SQLiteDatabaseOperations sdb = new SQLiteDatabaseOperations(); snd_arr1 = sdb.getSound(listBox1.SelectedItem.ToString()); } }
private void ArrayToImage() { if (listBox1.SelectedItem != null && listBox1.SelectedItem.ToString().Length > 0) { SQLiteDatabaseOperations sdb = new SQLiteDatabaseOperations(); byte[] img_arr1 = sdb.getImage(listBox1.SelectedItem.ToString()); if (img_arr1 != null) { MemoryStream ms1 = new MemoryStream(img_arr1); ms1.Seek(0, SeekOrigin.Begin); System.Drawing.Image image = System.Drawing.Image.FromStream(ms1); pictureBox1.Image = image; } else { textBox4.Text = "No image file stored."; } } }
private List <string> getKeys() { SQLiteDatabaseOperations sqlop = new SQLiteDatabaseOperations(); return(sqlop.getKeys()); }