/// <summary> /// CLASS MENGUBAH DATA SETELAH MENYIMPAN NAMA GAMBAR /// </summary> public void updatedata() { imagestat = (Bitmap)pictureBox3.Image.Clone(); ColorImageStatisticsDescription statDesc = new ColorImageStatisticsDescription(imagestat); OleDbConnection koneksi = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|/DataKopi.mdb"); OleDbCommand command = new OleDbCommand("UPDATE tabel_utama SET [Tingkat_Kematangan] = '" + comboBox1.SelectedItem + "',[Mean_Kadar_R] = '" + statDesc.RedMean.ToString() + "',[StDev_Kadar_R] = '" + statDesc.RedStdDev.ToString() + "',[Min_Kadar_R] ='" + statDesc.RedMin.ToString() + "',[Max_Kadar_R] = '" + statDesc.RedMax.ToString() + "',[Mean_Kadar_G] = '" + statDesc.GreenMean.ToString() + "',[StDev_Kadar_G] = '" + statDesc.GreenStdDev.ToString() + "',[Min_Kadar_G] ='" + statDesc.GreenMin.ToString() + "',[Max_Kadar_G] = '" + statDesc.GreenMax.ToString() + "',[Mean_Kadar_B] = '" + statDesc.BlueMean.ToString() + "',[StDev_Kadar_B] = '" + statDesc.BlueStdDev.ToString() + "',[Min_Kadar_B] ='" + statDesc.BlueMin.ToString() + "',[Max_Kadar_B] = '" + statDesc.BlueMax.ToString() + "' WHERE Gambar_Buah = '" + label14.Text + "'"); try { koneksi.Open(); command.Connection = koneksi; command.CommandType = CommandType.Text; command.ExecuteNonQuery(); MessageBox.Show("Saved!"); koneksi.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } data.Clear(); panggildatabase(); dataGridView1.DataSource = data; dataGridView1.DataMember = "utama"; dataGridView1.Refresh(); }
public void warna() { imagestat = (Bitmap)pictureBox3.Image.Clone(); ColorImageStatisticsDescription statDesc = new ColorImageStatisticsDescription(imagestat); label3.Text = "Red = " + statDesc.RedMax.ToString() + "\nGreen = " + statDesc.GreenMax.ToString() + "\nBlue = " + statDesc.BlueMax.ToString(); }