Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C#4.0
Error on this code Parameter is not valid help me.
 
SqlCommand cmd = new SqlCommand("ReadImage", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@imgId", SqlDbType.Int).Value = Convert.ToInt32(cmbImageID.SelectedValue.ToString());
SqlDataAdapter adp = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
 
try
{
    if (con.State == ConnectionState.Closed)
        con.Open();
    adp.Fill(dt);
    if (dt.Rows.Count > 0)
    {
        MemoryStream ms = new MemoryStream((byte[])dt.Rows[0]["ImageData"]);
        picImage.Image = Image.FromStream(ms);
 
        picImage.SizeMode = PictureBoxSizeMode.StretchImage;
        picImage.Refresh();
    }
}
Table name = ImageData Column name= ImageData
Store procedure ReadImage
CREATE PROCEDURE dbo.ReadImage 
	(@imgId int)
AS
	SELECT ImageData FROM ImageData
	WHERE ImageID=@imgId
	RETURN
Posted 22-Sep-12 1:13am
Edited 22-Sep-12 1:38am
v3

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Normally, this error occurs because you what you have saved in the database is not a valid image - so when you retrieve the information the Image.FromStream throws an exception because it cannot recognise it.
 
Check your loading code: the normal mistakes are not to convert the Image into a bytes array before saving it or building an INSERT statement by concatenating strings, which tends to insert the string "System.Drawing.Image" in the database instead of the image data.
  Permalink  

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

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 380
1 OriginalGriff 250
2 DamithSL 210
3 Kornfeld Eliyahu Peter 200
4 Peter Leow 95
0 OriginalGriff 7,315
1 DamithSL 5,199
2 Sergey Alexandrovich Kryukov 4,917
3 Maciej Los 4,866
4 Kornfeld Eliyahu Peter 4,514


Advertise | Privacy | Mobile
Web03 | 2.8.141223.1 | Last Updated 23 Sep 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100