private void UPDATE_Click(object sender, EventArgs e) { if (Tele_No.Text == "" || Mob_No.Text == "" || Fax_No.Text == "" || E_ID.Text == "" || A_E_ID.Text == "") { MessageBox.Show("PLZ_FILL_RECOMMENDED_DATA__!!"); } else { con.Open(); SqlDataAdapter sda = new SqlDataAdapter("UPDATE PARTY SET Party_Name='" + Party_Name.Text + "',Head_Office='" + H_O.Text + "',State='" + City.Text + "',City='" + State.Text + "',Post_Code='" + Postcode.Text + "',Telephone_No='" + Tele_No.Text + "',Mobile_No='" + Mob_No + "',Fax_No='" + Fax_No.Text + "',Email_ID='" + E_ID.Text + "',Alternative_Email_ID='" + A_E_ID.Text + "',Website='" + Website.Text + "' WHERE Party_ID='" + Party_ID.Text + "'", con); sda.SelectCommand.ExecuteNonQuery(); con.Close(); Party_ID.Text = ""; Party_Name.Text = ""; H_O.Text = ""; City.Text = ""; State.Text = ""; Postcode.Text = ""; Tele_No.Text = ""; Mob_No.Text = ""; Fax_No.Text = ""; E_ID.Text = ""; A_E_ID.Text = ""; Website.Text = ""; Party_ID.Focus(); MessageBox.Show("UPDATED SUCCESSFULLY!!!"); } }
private void SAVE_Click(object sender, EventArgs e) { if (Party_ID.Text == "" || Party_Name.Text == "" || H_O.Text == "" || State.Text == "" || City.Text == "" || Post_Code.Text == "" || Tele_No.Text == "" || Mob_No.Text == "" || Fax_No.Text == "" || E_ID.Text == "" || A_E_ID.Text == "" || Website.Text == "" || Date.Text == "") { MessageBox.Show("PLEASE_FILL_ALL_FIELDS__!!"); } else { con.Open(); SqlDataAdapter sda = new SqlDataAdapter("INSERT INTO PARTY (Party_ID,Party_Name,Head_Office,State,City,Post_Code,Telephone_No,Mobile_No,Fax_No,Email_ID,Alternative_Email_ID,Website)VALUES('" + Party_ID.Text + "','" + Party_Name.Text + "','" + H_O.Text + "','" + State.Text + "','" + City.Text + "','" + Post_Code.Text + "','" + Tele_No.Text + "','" + Mob_No.Text + "','" + Fax_No.Text + "','" + E_ID.Text + "','" + A_E_ID.Text + "','" + Website.Text + "')", con); sda.SelectCommand.ExecuteNonQuery(); con.Close(); Party_ID.Text = ""; Party_Name.Text = ""; H_O.Text = ""; State.Text = ""; City.Text = ""; Post_Code.Text = ""; Tele_No.Text = ""; Mob_No.Text = ""; Fax_No.Text = ""; E_ID.Text = ""; A_E_ID.Text = ""; Website.Text = ""; Party_ID.Focus(); MessageBox.Show("SAVE SUCCESSFULLY!!!"); Add_Party_Details ds = new Add_Party_Details(); this.Dispose(false); ds.Show(); } }
private void CLEAR_Click(object sender, EventArgs e) { Party_ID.Text = ""; Party_Name.Text = ""; Party_ID.Focus(); MessageBox.Show("ALL_DATA_CLEARED__!!"); }
private void CLEAR_Click(object sender, EventArgs e) { Party_ID.Text = ""; Party_Name.Text = ""; H_O.Text = ""; City.Text = ""; State.Text = ""; Postcode.Text = ""; Tele_No.Text = ""; Mob_No.Text = ""; Fax_No.Text = ""; E_ID.Text = ""; A_E_ID.Text = ""; Website.Text = ""; Party_ID.Focus(); }
private void DELETE_Click(object sender, EventArgs e) { if (Party_ID.Text == "" || Party_Name.Text == "") { MessageBox.Show("PLEASE_FILL_ALL_RECOMMENDED_DATA_FIRST_!!"); } else { con.Open(); SqlCommand scd = new SqlCommand("DELETE FROM PARTY WHERE Party_ID='" + Party_ID.Text + "' and Party_Name='" + Party_Name.Text + "'", con); scd.ExecuteNonQuery(); con.Close(); Party_ID.Text = ""; Party_Name.Text = ""; Party_ID.Focus(); MessageBox.Show("DATA_DELETED_SUCCESSFULLY__!!"); } }
private void CLEAR_Click(object sender, EventArgs e) { //Party_ID.Text = ""; Party_Name.Text = ""; H_O.Text = ""; State.Text = ""; City.Text = ""; Post_Code.Text = ""; Tele_No.Text = ""; Mob_No.Text = ""; Fax_No.Text = ""; E_ID.Text = ""; A_E_ID.Text = ""; Website.Text = ""; Party_ID.Focus(); MessageBox.Show("ALL_CLEARED__"); }