private void toolStripButton5_Click(object sender, EventArgs e) { if (SearchV == null) { SearchV = new SearchVendor(); SearchV.MdiParent = this; SearchV.FormClosed += new FormClosedEventHandler(SearchV_FormClosed); SearchV.Show(); //this.Close(); } else { SearchV.Activate(); } }
private void button1_Click(object sender, EventArgs e) { if (vendorIDtxt.Text != "" && phonetxt.Text != "" && addresstxt.Text != "" && citytxt.Text != "" && countrytxt.Text != "" && phonetxt.Text != "" && companytxt.Text != "" && typetxt.Text != "" && titletxt.Text != "" && firstnametxt.Text != "" && surnametxt.Text != "" && emailtxt.Text != "") { int v; if (Int32.TryParse(phonetxt.Text.Trim(), out v)) { con.Open(); string query = "INSERT TBL_VENDOR VALUES (" + vendorIDtxt.Text.Trim() + ", " + phonetxt.Text.Trim() + ", '" + addresstxt.Text.Trim() + "' , '" + companytxt.Text.Trim() + "' , '" + typetxt.Text.Trim() + "', '" + countrytxt.Text.Trim() + "',' " + citytxt.Text.Trim() + "', '" + titletxt.Text.Trim() + "', '" + firstnametxt.Text.Trim() + "', '" + surnametxt.Text.Trim() + "', '" + emailtxt.Text.Trim() + "') ;"; SqlCommand cmd = new SqlCommand(query, con); cmd.ExecuteNonQuery(); con.Close(); MessageBox.Show("New Vendor has been added!"); this.Close(); if (SV == null) { SV = new SearchVendor(); SV.MdiParent = this.MdiParent; SV.FormClosed += new FormClosedEventHandler(SV_FormClosed); SV.Show(); //this.Close(); } else { SV.Activate(); SV.FormClosed += new FormClosedEventHandler(SV_FormClosed); SV.Show(); } this.Close(); } else { MessageBox.Show("Not appropriate values entered."); } } else { MessageBox.Show("Not all fields filled."); } }