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

Question

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...

Suthish Nair · Answer

On which line the error getting..

Kanhialal kk · Answer

@ 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...

Vulpes · Answer

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 Nair · Answer

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 kk · Answer

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..

Vulpes · Answer

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 kk · Answer

sir I have attached a file with the name of error.. kindly check it out..

Vulpes · Answer

Can you post the full stack trace for the error.

Kanhialal kk · Answer

sir. still same error..

Vulpes · Answer

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

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