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