Tag: C#

[HowTo] Save Image into SqlCE database

Save into database. //Image to byte[] Image myImage = Image.FromFile(“c:\\xyz.jpg”); System.IO.MemoryStream imgMemoryStream = new System.IO.MemoryStream(); myImage.Save(imgMemoryStream, System.Drawing.Imaging.ImageFormat.Jpeg); byte[] imgByteData = imgMemoryStream.GetBuffer(); //Store image bytes data into database SqlCeConnection scon = new SqlCeConnection(“Data Source=D:\\myDB.sdf”); SqlCeCommand cmd = new SqlCeCommand(“Update ImageTable Set Picture=@myPicture Where Username=’Martin'”, scon); cmd.Parameters.Add(“@myPicture”, SqlDbType.Image).Value = imgByteData; // Or cmd.Parameters.Add(“@myPicture”, SqlDbType.Binary).Value = imgByteData scon.Open(); […]