473,387 Members | 1,516 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

inserting browsed image to database

16
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 :
Expand|Select|Wrap|Line Numbers
  1.  protected void cmdActivatePofile_Click(object sender, EventArgs e)
  2.         {
  3.             SqlConnection con = Connection.GetConnection();
  4.             HttpPostedFile uploadedImage=null;
  5.             byte[] imageSize=null;
  6.             if (cmdBrowsePhoto.PostedFile != null)
  7.             {
  8.                 imageSize = new byte[cmdBrowsePhoto.PostedFile.ContentLength];
  9.                 uploadedImage = cmdBrowsePhoto.PostedFile;
  10.                 uploadedImage.InputStream.Read(imageSize, 0, (int)cmdBrowsePhoto.PostedFile.ContentLength);
  11.             }
  12.  
  13.  
  14.             try
  15.             {
  16.                 SqlCommand cmd = new SqlCommand("USPFacultyRegistrationInsertData");
  17.                 cmd.Parameters.Add(new SqlParameter("@Title", cmdSirName.SelectedItem.Text));
  18.                 cmd.Parameters.Add(new SqlParameter("@FirstName", cmdFirstName.Text));
  19.                 cmd.Parameters.Add(new SqlParameter("@MiddleName", cmdMiddleName.Text));
  20.                 cmd.Parameters.Add(new SqlParameter("@LastName", cmdLastName.Text));
  21.                 cmd.Parameters.Add(new SqlParameter("@Height", cmdHeight.Text));
  22.                 cmd.Parameters.Add(new SqlParameter("@Complaxion", cmdComplexion.SelectedItem.Text));
  23.                // cmd.Parameters.Add(new SqlParameter("@photo", SqlDbType.Image, imageSize.Length));
  24.                 SqlParameter param = new SqlParameter("@photo", System.Data.SqlDbType.Image, imageSize.Length);
  25.                 param.Direction = ParameterDirection.Output;
  26.                 cmd.Parameters.Add(param);
  27.                 cmd.Parameters.Add(new SqlParameter("@MobileNo", Convert.ToInt32(cmdMobileNo.Text)));
  28.                 cmd.Parameters.Add(new SqlParameter("@EmailID", cmdEmailID.Text));
  29.                 cmd.Parameters.Add(new SqlParameter("@ResidenceContactNO", Convert.ToInt32(cmdHome.Text)));
  30.                 cmd.Parameters.Add(new SqlParameter("@OfficeContactNO", Convert.ToInt32(cmdOffice.Text)));
  31.                 cmd.Parameters.Add(new SqlParameter("@PermanentAddress", cmdPermanent.Text));
  32.                 cmd.Parameters.Add(new SqlParameter("@CorrespondanceAddress", cmdCorrrespondance.Text));
  33.                 cmd.Parameters.Add(new SqlParameter("@PassportStatus", cmdIsReady.SelectedItem.Text));
  34.                 cmd.Parameters.Add(new SqlParameter("@PassportNO", cmdPassportNo.Text));
  35.                 cmd.Parameters.Add(new SqlParameter("@PANCardStatus", cmdPANCard.SelectedItem.Text));
  36.                 cmd.Parameters.Add(new SqlParameter("@PANCardNO", cmdPanCardNo.Text));
  37.                 cmd.Parameters.Add(new SqlParameter("@LicenseStatus", cmdLicense.SelectedItem.Text));
  38.                 cmd.Parameters.Add(new SqlParameter("@LicenseNo", cmdLicenseNo.Text));
  39.                 cmd.Parameters.Add(new SqlParameter("@CountryName", cmdCountry.Text));
  40.                 cmd.Parameters.Add(new SqlParameter("@StateName", cmdState.Text));
  41.                 cmd.Parameters.Add(new SqlParameter("@CityName", cmdCity.Text));
  42.                 cmd.Parameters.Add(new SqlParameter("@ZIPCode", Convert.ToInt32(cmdZIP.Text)));
  43.                 cmd.Parameters.Add(new SqlParameter("@HighestQualification", cmdHighestQualification.Text));
  44.                 cmd.Parameters.Add(new SqlParameter("@GradeOrPercentage", cmdGradeOrPercentage.Text));
  45.                 cmd.Parameters.Add(new SqlParameter("@UniversityName", cmdUniversityName.Text));
  46.                 cmd.Parameters.Add(new SqlParameter("@PassingYear", Convert.ToInt32(cmdPassingYear.Text)));
  47.                 cmd.Parameters.Add(new SqlParameter("@CertificationYear", Convert.ToInt32(cmdCertificationYear.Text)));
  48.                 cmd.Parameters.Add(new SqlParameter("@CertificationName", cmdCertificationName.Text));
  49.                 cmd.Parameters.Add(new SqlParameter("@EduRecognitionStatus", cmdQualificationRecognition.Text));
  50.                 cmd.Parameters.Add(new SqlParameter("@EduRecognitionPurpose", cmdRecognitionQualificationPurpose.Text));
  51.                 cmd.Parameters.Add(new SqlParameter("@TotalExperience", Convert.ToDecimal(cmdTotalExperience.Text)));
  52.                 cmd.Parameters.Add(new SqlParameter("@RelevantExperience", Convert.ToDecimal(cmdRelevantExperience.Text)));
  53.                 cmd.Parameters.Add(new SqlParameter("@LastOrganization", cmdLastOrganization.Text));
  54.                 cmd.Parameters.Add(new SqlParameter("@CurrentOrganization", cmdCurrentOrganization.Text));
  55.                 cmd.Parameters.Add(new SqlParameter("@LastPosition", cmdLastPostion.Text));
  56.                 cmd.Parameters.Add(new SqlParameter("@CurrentPosition", cmdCurrentPosition.Text));
  57.                 cmd.Parameters.Add(new SqlParameter("@ProRecognitionStatus", cmdProfessionalRecognition.Text));
  58.                 cmd.Parameters.Add(new SqlParameter("@ProRecognitionPurpose", cmdRecognitionProfessionalPurpose.Text));
  59.                 cmd.Parameters.Add(new SqlParameter("@MaritalStatus", cmdMarried.SelectedItem.Text));
  60.                 cmd.Parameters.Add(new SqlParameter("@DivorcedStatus", cmdDivorced.SelectedItem.Text));
  61.                 cmd.Parameters.Add(new SqlParameter("@HusbandOrWifeName", cmdHusbandOrWifeName.Text));
  62.                 cmd.Parameters.Add(new SqlParameter("@HusbandOrWifeAge", Convert.ToInt16(cmdHusbandOrWifeAge.Text)));
  63.                 cmd.Parameters.Add(new SqlParameter("@HusbandOrWifeOccupation", cmdHusbandOrWifeOccupation.Text));
  64.                 cmd.Parameters.Add(new SqlParameter("@HusbandOrWifeDependent", cmdHusbandOrWifeDependant.SelectedItem.Text));
  65.                 cmd.Parameters.Add(new SqlParameter("@FatherName", cmdFatherName.Text));
  66.                 cmd.Parameters.Add(new SqlParameter("@FatherIsAlive", cmdIsFatherAlive.SelectedItem.Text));
  67.                 cmd.Parameters.Add(new SqlParameter("@MotherName", cmdMotherName.Text));
  68.                 cmd.Parameters.Add(new SqlParameter("@MotherIsAlive", cmdIsMotherAlive.SelectedItem.Text));
  69.                 cmd.Parameters.Add(new SqlParameter("@FacultyID", cmdFacultyID.Text));
  70.                 cmd.Parameters.Add(new SqlParameter("@Specialization", cmdFacultySubject.SelectedItem.Text));
  71.                 cmd.Parameters.Add(new SqlParameter("@AssignedPaper", cmdAssignedPaper.SelectedItem.Text));
  72.                 cmd.Parameters.Add(new SqlParameter("@AssignedPaperStatus", cmdAssignedPaperStatus.SelectedItem.Text));
  73.                 cmd.Parameters.Add(new SqlParameter("@QuestionPaperID", cmdQuestionPaperID.SelectedItem.Text));
  74.                 cmd.Parameters.Add(new SqlParameter("@QuestionPaperStatus", cmdQuestionPaperStatus.SelectedItem.Text));
  75.                 cmd.Parameters.Add(new SqlParameter("@HOD", cmdHOD.SelectedItem.Text));
  76.                 cmd.Parameters.Add(new SqlParameter("@ReportingName", cmdHODName.SelectedItem.Text));
  77.                 cmd.Parameters.Add(new SqlParameter("@Biography", cmdBiography.InnerText.Trim()));
  78.                 cmd.CommandType = CommandType.StoredProcedure;
  79.                 cmd.Connection = con;
  80.                 con.Open();
  81.                 cmd.ExecuteNonQuery();
  82.             }
  83.             catch (FormatException)
  84.             {
  85.                 Response.Write("Please provide proper information !");
  86.             }
  87.             finally
  88.             {
  89.                 con.Dispose();
  90.                 con.Close();
  91.             }
  92.         }
  93.  
  94.  
  95.  
