private void btnSave_Click(object sender, EventArgs e) { try { if (MessageBox.Show("Are you sure to save this Vandor?", "Save Product", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { //Saving Product cn.Open(); cm = new SqlCommand("INSERT INTo tblVendor(vendor, address, contactperson, telephone, email, fax)VALUES(@vendor, @address, @contactperson, @telephone, @email, @fax)", cn); cm.Parameters.AddWithValue("@vendor", txtVendor.Text); cm.Parameters.AddWithValue("@address", txtAddress.Text); cm.Parameters.AddWithValue("@contactperson", txtContactPerson.Text); cm.Parameters.AddWithValue("@telephone", txtVendor.Text); cm.Parameters.AddWithValue("@email", txtEmail.Text); cm.Parameters.AddWithValue("@fax", txtFax.Text); cm.ExecuteNonQuery(); cn.Close(); MessageBox.Show("Product has been successfully saved.", "Product Saved", MessageBoxButtons.OK, MessageBoxIcon.Information); clear(); f.LoadVandors(); } } catch (Exception ex) { cn.Close(); MessageBox.Show(ex.Message); } }
private void btnVendor_Click(object sender, EventArgs e) { ReferenceBtn.Enabled = true; ReferenceFrm.Close(); btnVendor.Enabled = false; frmVendorList frm = new frmVendorList(); ReferenceFrm = frm; ReferenceBtn = btnVendor; frm.TopLevel = false; frm.LoadVandors(); MainPanel.Controls.Add(frm); frm.BringToFront(); frm.Show(); }