private void btnSave_Click(object sender, EventArgs e)
{
myad.InsertCommand = new SqlCommand("INSERT INTO EMP_PERS" +
"(EMP_CODE,EMP_FNAME,EMP_MNAME,EMP_LNAME,PRE_ADDR,PRE_CITY,PRE_STATE,PER_ADDR,PER_CITY,PER_STATE,QUALIFICATION,D_O_B,AGE,MARITAL_STATUS,CONTACT_R,CONTACT_M,GENDER,PRE_EXPR,BLOOD_GRP,EMAIL_ID) VALUES" +
"(@EMP_CODE,@EMP_FNAME,@EMP_MNAME,@EMP_LNAME,@PRE_ADDR,@PRE_CITY,@PRE_STATE,@PER_ADDR,@PER_CITY,@PER_STATE,@QUALIFICATION,@D_O_B,@AGE,@MARITAL_STATUS,@CONTACT_R,@CONTACT_M,@GENDER,@PRE_EXPR,@BLOOD_GRP,@EMAIL_ID)", mycon);
SqlParameter myparm = null;
myparm = myad.InsertCommand.Parameters.Add(new SqlParameter("@EMP_CODE", SqlDbType.NVarChar));
myparm.SourceColumn = "EMP_CODE";
myparm.SourceVersion = DataRowVersion.Current;
myparm = myad.InsertCommand.Parameters.Add(new SqlParameter("@EMP_FNAME", SqlDbType.NVarChar));
myparm.SourceColumn = "EMP_FNAME";
myparm.SourceVersion = DataRowVersion.Current;
myparm = myad.InsertCommand.Parameters.Add(new SqlParameter("@EMP_MNAME", SqlDbType.NVarChar));
myparm.SourceColumn = "EMP_MNAME";
myparm.SourceVersion = DataRowVersion.Current;
myparm = myad.InsertCommand.Parameters.Add(new SqlParameter("@EMP_LNAME", SqlDbType.NVarChar));
myparm.SourceColumn = "EMP_LNAME";
myparm.SourceVersion = DataRowVersion.Current;
myparm = myad.InsertCommand.Parameters.Add(new SqlParameter("@PRE_ADDR", SqlDbType.NVarChar));
myparm.SourceColumn = "PRE_ADDR";
myparm.SourceVersion = DataRowVersion.Current;
myparm = myad.InsertCommand.Parameters.Add(new SqlParameter("@PRE_CITY", SqlDbType.NVarChar));
myparm.SourceColumn = "PRE_CITY";
myparm.SourceVersion = DataRowVersion.Current;
myparm = myad.InsertCommand.Parameters.Add(new SqlParameter("@PRE_STATE", SqlDbType.NVarChar));
myparm.SourceColumn = "PRE_STATE";
myparm.SourceVersion = DataRowVersion.Current;
myparm = myad.InsertCommand.Parameters.Add(new SqlParameter("@PER_ADDR", SqlDbType.NVarChar));
myparm.SourceColumn = "PER_ADDR";
myparm.SourceVersion = DataRowVersion.Current;
myparm = myad.InsertCommand.Parameters.Add(new SqlParameter("@PER_CITY", SqlDbType.NVarChar));
myparm.SourceColumn = "PER_CITY";
myparm.SourceVersion = DataRowVersion.Current;
myparm = myad.InsertCommand.Parameters.Add(new SqlParameter("@PER_STATE", SqlDbType.NVarChar));
myparm.SourceColumn = "PER_STATE";
myparm.SourceVersion = DataRowVersion.Current;
myparm = myad.InsertCommand.Parameters.Add(new SqlParameter("@QUALIFICATION", SqlDbType.NVarChar));
myparm.SourceColumn = "QUALIFICATION";
myparm.SourceVersion = DataRowVersion.Current;
myparm = myad.InsertCommand.Parameters.Add(new SqlParameter("@D_O_B", SqlDbType.DateTime));
myparm.SourceColumn = "D_O_B";
myparm.SourceVersion = DataRowVersion.Current;
myparm = myad.InsertCommand.Parameters.Add(new SqlParameter("@AGE", SqlDbType.Int));
myparm.SourceColumn = "AGE";
myparm.SourceVersion = DataRowVersion.Current;
myparm = myad.InsertCommand.Parameters.Add(new SqlParameter("@MARITAL_STATUS", SqlDbType.NVarChar));
myparm.SourceColumn = "MARITAL_STATUS";
myparm.SourceVersion = DataRowVersion.Current;
myparm = myad.InsertCommand.Parameters.Add(new SqlParameter("@CONTACT_R", SqlDbType.Int));
myparm.SourceColumn = "CONTACT_R";
myparm.SourceVersion = DataRowVersion.Current;
myparm = myad.InsertCommand.Parameters.Add(new SqlParameter("@CONTACT_M", SqlDbType.Int));
myparm.SourceColumn = "CONTACT_M";
myparm.SourceVersion = DataRowVersion.Current;
myparm = myad.InsertCommand.Parameters.Add(new SqlParameter("@GENDER", SqlDbType.NVarChar));
myparm.SourceColumn = "GENDER";
myparm.SourceVersion = DataRowVersion.Current;
myparm = myad.InsertCommand.Parameters.Add(new SqlParameter("@PRE_EXPR", SqlDbType.Int));
myparm.SourceColumn = "PRE_EXPR";
myparm.SourceVersion = DataRowVersion.Current;
myparm = myad.InsertCommand.Parameters.Add(new SqlParameter("@BLOOD_GRP", SqlDbType.NVarChar));
myparm.SourceColumn = "BLOOD_GRP";
myparm.SourceVersion = DataRowVersion.Current;
myparm = myad.InsertCommand.Parameters.Add(new SqlParameter("@EMAIL_ID", SqlDbType.NVarChar));
myparm.SourceColumn = "EMAIL_ID";
myparm.SourceVersion = DataRowVersion.Current;
DataSet myDS = new DataSet();
myad.SelectCommand = new SqlCommand("select * from EMP_PERS",mycon);
myad.Fill(myDS, "EMP_PERS");
DataRow newRow = myDS.Tables["EMP_PERS"].NewRow();
newRow[0] = this.txtEID.Text;
newRow[1] = this.txt_Fname.Text;
newRow[2] = this.txt_Mname.Text;
newRow[3] = this.txt_Lname.Text;
newRow[4] = this.txtP_Add.Text;
newRow[5] = this.txtP_City.Text;
newRow[6] = this.txtP_State.Text;
newRow[7] = this.txtP_PerAdd.Text;
newRow[8] = this.txtP_PerCity.Text;
newRow[9] = this.txtP_PerState.Text;
newRow[10] = "";
try
{
newRow[11] = this.txtDOB.Text;
}
catch (SqlException sx2)
{
MessageBox.Show(sx2.Message, "SQL EXCEPTION OF DATE !");
}
catch (Exception ex1)
{
MessageBox.Show(ex1.Message, "OTHER EXCEPTION OF DATE !");
}
newRow[12] = int.Parse(this.lblP_Age.Text);//age;//this.txtp_age;
newRow[13] = this.cmbMst.Text;
newRow[14] = int.Parse(this.txtP_Phr.Text);
newRow[15] = int.Parse(this.txtP_Phm.Text);
newRow[16] = this.cmbGender.Text;
newRow[17] = int.Parse(this.txtP_PExpr.Text);
newRow[18] = this.cmbP_Bg.Text;
newRow[19] = this.txtP_Mailid.Text + "@" + comboBox1.Text;
try
{
myDS.Tables["EMP_PERS"].Rows.Add(newRow);
}
catch (SqlAlreadyFilledException sx)
{
MessageBox.Show(sx.Message, "SQL ERROR ALREADY FILLED!");
}
catch (SqlException sx1)
{
MessageBox.Show(sx1.Message, "SQL EXCEPTION ON INSERT !");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "INSERT ERROR ON INSERT !!");
}
finally
{
myad.Update(myDS, "EMP_PERS");
MessageBox.Show("NEW DATA IS INSERTED !!", "INSERT COMMAND");
}
clearFields();
}
private void clearFields()
{
this.txtEID.Text = "";
}