Error:Invalid parameter 7 ('@photo'): Data type 0x22 is a deprecated large object, or LOB, but is marked as output parameter. Deprecated types are not supported as output parameters. Use current large object types instead.
my code is :
procedure is :
my code is :
Code:
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();
}
}
Code:
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
Comment