I have made a C# application that adds images from the harddisk to a blob-field in mysql. I don't get errors and the blob-field is filled.
When I check the blob-field in MySQL Workbench it says the field is not correct (it can not show the image).
Whatever I do, whatever example I try, nothing seems to work. So it has no point to place any example code here, because nothing is working so far.
Does anyone have a good example code that I can try?
Thanks
Okay, since some people wanted some code to be shown, I created a very simple console application with the help described in the link of Alex. I literally taken that code and placed in the console app. Some miracle happend, because it worked as soon as I started the app. I don't know what I did wrong in the main application, but it has to be something (duh). Here is the code:
string MyConString = "SERVER=localhost;" +
"DATABASE=database;" +
"UID=root;" +
"PASSWORD=pass;";
System.IO.FileStream fs = new FileStream(@"D:\link\to\image.png", FileMode.Open);
System.IO.BufferedStream bf = new BufferedStream(fs);
byte[] buffer = new byte[bf.Length];
bf.Read(buffer, 0, buffer.Length);
byte[] buffer_new = buffer;
MySqlConnection connection = new MySqlConnection(MyConString);
connection.Open();
MySqlCommand command = new MySqlCommand("", connection);
command.CommandText = "insert into table(fldImage) values(@image);";
command.Parameters.AddWithValue("@image", buffer_new);
command.ExecuteNonQuery();
connection.Close();
Console.WriteLine("Task Performed!");
Console.ReadLine();
fs FileStream or the bf buffered stream. Your main problem could be that buffer_new doesn't contain all of the bytes of you image, resulting in a corrupted one in MySQL Workbench. You really should be applying the using statement to streams: using (var fs = new FileStream(@"D:\link\to\image.png", FileMode.Open)) { using (var bf = new BufferedStream(fs)) { /* your existing code */ } }Did you try to recover the blob via the mysql connector (the way you store it). MySQL Workbench doesn't displaying the image doesn't mean that isn't being stored.
Try to recover the image:
while (reader.read())
{
var image = (byte[])reader.getColumn(0);
File.WriteAllBytes(@"c:\image.extension", image);
}
This way you can ensure it's saving.
I find when working with mysql and .NET that the MySQL Connector makes things really easy!
This guy: Save Image in MySQL via C# application seems to be on the right lines.
Good Luck!
