System.Data.SQLite

Hi everyone! can you help me with this? I can load image from database into PictureBox with MemoryStream. I just create memmorystream from byte[] then loadbitmat from stream and then put it into PictureBox.Image. All is OK. I can even :) load Image from file into PictureBox.Image! All works fine when I use databindings (wizard etc), but if i want to load image into blob (byte[]) on my own I simply cannot do this:( I dont know how to convert PictureBox.Image to byte[] and then insert this into database. I did something but when i load Image from database then i have error with unknown format:(!!! Can anyone help me save PictureBox into blob( byte[]) ??? Thanx!

This code works perfectly for me: 

               using (SQLiteTransaction mytransaction = myconnection.BeginTransaction())
                {
                    SQLiteCommand mycommand = new SQLiteCommand(myconnection);
                    
                    SQLiteParameter myparam = new SQLiteParameter("@myparam");
                    SQLiteParameter myparam2 = new SQLiteParameter("@myparam2");

                    mycommand.CommandText = "INSERT INTO table VALUES(@myparam, @myparam2)";
                    mycommand.Parameters.Add(myparam);         // <- myparam1 is int

                    mycommand.Parameters.Add(myparam2);       // <- in myparam2 I save the blob image

                    ms = new MemoryStream();
                    myparam.Value = 1;
                    pictureBox1.Image.Save(ms, pictureBox1.Image.RawFormat);
                    myparam2.Value = ms.ToArray();              // <- here I save the image
                    mycommand.ExecuteNonQuery();
                    
                    mytransaction.Commit();
           }

  hope this work for you

Thanx! As I remember "ms.ToArray()" may help in my source!

Kudos for this.  I had a similar problem and your solution worked perfectly!

 

Hi, i still have a problem i cannot handle:

 

con.Open();

SQLiteCommand zapytanie = new SQLiteCommand("UPDATE links SET favicon=@favicon WHERE id=" + linkId.ToString(), con);

SQLiteParameter parametr = new SQLiteParameter("@favicon");

MemoryStream mystream = new MemoryStream();

img.Save(mystream, img.RawFormat);//here is exception:Value cannot be null.Parameter name: encoder

parametr.Value = mystream.ToArray();

zapytanie.Parameters.Add(parametr);

zapytanie.ExecuteNonQuery();

con.Close();

 

and img is from:

request = (HttpWebRequest)WebRequest.Create(iconPath);response = (HttpWebResponse)request.GetResponse();

receiveStream = response.GetResponseStream();

img = Image.FromStream(receiveStream);

response.Close();

 

Please help me, why exception is raised?

 

Wiaz:

img.Save(mystream, img.RawFormat);//here is exception:Value cannot be null.Parameter name: encoder

Icon.FromHandle((((Bitmap)img).GetHicon())).Save(mystream);

:) it works, strange btu works finally!