util.ClearParam()
util.AddParam("@NameOfSchool", ddlSchName.SelectedItem.Text)
util.AddParam("@FName", txtF_Name.Text)
util.AddParam("@MName", txtM_Name.Text)
util.AddParam("@LName", txtL_Name.Text)
util.AddParam("@DOB", skdatefc(txtDob.Text))
util.AddParam("@Gender", ddlGender.SelectedItem.Value)
util.AddParam("@Catagory", ddlCategory.SelectedItem.Value)
util.AddParam("@MaritalStatus", ddlMarriedStatus.SelectedItem.Value)
util.AddParam("@FatherName", txtF_H_Name.Text)
util.AddParam("@ResidentialAddress", txtC_Add1.Text)
util.AddParam("@CityR", txtC_City.Text)
util.AddParam("@StateR", txtC_State.Text)
util.AddParam("@PhoneR", txtCPhone.Text)
util.AddParam("@PermanentAddress", txtP_Add1.Text)
util.AddParam("@CityP", txtP_City.Text)
util.AddParam("@StateP", txtP_State.Text)
util.AddParam("@PhoneP", txtPPhone.Text)
util.AddParam("@EmailID", txtC_Email.Text)
util.AddParam("@Currentpost", ddlInitialPost.SelectedItem.Value)
util.AddParam("@CurrentpostingTrade", ddlSubjectToTeach.SelectedItem.Value)
util.AddParam("@StreamNameAppointment", txtInitialSelOrderNo.Text)
util.AddParam("@InitialAppointmentNo", txtInitialAppOrderNo.Text)
util.AddParam("@DateofAppointment", txtInitialAppDate.Text)
util.AddParam("@QualificationGraduation", ddlH_Qualif.SelectedItem.Value)
util.AddParam("@GraduationSubject1", ddlSub1.SelectedItem.Value)
util.AddParam("@GraduationSubject2", ddlSub2.SelectedItem.Value)
util.AddParam("@GraduationSubject3", ddlSub3.SelectedItem.Value)
util.AddParam("@OtherSubjectG", txtothersubjectG.Text)
util.AddParam("@SpecializationG", txtspecial.Text)
util.AddParam("@QualificationPostGraduation", ddlPG_Qualif.SelectedItem.Value)
util.AddParam("@PostGraduationSubject1", ddlps1.SelectedItem.Value)
util.AddParam("@PostGraduationSubject2", ddlps2.SelectedItem.Value)
util.AddParam("@PostGraduationSubject3", ddlps3.SelectedItem.Value)
util.AddParam("@OtherSubjectP", txtothersubp.Text)
util.AddParam("@SpecializationP", txtspp.Text)
util.AddParam("@Certificatecourse", txtcc.Text)
util.AddParam("@Diploma", dpldiploma.SelectedItem.Value)
util.AddParam("@BachlorDgree", dplbachlor.SelectedItem.Value)
util.AddParam("@ProfessionalQualification", ddlProff_Qualif.SelectedItem.Value)
util.AddParam("@OtherQualification", txtOthers.Text)
util.AddParam("@Achievement", txtAchieve.Text)
util.AddParam("@CurrentSchoolID", txtCurrentSchool.Text)
util.AddParam("@DOJCurrentSchool", txtCurrentSchoolDate.Text)
util.AddParam("@Renumeration", txtrenumeration.Text)
util.AddParam("@IsEmployeeQualified", ddlEmployeeQualified.SelectedItem.Value)
util.AddParam("@QualificationAcquiredthroughFragmentalcourse", ddlqafragmental.SelectedItem.Value)
util.AddParam("@FragmentalCourse", txtfragmentalcourse.Text)
util.AddParam("@PeriodFrom", skdatefc(txtfrom.Text))
util.AddParam("@PeriodTo", skdatefc(txtto.Text))
util.AddParam("@SignatoryName", txtSignatoryName.Text)
util.AddParam("@SignatoryDesignation", txtSignatoryDesignation.Text)
util.AddOutputParam("@VCID", SqlDbType.Int)
k = util.executeStoredProc("usptblVocationalTeacher1415")
If k > 0 Then
Response.Write("<font color=blue>Record Submitted</font>")
Else
Response.Write("<font color=red>Record not Submitted</font>")
End If
'Response.Write("<script language=javascript>alert('Record Submitted Successfully');</script>")
End Sub