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 Save_Click_1(object sender, EventArgs e)
{
string str;
try
{
Verification();
str = "INSERT INTO Student(S_ID,Add_No,Add_Date,Add_Form_No,C_Name,C_Sem,Batch,S_FName,";
str = str + "S_LName,DOB,Religion,Category,BGroup,Nationality,BPlace,M_Tongue,Gen,PIC,";
str = str + "FName,FOccupation,FContact,FEmail,MName,MOccupation,MContact,MEmail,Contact_No,";
str = str + "Mobile_No,EMail,H_No1,Street1,City1,Pin1,State1,H_No2,Street2,City2,Pin2,State2,";
str = str + "B_10,P_10,Y_10,B_12,P_12,Y_12,B_UG,P_UG,Y_UG,B_PG,P_PG,Y_PG)";
str = str + "VALUES(@S_ID,@Add_No,@Add_Date,@Add_Form_No,@C_Name,@C_Sem,@Batch,@S_FName,";
str = str + "@S_LName,@DOB,@Religion,@Category,@BGroup,@Nationality,@BPlace,M_Tongue,@Gen,@PIC,";
str = str + "@FName,@FOccupation,@FContact,@FEmail,@MName,@MOccupation,@MContact,@MEmail,@Contact_No,";
str = str + "@Mobile_No,@EMail,@H_No1,@Street1,@City1,@Pin1,@State1,@H_No2,@Street2,@City2,@Pin2,@State2,";
str = str + "@B_10,@P_10,@Y_10,@B_12,@P_12,@Y_12,@B_UG,@P_UG,@Y_UG,@B_PG,@P_PG,@Y_PG)";
cmd = new OleDbCommand(str, con);
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("Successfully Registered...", "Congratulation", MessageBoxButtons.OK, MessageBoxIcon.Information);
Reset();
S_ID.Enabled = true;
S_ID.Update();
Save.Enabled = false;
AddNew.Enabled = true;
Search.Enabled = true;
C_Name.Items.Clear();
C_Sem.Items.Clear();
Batch.Items.Clear();
CmbCategory.Items.Clear();
FOccupation.Items.Clear();
MOccupation.Items.Clear();
cmb10.Items.Clear();
cmb12.Items.Clear();
cmbUG.Items.Clear();
cmbPG.Items.Clear();
}
catch (Exception e1)
{
MessageBox.Show(e1.Message);
}
}
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);
}
}