procedure is :
Expand|Select|Wrap|Line Numbers
  1. USE [Test]
  2. GO
  3. /****** Object:  StoredProcedure [dbo].[USPFacultyRegistrationInsertData]    Script Date: 02/10/2012 22:05:41 ******/
  4. SET ANSI_NULLS ON
  5. GO
  6. SET QUOTED_IDENTIFIER ON
  7. GO
  8. -- =============================================
  9. -- Author:        <Author,,Name>
  10. -- Create date: <Create Date,,>
  11. -- Description:    <Description,,>
  12. -- =============================================
  13. CREATE PROCEDURE [dbo].[USPFacultyRegistrationInsertData]
  14.     (
  15.     @Title nvarchar (200) ,
  16.     @FirstName nvarchar (200) ,
  17.     @MiddleName nvarchar (200) ,
  18.     @LastName nvarchar (200) ,
  19.     @Height varchar (100) ,
  20.     @Complaxion varchar (200) ,
  21.     @photo image,
  22.     @MobileNo numeric (18, 0),
  23.     @EmailID nvarchar (max),
  24.     @ResidenceContactNO numeric (18, 0),
  25.     @OfficeContactNO numeric (18, 0),
  26.  
  27.     @PassportStatus varchar (50),
  28.     @PassportNO varchar (50),
  29.     @PANCardStatus varchar (50),
  30.     @PANCardNO varchar (50),
  31.     @LicenseStatus varchar (50),
  32.     @LicenseNo varchar (50),
  33.  
  34.     @PermanentAddress nvarchar (max) ,
  35.     @CorrespondanceAddress nvarchar (max) ,
  36.     @CountryName nvarchar (max) ,
  37.     @StateName nvarchar (max) ,
  38.     @CityName nvarchar (max) ,
  39.     @ZIPCode int,
  40.     @HighestQualification nvarchar(max) ,
  41.     @GradeOrPercentage nvarchar (max) ,
  42.     @UniversityName nvarchar (max) ,
  43.     @PassingYear int,
  44.     @CertificationYear int,
  45.     @CertificationName nvarchar(max),
  46.     @EduRecognitionStatus varchar(50),
  47.  
  48.     @EduRecognitionPurpose nvarchar(max),
  49.     @TotalExperience float,
  50.     @RelevantExperience float,
  51.     @LastOrganization varchar(200),
  52.     @CurrentOrganization varchar(200),
  53.     @LastPosition varchar(200),
  54.     @CurrentPosition varchar(200),
  55.     @ProRecognitionStatus varchar(50),
  56.     @ProRecognitionPurpose nvarchar(max),
  57.     @MaritalStatus varchar(50),
  58.     @DivorcedStatus varchar(50),
  59.     @HusbandOrWifeName nvarchar(max),
  60.     @HusbandOrWifeAge int,
  61.     @HusbandOrWifeOccupation varchar(max),
  62.     @HusbandOrWifeDependent varchar(max),
  63.     @FatherName nvarchar(max),
  64.     @FatherIsAlive varchar(50),
  65.     @MotherName nvarchar(max),
  66.     @MotherIsAlive varchar(50),
  67.     @FacultyID varchar(200),
  68.     @Specialization nvarchar(200),
  69.     @AssignedPaper nvarchar(200),
  70.     @AssignedPaperStatus varchar(200),
  71.     @QuestionPaperID nvarchar(200),
  72.     @QuestionPaperStatus varchar(200),
  73.     @HOD nvarchar(max),
  74.     @ReportingName nvarchar(200),
  75.     @Biography nvarchar(max)
  76.     )
  77. AS
  78. BEGIN
  79.     -- SET NOCOUNT ON added to prevent extra result sets from
  80.     -- interfering with SELECT statements.
  81.     SET NOCOUNT ON;
  82.  
  83.     -- Insert statements for procedure here
  84.     INSERT INTO [dbo].[FacultyMaster] 
  85.                 (
  86.     [Title],
  87.     [FirstName],
  88.     [MiddleName],
  89.     [LastName],
  90.     [Height] ,
  91.     [Complaxion],
  92.     [photo],
  93.     [MobileNo] ,
  94.     [EmailID] ,
  95.     [ResidenceContactNO],
  96.     [OfficeContactNO] ,
  97.     [PermanentAddress],
  98.     [CorrespondanceAddress],
  99.     [PassportStatus],
  100.     [PassportNO],
  101.     [PANCardStatus],
  102.     [PANCardNO],
  103.     [LicenseStatus],
  104.     [LicenseNo],
  105.     [CountryName],
  106.     [StateName] ,
  107.     [CityName] ,
  108.     [ZIPCode] ,
  109.     [HighestQualification] ,
  110.     [GradeOrPercentage] ,
  111.     [UniversityName] ,
  112.     [PassingYear] ,
  113.     [CertificationYear],
  114.     [CertificationName],
  115.     [EduRecognitionStatus],
  116.     [EduRecognitionPurpose] ,
  117.     [TotalExperience] ,
  118.     [RelevantExperience],
  119.     [LastOrganization] ,
  120.     [CurrentOrganization],
  121.     [LastPosition] ,
  122.     [CurrentPosition],
  123.     [ProRecognitionStatus],
  124.     [ProRecognitionPurpose],
  125.     [MaritalStatus] ,
  126.     [DivorcedStatus],
  127.     [HusbandOrWifeName],
  128.     [HusbandOrWifeAge],
  129.     [HusbandOrWifeOccupation],
  130.     [HusbandOrWifeDependent],
  131.     [FatherName],
  132.     [FatherIsAlive],
  133.     [MotherName] ,
  134.     [MotherIsAlive],
  135.     [FacultyID] ,
  136.     [Specialization],
  137.     [AssignedPaper] ,
  138.     [AssignedPaperStatus],
  139.     [QuestionPaperID] ,
  140.     [QuestionPaperStatus],
  141.     [HOD] ,
  142.     [ReportingName],
  143.     [Biography] ,
  144.     [RegistrationDate]
  145.                 )
  146.            VALUES
  147.                  (
  148.     @Title,
  149.     @FirstName,
  150.     @MiddleName,
  151.     @LastName,
  152.     @Height ,
  153.     @Complaxion,
  154.     @photo,
  155.     @MobileNo ,
  156.     @EmailID ,
  157.     @ResidenceContactNO,
  158.     @OfficeContactNO ,
  159.     @PermanentAddress,
  160.     @CorrespondanceAddress,
  161.     @PassportStatus,
  162.     @PassportNO,
  163.     @PANCardStatus,
  164.     @PANCardNO,
  165.     @LicenseStatus,
  166.     @LicenseNo,
  167.     @CountryName,
  168.     @StateName,
  169.     @CityName,
  170.     @ZIPCode ,
  171.     @HighestQualification ,
  172.     @GradeOrPercentage ,
  173.     @UniversityName ,
  174.     @PassingYear ,
  175.     @CertificationYear,
  176.     @CertificationName,
  177.     @EduRecognitionStatus,
  178.     @EduRecognitionPurpose ,
  179.     @TotalExperience ,
  180.     @RelevantExperience,
  181.     @LastOrganization ,
  182.     @CurrentOrganization,
  183.     @LastPosition ,
  184.     @CurrentPosition,
  185.     @ProRecognitionStatus,
  186.     @ProRecognitionPurpose,
  187.     @MaritalStatus ,
  188.     @DivorcedStatus,
  189.     @HusbandOrWifeName,
  190.     @HusbandOrWifeAge,
  191.     @HusbandOrWifeOccupation,
  192.     @HusbandOrWifeDependent,
  193.     @FatherName,
  194.     @FatherIsAlive,
  195.     @MotherName ,
  196.     @MotherIsAlive,
  197.     @FacultyID ,
  198.     @Specialization,
  199.     @AssignedPaper ,
  200.     @AssignedPaperStatus,
  201.     @QuestionPaperID ,
  202.     @QuestionPaperStatus,
  203.     @HOD ,
  204.     @ReportingName,
  205.     @Biography ,
  206.     getdate()
  207.                  )
  208. END
  209.  
  210.  
