Parameter Not Valid Error

[mafaisal]

Hi Everybody

My Error when i Retrieve imge file from sql2005 database
parameter not valid error is coming

my code is

Dim Logo As Byte() = RsC.Fields("Logo").Value
Dim stream As System.IO.MemoryStream
stream = New System.IO.MemoryStream(Logo)
PBLogo.Image = System.Drawing.Image.FromStream(stream) - Here That error coming

Plz hep me

[Plater]

The code part *seems* correct.
I would wonder if the byte array you have corrosponds to the binary data that it should. Maybe it's empty?

[Frinavale]

Hi Everybody

My Error when i Retrieve imge file from sql2005 database
parameter not valid error is coming

my code is

Dim Logo As Byte() = RsC.Fields("Logo").Value
Dim stream As System.IO.MemoryStream
stream = New System.IO.MemoryStream(Logo)
PBLogo.Image = System.Drawing.Image.FromStream(stream) - Here That error coming

Plz hep me

Check to make sure that the value you retrieve from your database contains data:
ArgumentException: The stream does not have a valid image format -or- stream is a null reference (Nothing in Visual Basic). (Image.FromStream Method)

-Frinny

[Torgg]

This is the code I use for my header Image. There might be a better/cleaner way to get this done but this has worked well for me.

 
public byte[] LogoRetrieve()
        {
            //Gets the image from the database and returns a byte array 
            SqlConnection sqlConn = new SqlConnection(Properties.Settings.Default.ConnectionString);
 
            DataTable dtImages = new DataTable();
            using (sqlConn)
            {
                try
                {
                    sqlConn.Open();
                    SqlCommand sqlComm = sqlConn.CreateCommand();
 
                    //Select Image
                    sqlComm.CommandText = "SELECT HeaderLogo FROM dbo.ConfigurationSettings WHERE ConfigID = 1";
                    sqlComm.ExecuteNonQuery();
 
                    SqlDataAdapter sqlDA = new SqlDataAdapter(sqlComm);
                    sqlDA.Fill(dtImages);
                }
                catch (Exception ex)
                {
                    MessageBox.Show(Convert.ToString(ex));
                }
                finally
                {
                    sqlConn.Close();
                }
            }
 
            //Get image from the DataTable
            byte[] imageData = (byte[])dtImages.Rows[0]["HeaderLogo"];
 
            return imageData; 
        }

I hope this is helpful,
Torgg

[mafaisal]

This is C#
Plz Give vb.net code

also byte array not empty

plz

This is the code I use for my header Image. There might be a better/cleaner way to get this done but this has worked well for me.

 
public byte[] LogoRetrieve()
        {
            //Gets the image from the database and returns a byte array 
            SqlConnection sqlConn = new SqlConnection(Properties.Settings.Default.ConnectionString);
 
            DataTable dtImages = new DataTable();
            using (sqlConn)
            {
                try
                {
                    sqlConn.Open();
                    SqlCommand sqlComm = sqlConn.CreateCommand();
 
                    //Select Image
                    sqlComm.CommandText = "SELECT HeaderLogo FROM dbo.ConfigurationSettings WHERE ConfigID = 1";
                    sqlComm.ExecuteNonQuery();
 
                    SqlDataAdapter sqlDA = new SqlDataAdapter(sqlComm);
                    sqlDA.Fill(dtImages);
                }
                catch (Exception ex)
                {
                    MessageBox.Show(Convert.ToString(ex));
                }
                finally
                {
                    sqlConn.Close();
                }
            }
 
            //Get image from the DataTable
            byte[] imageData = (byte[])dtImages.Rows[0]["HeaderLogo"];
 
            return imageData; 
        }

I hope this is helpful,
Torgg

[mafaisal]

Hello Plater
I am Saving image in database as datatype image in sql2005
i have to retrieve that image then these error coming
also it is not empty
i trying to retrieve in picturebox pblogo

The code part *seems* correct.
I would wonder if the byte array you have corrosponds to the binary data that it should. Maybe it's empty?