Reputation: 273
I have uploaded an Image in to my database as byte[]
and now im trying to display it out.
There was an error - Argument Exception was unhandled by user code Parameter is not valid
At this line
newImage = System.Drawing.Image.FromStream(stream);
Here is my codes
for (int i = 0; i < topRatingList.Count; i++)
{
int commentRating = topRatingList[i].CommentRating;
int drinkID = topRatingList[i].DrinkID;
if (i == 0)
{
DrinkMenuDAO drink = DrinkMenuBLL.getDrinkMenu(drinkID);
LinkButton1.Text = drink.DrinkName;
ImageButton1.ImageUrl = byteArrayToImage(drink.DrinkImage);
}
}
private string byteArrayToImage(byte[] byteArrayIn)
{
System.Drawing.Image newImage;
string strFileName = Server.MapPath("~/Temp/images/") + ".jpg";
if (byteArrayIn != null)
{
using (MemoryStream stream = new MemoryStream(byteArrayIn))
{
newImage = System.Drawing.Image.FromStream(stream);
newImage.Save(strFileName);
}
return strFileName;
}
else
{
return "";
}
}
the code that i used to store the image
protected void bn_upload_Click(object sender, EventArgs e)
{
lbl_msg.Text = "";
Stream imgStream = FileUpload1.PostedFile.InputStream;
BinaryReader imgBinary = new BinaryReader(imgStream);
bytes = imgBinary.ReadBytes((Int32)imgStream.Length);
imgBinary.Close();
imgStream.Close();
string src = byteArrayToImage(bytes);
if (src.Equals(""))
{
}
else
{
Image1.ImageUrl = "~/Temp/UploadedImage.jpg";
}
}
private string byteArrayToImage(byte[] byteArrayIn)
{
System.Drawing.Image newImage;
string strFileName = Server.MapPath("~/Temp/") + "UploadedImage.jpg";
if (byteArrayIn != null)
{
using (MemoryStream stream = new MemoryStream(byteArrayIn))
{
newImage = System.Drawing.Image.FromStream(stream);
newImage.Save(strFileName);
}
return strFileName;
}
else
{
return "";
}
}
protected void btn_submit_Click(object sender, EventArgs e)
{
DrinkMenuBLL.uploadImg(bytes);
lbl_msg.Text = "uploaded";
}
I used varbinary(MAX)
in the database and the sql that i used
public static void UploadImg(byte[] drinkImage)
{
SqlConnection con = new SqlConnection(Constring.getConString());
string sql = "Update DrinkMenu set drinkImage = (@imgData) where drinkID = 4";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.Add("@imgData", SqlDbType.Binary).Value = drinkImage;
try
{
con.Open();
cmd.ExecuteNonQuery();
}
finally
{
con.Close();
cmd.Dispose();
con.Dispose();
}
}
Upvotes: 1
Views: 21626
Reputation: 23675
One problem could be the following one:
bytes = imgBinary.ReadBytes((Int32)imgStream.Length);
What if the stream Length is more than Int32.MaxValue as it's a Int64? Maybe you are truncating your image... use this method instead to read the stream to a buffer:
public static Byte[] ReadStream(Stream input)
{
Byte[] buffer = new Byte[(16 * 1024)];
using (MemoryStream stream = new MemoryStream())
{
Int32 read;
while ((read = input.Read(buffer, 0, buffer.Length)) > 0)
stream.Write(buffer, 0, read);
return stream.ToArray();
}
}
protected void bn_upload_Click(object sender, EventArgs e)
{
lbl_msg.Text = "";
Byte[] bytes = ReadStream(FileUpload1.PostedFile.InputStream);
String src = byteArrayToImage(bytes);
if (!src.Equals(""))
Image1.ImageUrl = "~/Temp/UploadedImage.jpg";
}
Upvotes: 1