my code is :
Expand|Select|Wrap|Line Numbers
- protected void cmdActivatePofile_Click(object sender, EventArgs e)
- {
- SqlConnection con = Connection.GetConnection();
- HttpPostedFile uploadedImage=null;
- byte[] imageSize=null;
- if (cmdBrowsePhoto.PostedFile != null)
- {
- imageSize = new byte[cmdBrowsePhoto.PostedFile.ContentLength];
- uploadedImage = cmdBrowsePhoto.PostedFile;
- uploadedImage.InputStream.Read(imageSize, 0, (int)cmdBrowsePhoto.PostedFile.ContentLength);
- }
- try
- {
- SqlCommand cmd = new SqlCommand("USPFacultyRegistrationInsertData");
- cmd.Parameters.Add(new SqlParameter("@Title", cmdSirName.SelectedItem.Text));
- cmd.Parameters.Add(new SqlParameter("@FirstName", cmdFirstName.Text));
- cmd.Parameters.Add(new SqlParameter("@MiddleName", cmdMiddleName.Text));
- cmd.Parameters.Add(new SqlParameter("@LastName", cmdLastName.Text));
- cmd.Parameters.Add(new SqlParameter("@Height", cmdHeight.Text));
- cmd.Parameters.Add(new SqlParameter("@Complaxion", cmdComplexion.SelectedItem.Text));
- // cmd.Parameters.Add(new SqlParameter("@photo", SqlDbType.Image, imageSize.Length));
- SqlParameter param = new SqlParameter("@photo", System.Data.SqlDbType.Image, imageSize.Length);
- param.Direction = ParameterDirection.Output;
- cmd.Parameters.Add(param);
- cmd.Parameters.Add(new SqlParameter("@MobileNo", Convert.ToInt32(cmdMobileNo.Text)));
- cmd.Parameters.Add(new SqlParameter("@EmailID", cmdEmailID.Text));
- cmd.Parameters.Add(new SqlParameter("@ResidenceContactNO", Convert.ToInt32(cmdHome.Text)));
- cmd.Parameters.Add(new SqlParameter("@OfficeContactNO", Convert.ToInt32(cmdOffice.Text)));
- cmd.Parameters.Add(new SqlParameter("@PermanentAddress", cmdPermanent.Text));
- cmd.Parameters.Add(new SqlParameter("@CorrespondanceAddress", cmdCorrrespondance.Text));
- cmd.Parameters.Add(new SqlParameter("@PassportStatus", cmdIsReady.SelectedItem.Text));
- cmd.Parameters.Add(new SqlParameter("@PassportNO", cmdPassportNo.Text));
- cmd.Parameters.Add(new SqlParameter("@PANCardStatus", cmdPANCard.SelectedItem.Text));
- cmd.Parameters.Add(new SqlParameter("@PANCardNO", cmdPanCardNo.Text));
- cmd.Parameters.Add(new SqlParameter("@LicenseStatus", cmdLicense.SelectedItem.Text));
- cmd.Parameters.Add(new SqlParameter("@LicenseNo", cmdLicenseNo.Text));
- cmd.Parameters.Add(new SqlParameter("@CountryName", cmdCountry.Text));
- cmd.Parameters.Add(new SqlParameter("@StateName", cmdState.Text));
- cmd.Parameters.Add(new SqlParameter("@CityName", cmdCity.Text));
- cmd.Parameters.Add(new SqlParameter("@ZIPCode", Convert.ToInt32(cmdZIP.Text)));
- cmd.Parameters.Add(new SqlParameter("@HighestQualification", cmdHighestQualification.Text));
- cmd.Parameters.Add(new SqlParameter("@GradeOrPercentage", cmdGradeOrPercentage.Text));
- cmd.Parameters.Add(new SqlParameter("@UniversityName", cmdUniversityName.Text));
- cmd.Parameters.Add(new SqlParameter("@PassingYear", Convert.ToInt32(cmdPassingYear.Text)));
- cmd.Parameters.Add(new SqlParameter("@CertificationYear", Convert.ToInt32(cmdCertificationYear.Text)));
- cmd.Parameters.Add(new SqlParameter("@CertificationName", cmdCertificationName.Text));
- cmd.Parameters.Add(new SqlParameter("@EduRecognitionStatus", cmdQualificationRecognition.Text));
- cmd.Parameters.Add(new SqlParameter("@EduRecognitionPurpose", cmdRecognitionQualificationPurpose.Text));
- cmd.Parameters.Add(new SqlParameter("@TotalExperience", Convert.ToDecimal(cmdTotalExperience.Text)));
- cmd.Parameters.Add(new SqlParameter("@RelevantExperience", Convert.ToDecimal(cmdRelevantExperience.Text)));
- cmd.Parameters.Add(new SqlParameter("@LastOrganization", cmdLastOrganization.Text));
- cmd.Parameters.Add(new SqlParameter("@CurrentOrganization", cmdCurrentOrganization.Text));
- cmd.Parameters.Add(new SqlParameter("@LastPosition", cmdLastPostion.Text));
- cmd.Parameters.Add(new SqlParameter("@CurrentPosition", cmdCurrentPosition.Text));
- cmd.Parameters.Add(new SqlParameter("@ProRecognitionStatus", cmdProfessionalRecognition.Text));
- cmd.Parameters.Add(new SqlParameter("@ProRecognitionPurpose", cmdRecognitionProfessionalPurpose.Text));
- cmd.Parameters.Add(new SqlParameter("@MaritalStatus", cmdMarried.SelectedItem.Text));
- cmd.Parameters.Add(new SqlParameter("@DivorcedStatus", cmdDivorced.SelectedItem.Text));
- cmd.Parameters.Add(new SqlParameter("@HusbandOrWifeName", cmdHusbandOrWifeName.Text));
- cmd.Parameters.Add(new SqlParameter("@HusbandOrWifeAge", Convert.ToInt16(cmdHusbandOrWifeAge.Text)));
- cmd.Parameters.Add(new SqlParameter("@HusbandOrWifeOccupation", cmdHusbandOrWifeOccupation.Text));
- cmd.Parameters.Add(new SqlParameter("@HusbandOrWifeDependent", cmdHusbandOrWifeDependant.SelectedItem.Text));
- cmd.Parameters.Add(new SqlParameter("@FatherName", cmdFatherName.Text));
- cmd.Parameters.Add(new SqlParameter("@FatherIsAlive", cmdIsFatherAlive.SelectedItem.Text));
- cmd.Parameters.Add(new SqlParameter("@MotherName", cmdMotherName.Text));
- cmd.Parameters.Add(new SqlParameter("@MotherIsAlive", cmdIsMotherAlive.SelectedItem.Text));
- cmd.Parameters.Add(new SqlParameter("@FacultyID", cmdFacultyID.Text));
- cmd.Parameters.Add(new SqlParameter("@Specialization", cmdFacultySubject.SelectedItem.Text));
- cmd.Parameters.Add(new SqlParameter("@AssignedPaper", cmdAssignedPaper.SelectedItem.Text));
- cmd.Parameters.Add(new SqlParameter("@AssignedPaperStatus", cmdAssignedPaperStatus.SelectedItem.Text));
- cmd.Parameters.Add(new SqlParameter("@QuestionPaperID", cmdQuestionPaperID.SelectedItem.Text));
- cmd.Parameters.Add(new SqlParameter("@QuestionPaperStatus", cmdQuestionPaperStatus.SelectedItem.Text));
- cmd.Parameters.Add(new SqlParameter("@HOD", cmdHOD.SelectedItem.Text));
- cmd.Parameters.Add(new SqlParameter("@ReportingName", cmdHODName.SelectedItem.Text));
- cmd.Parameters.Add(new SqlParameter("@Biography", cmdBiography.InnerText.Trim()));
- cmd.CommandType = CommandType.StoredProcedure;
- cmd.Connection = con;
- con.Open();
- cmd.ExecuteNonQuery();
- }
- catch (FormatException)
- {
- Response.Write("Please provide proper information !");
- }
- finally
- {
- con.Dispose();
- con.Close();
- }
- }
Expand|Select|Wrap|Line Numbers
- USE [Test]
- GO
- /****** Object: StoredProcedure [dbo].[USPFacultyRegistrationInsertData] Script Date: 02/10/2012 22:05:41 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- -- =============================================
- -- Author: <Author,,Name>
- -- Create date: <Create Date,,>
- -- Description: <Description,,>
- -- =============================================
- CREATE PROCEDURE [dbo].[USPFacultyRegistrationInsertData]
- (
- @Title nvarchar (200) ,
- @FirstName nvarchar (200) ,
- @MiddleName nvarchar (200) ,
- @LastName nvarchar (200) ,
- @Height varchar (100) ,
- @Complaxion varchar (200) ,
- @photo image,
- @MobileNo numeric (18, 0),
- @EmailID nvarchar (max),
- @ResidenceContactNO numeric (18, 0),
- @OfficeContactNO numeric (18, 0),
- @PassportStatus varchar (50),
- @PassportNO varchar (50),
- @PANCardStatus varchar (50),
- @PANCardNO varchar (50),
- @LicenseStatus varchar (50),
- @LicenseNo varchar (50),
- @PermanentAddress nvarchar (max) ,
- @CorrespondanceAddress nvarchar (max) ,
- @CountryName nvarchar (max) ,
- @StateName nvarchar (max) ,
- @CityName nvarchar (max) ,
- @ZIPCode int,
- @HighestQualification nvarchar(max) ,
- @GradeOrPercentage nvarchar (max) ,
- @UniversityName nvarchar (max) ,
- @PassingYear int,
- @CertificationYear int,
- @CertificationName nvarchar(max),
- @EduRecognitionStatus varchar(50),
- @EduRecognitionPurpose nvarchar(max),
- @TotalExperience float,
- @RelevantExperience float,
- @LastOrganization varchar(200),
- @CurrentOrganization varchar(200),
- @LastPosition varchar(200),
- @CurrentPosition varchar(200),
- @ProRecognitionStatus varchar(50),
- @ProRecognitionPurpose nvarchar(max),
- @MaritalStatus varchar(50),
- @DivorcedStatus varchar(50),
- @HusbandOrWifeName nvarchar(max),
- @HusbandOrWifeAge int,
- @HusbandOrWifeOccupation varchar(max),
- @HusbandOrWifeDependent varchar(max),
- @FatherName nvarchar(max),
- @FatherIsAlive varchar(50),
- @MotherName nvarchar(max),
- @MotherIsAlive varchar(50),
- @FacultyID varchar(200),
- @Specialization nvarchar(200),
- @AssignedPaper nvarchar(200),
- @AssignedPaperStatus varchar(200),
- @QuestionPaperID nvarchar(200),
- @QuestionPaperStatus varchar(200),
- @HOD nvarchar(max),
- @ReportingName nvarchar(200),
- @Biography nvarchar(max)
- )
- AS
- BEGIN
- -- SET NOCOUNT ON added to prevent extra result sets from
- -- interfering with SELECT statements.
- SET NOCOUNT ON;
- -- Insert statements for procedure here
- INSERT INTO [dbo].[FacultyMaster]
- (
- [Title],
- [FirstName],
- [MiddleName],
- [LastName],
- [Height] ,
- [Complaxion],
- [photo],
- [MobileNo] ,
- [EmailID] ,
- [ResidenceContactNO],
- [OfficeContactNO] ,
- [PermanentAddress],
- [CorrespondanceAddress],
- [PassportStatus],
- [PassportNO],
- [PANCardStatus],
- [PANCardNO],
- [LicenseStatus],
- [LicenseNo],
- [CountryName],
- [StateName] ,
- [CityName] ,
- [ZIPCode] ,
- [HighestQualification] ,
- [GradeOrPercentage] ,
- [UniversityName] ,
- [PassingYear] ,
- [CertificationYear],
- [CertificationName],
- [EduRecognitionStatus],
- [EduRecognitionPurpose] ,
- [TotalExperience] ,
- [RelevantExperience],
- [LastOrganization] ,
- [CurrentOrganization],
- [LastPosition] ,
- [CurrentPosition],
- [ProRecognitionStatus],
- [ProRecognitionPurpose],
- [MaritalStatus] ,
- [DivorcedStatus],
- [HusbandOrWifeName],
- [HusbandOrWifeAge],
- [HusbandOrWifeOccupation],
- [HusbandOrWifeDependent],
- [FatherName],
- [FatherIsAlive],
- [MotherName] ,
- [MotherIsAlive],
- [FacultyID] ,
- [Specialization],
- [AssignedPaper] ,
- [AssignedPaperStatus],
- [QuestionPaperID] ,
- [QuestionPaperStatus],
- [HOD] ,
- [ReportingName],
- [Biography] ,
- [RegistrationDate]
- )
- VALUES
- (
- @Title,
- @FirstName,
- @MiddleName,
- @LastName,
- @Height ,
- @Complaxion,
- @photo,
- @MobileNo ,
- @EmailID ,
- @ResidenceContactNO,
- @OfficeContactNO ,
- @PermanentAddress,
- @CorrespondanceAddress,
- @PassportStatus,
- @PassportNO,
- @PANCardStatus,
- @PANCardNO,
- @LicenseStatus,
- @LicenseNo,
- @CountryName,
- @StateName,
- @CityName,
- @ZIPCode ,
- @HighestQualification ,
- @GradeOrPercentage ,
- @UniversityName ,
- @PassingYear ,
- @CertificationYear,
- @CertificationName,
- @EduRecognitionStatus,
- @EduRecognitionPurpose ,
- @TotalExperience ,
- @RelevantExperience,
- @LastOrganization ,
- @CurrentOrganization,
- @LastPosition ,
- @CurrentPosition,
- @ProRecognitionStatus,
- @ProRecognitionPurpose,
- @MaritalStatus ,
- @DivorcedStatus,
- @HusbandOrWifeName,
- @HusbandOrWifeAge,
- @HusbandOrWifeOccupation,
- @HusbandOrWifeDependent,
- @FatherName,
- @FatherIsAlive,
- @MotherName ,
- @MotherIsAlive,
- @FacultyID ,
- @Specialization,
- @AssignedPaper ,
- @AssignedPaperStatus,
- @QuestionPaperID ,
- @QuestionPaperStatus,
- @HOD ,
- @ReportingName,
- @Biography ,
- getdate()
- )
- END