Пример #1
0
        private void button11_Click(object sender, EventArgs e)
        {
            medicines deletemed = new medicines();

            deletemed.deleteMED(textBox12.Text);
            string          query       = "datasource=35.205.24.161;port=3306;username=m3dic;password=\"M3dic\"";
            MySqlConnection conDataBase = new MySqlConnection(query);
            MySqlCommand    cmdDataBase = new MySqlCommand("select name as `product`, price ,mgf as `MGF`, expiry  , description, manufacturer, quantity from M3dic.medicines", conDataBase);

            try
            {
                MySqlDataAdapter sda = new MySqlDataAdapter();
                sda.SelectCommand = cmdDataBase;
                DataTable dbdataset = new DataTable();
                sda.Fill(dbdataset);
                BindingSource bSorce = new BindingSource();
                bSorce.DataSource        = dbdataset;
                dataGridView3.DataSource = bSorce;
                sda.Update(dbdataset);
            }
            catch (Exception)
            {
                MessageBox.Show("Database error, please contact support", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            textBox12.Text = null;
            textBox15.Text = null;
            textBox19.Text = null;
            textBox13.Text = null;
            textBox16.Text = null;
            textBox20.Text = null;
        }
Пример #2
0
 private void button1_Click(object sender, EventArgs e)
 {
     if (checkinput())
     {
         medicines add = new medicines();
         add.addmedicine(textBox1.Text, textBox2.Text, textBox3.Text, textBox4.Text, textBox5.Text, textBox6.Text, textBox7.Text);
         MessageBox.Show("Successfully added new medicine", "Medicine added", MessageBoxButtons.OK, MessageBoxIcon.Information);
     }
     else
     {
         MessageBox.Show("Please fill all gaps!", "Invalid input", MessageBoxButtons.OK, MessageBoxIcon.Error);
     }
 }