private void Delete_Click_1(object sender, EventArgs e) { try { int RowsAffected = 0; cmd = new OleDbCommand("DELETE FROM Student WHERE S_ID LIKE'" + S_ID.Text + "'", con); RowsAffected = cmd.ExecuteNonQuery(); if (RowsAffected > 0) { MessageBox.Show("Successfully Deleted", "Record", MessageBoxButtons.OK, MessageBoxIcon.Information); S_ID.Refresh(); Delete.Enabled = false; AddNew.Enabled = true; Reset(); } else { MessageBox.Show("No Record found", "Sorry", MessageBoxButtons.OK, MessageBoxIcon.Information); Reset(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void CmdUpdate_Click(object sender, EventArgs e) { try { string str; string A; str = "UPDATE [Student] SET [S_ID]=@S_ID,[Add_No]=@Add_No,[Add_Date]=@Add_Date,[Add_Form_No]=@Add_Form_No,[C_Name]=@C_Name,[C_Sem]=@C_Sem,"; str = str + "[Batch]=@Batch,[S_FName]=@S_FName,[S_LName]=@S_LName,[DOB]=@DOB,[Religion]=@Religion,[Category]=@Category,"; str = str + "[BGroup]=@BGroup,[Nationality]=@Nationality,[BPlace]=@BPlace,[M_Tongue]=@M_Tongue,[Gen]=@Gen,[PIC]=@PIC,"; str = str + "[FName]=@FName,[FOccupation]=@FOccupation,[FContact]=@FContact,[FEmail]=@FEmail,[MName]=@MName,[MOccupation]=@MOccupation,"; str = str + "[MContact]=@MContact,[MEmail]=@MEmail,[Contact_No]=@Contact_No,[Mobile_No]=@Mobile_No,[EMail]=@EMail,[H_No1]=@H_No1,"; str = str + "[Street1]=@Street1,[City1]=@City1,[Pin1]=@Pin1,[State1]=@State1,[H_No2]=@H_No2,[Street2]=@Street2,[City2]=@City2,[Pin2]=@Pin2,[State2]=@State2,"; str = str + "[B_10]=@B_10,[P_10]=@P_10,[Y_10]=@Y_10,[B_12]=@B_12,[P_12]=@P_12,[Y_12]=@Y_12,[B_UG]=@B_UG,[P_UG]=@P_UG,[Y_UG]=@Y_UG,[B_PG]=@B_PG,[P_PG]=@P_PG,[Y_PG]=@Y_PG WHERE [S_ID]=@S_ID"; cmd = new OleDbCommand(str, con); cmd.CommandText = str; cmd.Connection = con; A = MessageBox.Show("Are You Sure", "ALERT", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString(); if (A == "Yes") { cmd.Parameters.AddWithValue("S_ID", S_ID.Text); cmd.Parameters.AddWithValue("@Add_No", EN_No.Text); cmd.Parameters.AddWithValue("@Add_Date", DOJ.Text); cmd.Parameters.AddWithValue("@Add_Form_No", TxtAddFNo.Text); cmd.Parameters.AddWithValue("@C_Name", C_Name.Text); cmd.Parameters.AddWithValue("@C_Sem", C_Sem.Text); cmd.Parameters.AddWithValue("@Batch", Batch.Text); cmd.Parameters.AddWithValue("@S_FName", S_FName.Text); cmd.Parameters.AddWithValue("@S_LName", S_LName.Text); cmd.Parameters.AddWithValue("@DOB", DOB.Text); cmd.Parameters.AddWithValue("@Religion", CmbReligion.Text); cmd.Parameters.AddWithValue("@Category", CmbCategory.Text); cmd.Parameters.AddWithValue("@BGroup", CmbBGroup.Text); cmd.Parameters.AddWithValue("@Nationality", CmbNationality.Text); cmd.Parameters.AddWithValue("@BPlace", txtBirthPlace.Text); cmd.Parameters.AddWithValue("M_Tongue", TxtMotherTongue.Text); cmd.Parameters.AddWithValue("@Gen", CmbGender.Text); MemoryStream ms = new MemoryStream(); PIC.Image.Save(ms, ImageFormat.Jpeg); byte[] fromControl = ms.GetBuffer(); cmd.Parameters.AddWithValue("@PIC", fromControl); cmd.Parameters.AddWithValue("@FName", Father.Text); cmd.Parameters.AddWithValue("@FOccupation", FOccupation.Text); cmd.Parameters.AddWithValue("@FContact", MtxtFContact.Text); cmd.Parameters.AddWithValue("@FEmail", txtFEmail.Text); cmd.Parameters.AddWithValue("@MName", Mother.Text); cmd.Parameters.AddWithValue("@MOccupation", MOccupation.Text); cmd.Parameters.AddWithValue("@MContact", MtxtMContact.Text); cmd.Parameters.AddWithValue("@MEmail", txtMEmail.Text); cmd.Parameters.AddWithValue("@Contact_No", Contact.Text); cmd.Parameters.AddWithValue("@Mobile_No", Mobile.Text); cmd.Parameters.AddWithValue("@EMail", Email.Text); cmd.Parameters.AddWithValue("@H_No1", Address1.Text); cmd.Parameters.AddWithValue("@Street1", Address2.Text); cmd.Parameters.AddWithValue("@City1", City.Text); cmd.Parameters.AddWithValue("@Pin1", PIN.Text); cmd.Parameters.AddWithValue("@State1", State.Text); cmd.Parameters.AddWithValue("@H_No2", P_Address1.Text); cmd.Parameters.AddWithValue("@Street2", P_Address2.Text); cmd.Parameters.AddWithValue("@City2", P_City.Text); cmd.Parameters.AddWithValue("@Pin2", P_PIN.Text); cmd.Parameters.AddWithValue("@State2", P_State.Text); cmd.Parameters.AddWithValue("@B_10", cmb10.Text); cmd.Parameters.AddWithValue("@P_10", Mtxt10.Text); cmd.Parameters.AddWithValue("@Y_10", Cmb10Year.Text); cmd.Parameters.AddWithValue("@B_12", cmb12.Text); cmd.Parameters.AddWithValue("@P_12", Mtxt12.Text); cmd.Parameters.AddWithValue("@Y_12", Cmb12Year.Text); cmd.Parameters.AddWithValue("@B_UG", cmbUG.Text); cmd.Parameters.AddWithValue("@P_UG", MtxtUG.Text); cmd.Parameters.AddWithValue("@Y_UG", CmbUGYear.Text); cmd.Parameters.AddWithValue("@B_PG", cmbPG.Text); cmd.Parameters.AddWithValue("@P_PG", MtxtPG.Text); cmd.Parameters.AddWithValue("@Y_PG", CmbPGYear.Text); cmd.ExecuteNonQuery(); MessageBox.Show("DataBase UpDated Successfully...", "DataBase Information", MessageBoxButtons.OK, MessageBoxIcon.Information); Reset(); S_ID.Refresh(); CmdUpdate.Enabled = false; AddNew.Enabled = true; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }