How to upload images to mysql database using C#?

Question

I am trying to insert an image from windows application to mysql database . while trying to do so i have encountered the following error

"Unable to cast object of type 'System.Byte[]' to type'System.IConvertible'."

public void LoadImages()          
{        
    MySqlConnection cn = new MySqlConnection(connstring);        
    cn.Open();    
    string image = txtLogo.Text;    
    byte[] ImageData;    
    FileStream fs = new FileStream(image, FileMode.Open, FileAccess.Read);    
    BinaryReader br = new BinaryReader(fs);    
    ImageData = br.ReadBytes((int)fs.Length);    
    br.Close();    
    fs.Close();    
    MySqlCommand cmd = new MySqlCommand("insert into Fn_Pictures(Images,Email)values(@Images,'"+txtEmailId.Text+"')", cn);    
    cmd.Parameters.AddWithValue("@Images", MySqlDbType.LongBlob).Value = ImageData;    
    cmd.ExecuteNonQuery();    
    cn.Close();    
}

Please help in clearing this error.

When i debugged the code error is shown at executenonquerry(; — user3531533
– user3531533, Commented Apr 25, 2014 at 8:52

csharpwinphonexaml · Accepted Answer · 2014-04-25 11:24:36Z

1

This should do:

MySqlCommand cmd = new MySqlCommand("insert into Fn_Pictures(Images,Email)values(?Images,'" + txtEmailIdText + "')", cn);

MySqlParameter parImage = new MySqlParameter();
parImage.ParameterName = "?Images";
parImage.MySqlDbType = MySqlDbType.MediumBlob;
parImage.Size = 3000000;
parImage.Value = ImageData;//here you should put your byte []

cmd.Parameters.Add(parImage);
cmd.ExecuteNonQuery();

This could be one way to check if the Image has been stored to db

//write your code to get the record from db to byte[] ImageData;
public Image byteArrayToImage(byte[] byteBLOBData )
{
    MemoryStream ms = new MemoryStream(byteBLOBData );
    Image returnImage = Image.FromStream(ms);
    return returnImage;
}

call like this

PictureBox picture = new PictureBox();
picture.Image = byteArrayToImage(ImageData);
Controls.Add(picture);

edited Apr 25, 2014 at 11:24

answered Apr 25, 2014 at 9:05

csharpwinphonexaml

3,71810 gold badges34 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

14 Comments

csharpwinphonexaml Over a year ago

When you get it out you must process the bytes and show them as image

csharpwinphonexaml Over a year ago

Depends what kind of application you are doing WPF WinForm ASP.NET?

user3531533 Over a year ago

ASP.NET (C#) its windows application

csharpwinphonexaml Over a year ago

This should help you decide how to proceed on showing the Image stackoverflow.com/questions/18177351/…. As about the Writing the image to the database I think you have the answer

csharpwinphonexaml Over a year ago

@user3531533 How do you know that it isn't?

|

Collectives™ on Stack Overflow

How to upload images to mysql database using C#?

1 Answer 1

14 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

14 Comments

Linked

Related