System.ArgumentException was unhandled Message="Parameter is not valid."?

Kanhialal kk

Hi..
I am working on byte to bitmap image conversion.. so first of all i stored picture in bytes and then stored it in database.. but when I get back picture and fetch it in pictureBox than following exception is occuring ..
System.ArgumentException was unhandled
Message="Parameter is not valid."

while i have code..

adpt = new SqlDataAdapter("select Picture_pic from Purchase_Material",conn);
            dt = new DataTable();
            adpt.Fill(dt);
            if (dt.Rows.Count > 0)
            {
                foreach(DataRow row in dt.Rows)
                {
                    this.buff = (byte[])row[0];
                }
                MemoryStream stream = new MemoryStream(this.buff, true);
                if (stream.Length == 0L)
                {
                    this.PIC_Lable.Visible = true;
                }
                else
                {
                    stream.Write(this.buff, 0, this.buff.Length);
                    //Bitmap bitmap = new Bitmap((System.IO.Stream)stream);
                    //System.Drawing.Bitmap..ctor(String filename)
                    System.Drawing.Bitmap.
                    this.pictureBox1.Image = bitmap;
                }
            }
please help me...

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suthish Nair15y ago
On which line the error getting..
Kanhialal kk15y ago
@Vulpes

sir there is only single row in database while i am getting converted picture in query analyzer I mean that column is not empty in database..
also I am placing picture in PictureBox than converting into byte after that going to store in database...
Vulpes15y ago
I see from the code that, having used Image.FromFile() to load the image from a file, you first displayed it in a pictureBox before converting it to a byte array. I assume this worked and so the image type (.bmp, .jpg, .png etc) must be compatible with .NET.

How did you then save the byte[] array to the database and does the Purchase_Material table only contain a single row which is what your retrieval code appears to assume?
Suthish Nair15y ago
The error is due to file not found. You need to first save/write the file to disk and later bind to the control.
Kanhialal kk15y ago
sir

in database a table contains a column with name of
(picture having datatype image)

while below is the code which is used to get image...
private void button1_Browse_Click(object sender, EventArgs e)
        {
            if (this.openFileDialog1.ShowDialog() == DialogResult.OK)
            {
                this.PIC_Lable.Visible = false;
                this.pictureBox1.Image = Image.FromFile(this.openFileDialog1.FileName);
                try
                {
                    this.file = this.openFileDialog1.FileName;
                    FileStream stream = new FileStream(this.file, (FileMode)FileMode.Open, (FileAccess)FileAccess.Read);
                    this.buff = new byte[stream.Length];
                    stream.Read(this.buff, 0, (int)stream.Length);
                    stream.Close();
                }
                catch (ArgumentException exception)
                {
                    MessageBox.Show(exception.Message, "Error!");
                }
            }
        }

this is the code..
Vulpes15y ago
Well, the error is occurring in the Bitmap constructor and it would appear that the stream is not being recognized as valid image data.

How did you save the image to the database in the first place and what type of image is it?
Kanhialal kk15y ago
sir I have attached a file with the name of error.. kindly check it out..
Vulpes15y ago
Can you post the full stack trace for the error.
Kanhialal kk15y ago
sir.
still same error..
Vulpes15y ago
Try:

stream.Write(this.buff, 0, this.buff.Length);
Bitmap bitmap = new Bitmap(stream);
this.pictureBox1.Image = bitmap;