private void btnInsert_Click(object sender, EventArgs e) { MySqlConnection dbConnection = new MySqlConnection(MySqlConnectionString); string query = "INSERT INTO `products`(`name`, `mark`, `model`, `doors`, `engines`, `hp`, `cubic`, `gearbox`, `typeCar`, `serialNumber`, `category`, `subCategory`)" + " VALUES('" + txbproductName.Text + "','" + cmbMarka.Text + "','" + cmbmodel.Text + "','" + cmbdoor.Text + "','" + cmbengine.Text + "','" + txbhp.Text + "','" + txbcubic.Text + "','" + cmbgearbox.Text + "','" + cmbtypeCar.Text + "','" + txbserialNumber.Text + "','" + cmbcategory.Text + "','" + cmbSubCategory.Text + "')"; MySqlCommand cmd = new MySqlCommand(query, dbConnection); dbConnection.Open(); int check = cmd.ExecuteNonQuery(); if (check > 0) { MessageBox.Show("Добавянето е успешно"); } dbConnection.Close(); txbproductName.Text = ""; txbcubic.Text = ""; txbhp.Text = ""; txbserialNumber.Text = ""; cmbcategory.Text = ""; cmbdoor.Text = ""; cmbengine.Text = ""; cmbgearbox.Text = ""; cmbMarka.Text = ""; cmbmodel.Text = ""; cmbtypeCar.Text = ""; cmbSubCategory.Text = ""; last_product_insert_id = cmd.LastInsertedId; dbConnection.Close(); if (MetroFramework.MetroMessageBox.Show(this, "Желаете ли да добавите изображения към този продукт?", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { uploadImages(); } else { Form1 frm1 = new Form1(); frm1.Activate(); } }
private void Form2_FormClosed(object sender, FormClosedEventArgs e) { Form1 frm1 = new Form1(); frm1.Activate(); }