Feb 10 '12 #1

✓ answered by Newface

this is resolved using bytes data.

@Newface

1 2066
Newface
16
this is resolved using bytes data.

@Newface
Feb 10 '12 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Julia Briggs | last post by:
Hello, is there anyway to insert an image on any particular <select> option line in a drop down list without using a specialty drop-down? Any good ones out there that can be made to resemble a...
2
by: altergothen | last post by:
Hi there I am a newbie to ASP.Net - Please Help! I am trying to insert the values of my variables into a database. If I try the following it works perfectly: string insertQuery = "INSERT into...
2
by: Bob | last post by:
I looked at the sample in the msdn january 2005 - Introducing a new datagrid, but the project downloaded failed to open. Any one can point me to a bit of code on how to go and select an image...
4
by: ghowells | last post by:
I've been trying to create an image database using Access 2000 linked to all the images on our server, as per the instructions on the microsoft website. The code to link the photos is as follows:...
2
by: oren18 | last post by:
hello.does anybody know .. how to make an image database by using VB.NET 2005 and Microsoft Access i want to make an application ( VB.NET 2005 ) that prompt a user to put his picture into...
0
by: oren18 | last post by:
hello.does anybody know .. how to make an image database by using VB.NET 2005 and Microsoft Access i want to make an application ( VB.NET 2005 ) that prompt a user to put his picture into...
1
by: ram achar | last post by:
please send me C# code for inserting values into database sql server2005 *** Sent via Developersdex http://www.developersdex.com ***
0
by: nma | last post by:
Hiya, Can anyone help me in this..i'm stuck I have created a table in SQL server that contain field name (shotSelectedKeyfrm -int type, and imgSelectedKeyfrm-varchar(255) type) like below: ...
0
by: jparulan | last post by:
I'm trying to insert a TIF image to ORACLE database 10g using ODP.net and also tried OleDB but I was not successful. Anybody can shed a light? this.TIFFIMG = OCRdir + "\\" +...
0
by: toyin | last post by:
hello, pls help look through this code its not inserting the record in dataset into the another database. i want to insert the row in the dataset into another table in another database. pls help....
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.