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);
}
}