Answers

Error in Inserting image into Database in ASP.NET

Bineesh VP

279

Sir,

I am in a midst of an error while working on inserting image into database.

ASP.NET is the platform and SQL SERVER is the RDBMS.

My error is : -Failed to convert parameter value from a String to a Byte[].

Please go through the screenshot and reply with the correct code.

Please take a look to the table structure where I want to insert my data:-

my sql server query to insert data:-

And finally the c# code for insert function:-

Answers (5)

Your SQL parameter @asBookPhoto expects an Image datatype and you are passing a string to it that's why you are getting that error. You would need to convert the image to byte array and pass it to that parameter.

So change your code to this:

cmd.Parameters.Add("@asBookPhoto",SqlDbType.Image).Value=imageByte;

Accepted

Finally I got the correct code:-

int length = flUpldCoverPhoto.PostedFile.ContentLength;

byte[] photo_aray = new byte[length];
HttpPostedFile postedFile = flUpldCoverPhoto.PostedFile;
postedFile.InputStream.Read(photo_aray, 0, length);
sqlCon.Open();
SqlCommand cmd = new SqlCommand("SaveBookDetails", sqlCon);
cmd.Parameters.Add("@asBookName", SqlDbType.VarChar).Value = txtBookName.Text;
cmd.Parameters.Add("@asBookPhoto", SqlDbType.Image).Value = photo_aray;
cmd.Parameters.Add("@asBookPrice", SqlDbType.Float).Value = txtBookPrice.Text.ToString();
cmd.Parameters.Add("@asAuthor", SqlDbType.VarChar).Value = txtBookAuthor.Text;
cmd.Parameters.Add("@asPublishedYear", SqlDbType.VarChar).Value = txtPublishYear.Text;
cmd.CommandType = CommandType.StoredProcedure;
int inCount = cmd.ExecuteNonQuery();

hi,

I am in the edge of getting the result in insert function, so I only need the solution for Failed to convert parameter value from a String to a Byte[].

the link you gave is totally different from my program flow.