int is incompatible with image

Question

1.00/5 (1 vote)

See more:

hello,

I want to insert photo into database...i have used datatype image for the photo column
this is the code i used to insert to databse..i

C#

protected void Btn_Save_Click(object sender, EventArgs e)
      {
        objSqlData.SetSQLCommandParameterAddWithValue("@Photo", SqlDbType.Image);
      // procedure
      }

here is my stored procedure

SQL

ALTER procedure Insert
as 
begin 
@FirstName nvarchar(50),
@LastName nvarchar(50),
@Photo image

INSERT INTO Employee 
(FirstName, LastName,photo)
VALUES (@FirstName , @LastName,@Photo)
end

Thank you

Posted 31-May-15 19:35pm

Member 11148509

Updated 31-May-15 21:12pm

v8

Add a Solution

Comments

Tomas Takac 1-Jun-15 2:53am

The code is clearly not complete. Show the stored proc too.

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

sasanka sekhar panda · Answer 1 · 2015-05-31T21:33:00

C#

//getting length of uploaded file
int length = fileuploadImage.PostedFile.ContentLength;
//create a byte array to store the binary image data
byte[] imgbyte = new byte[length];
//store the currently selected file in memeory
HttpPostedFile img = fileuploadImage.PostedFile;
//fileuploadImage is the name of my file uploder
//set the binary data
img.InputStream.Read(imgbyte, 0, length);

//please convert your image to byte array


cmd.Parameters.Add("@Photo", SqlDbType.Image).Value = imgbyte;
//cmd is a object of sql command class

int count = cmd.ExecuteNonQuery();

//This code will work for asp.net
//if u r working in windows application then let me know

sasanka sekhar panda · Answer 2 · 2015-05-31T22:19:00

Solution 2

Repace fileuploadImage with your fileuploder id in code;

If it is not working for u
then post all the code inside the button click.

Posted 31-May-15 22:19pm

sasanka sekhar panda

Comments

Member 11148509 1-Jun-15 4:22am

can u tell me why this error occurs????error is coming near sp ....

sasanka sekhar panda 1-Jun-15 6:26am

please share your full code so that i can help you

Member 11148509 1-Jun-15 6:38am

this is the code for preview of the image and the code which i have shared in the starting for inserting into database ..im using radaschyncupload and radbinary image..

protected void Page_Load(object sender, EventArgs e)
{
RadAsyncUpload.FileUploaded += new Telerik.Web.UI.FileUploadedEventHandler(RadAsyncUpload_FileUploaded);

Radbtn_Upload.Click += new EventHandler(RadBtn_Upload_Click);
}

protected void RadAsyncUpload_FileUploaded(object sender, FileUploadedEventArgs e)
{
Bitmap bitmapImage = ResizeImage(RadAsyncUpload.UploadedFiles[0].InputStream);
System.IO.MemoryStream stream = new System.IO.MemoryStream();
bitmapImage.Save(stream, System.Drawing.Imaging.ImageFormat.Bmp);
RadBinaryImage.DataValue = stream.ToArray();

}
public Bitmap ResizeImage(Stream stream)
{
System.Drawing.Image originalImage = Bitmap.FromStream(stream);

int height = 100;
int width = 100;

Bitmap scaledImage = new Bitmap(width, height);

using (Graphics g = Graphics.FromImage(scaledImage))
{
g.InterpolationMode = System.Drawing.Drawing2D.InterpolationMode.HighQualityBicubic;
g.DrawImage(originalImage, 0, 0, width, height);
//g.DrawString("My photo from " + RadComboBox2.SelectedItem.Text + ", " + RadComboBox1.SelectedItem.Text, new Font("Tahoma", 18), Brushes.White, new PointF(0, 0));
return scaledImage;
}

sasanka sekhar panda · Answer 3 · 2015-06-01T00:41:00

Solution 3

is this a window application??

Posted 1-Jun-15 0:41am

sasanka sekhar panda

Comments

Member 11148509 1-Jun-15 6:51am

its a Web application...Asp is used

sasanka sekhar panda 1-Jun-15 6:54am

which database u r using??

Member 11148509 1-Jun-15 6:57am

sql

sasanka sekhar panda · Answer 4 · 2015-06-01T01:08:00

Solution 4

please read this article..it may help u..

Click me[^]

Posted 1-Jun-15 1:08am

sasanka sekhar panda

Comments

Member 11148509 1-Jun-15 7:34am

This is onl for fileupload...im using ajax controls ...fileupload does not work in ajax controls....let me know why this errors comes so that i can proceed

sasanka sekhar panda 1-Jun-15 7:42am

objSqlData.SetSQLCommandParameterAddWithValue("@Photo", SqlDbType.Image);

here you are passing the sp parameter name and type...show me the code where you are assigning value to this @Photo parameter.. @Photo parameter you have to assign a byte[]...

Member 11148509 1-Jun-15 7:46am

i have pasted the code when u asked thats the code i have used...

Member 11148509 1-Jun-15 7:48am

radasyncupload doesnot have hasfile property

int is incompatible with image

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us