Boa noite a todos,
Segue abaixo a resposta para o meu problema. Achei em outro forum e quero copartilhar.
01.
using
System;
02.
using
System.Drawing;
03.
using
System.IO;
04.
using
System.Linq;
05.
using
System.Windows.Forms;
06.
07.
namespace
StoreImagesToSqlCe
08.
{
09.
public
partial
class
Form1 : Form
10.
{
11.
public
Form1()
12.
{
13.
InitializeComponent();
14.
}
15.
16.
private
void
buttonStoreImageToDb_Click(
object
sender, EventArgs e)
17.
{
18.
// Open the DataContext
19.
Database1 db =
new
Database1(
"Data Source=Database1.sdf"
);
20.
try
21.
{
22.
// Convert System.Drawing.Image to a byte[]
23.
byte
[] file_byte = ImageToByteArray(pictureBox1.Image);
24.
// Create a System.Data.Linq.Binary - this is what an "image" column is mapped to
25.
System.Data.Linq.Binary file_binary =
new
System.Data.Linq.Binary(file_byte);
26.
Images img =
new
Images
27.
{
28.
Image = file_binary,
29.
ImageName =
"Erik testing "
30.
};
31.
db.Images.InsertOnSubmit(img);
32.
}
33.
finally
34.
{
35.
// Save
36.
db.SubmitChanges();
37.
}
38.
}
39.
40.
private
void
buttonRetireveImageFromDb_Click(
object
sender, EventArgs
e)
41.
{
42.
// Open the DataContext
43.
Database1 db =
new
Database1(
"Data Source=Database1.sdf"
);
44.
45.
// Get as single image from the database
46.
var img = (from image
in
db.Images
47.
where image.ImageName ==
"Erik testing"
48.
select image).Single();
49.
// Convert the byte[] to an System.Drawing.Image
50.
pictureBox1.Image = ByteArrayToImage(img.Image.ToArray());
51.
}
52.
53.
private
byte
[] ImageToByteArray(System.Drawing.Image imageIn)
54.
{
55.
using
(MemoryStream ms =
new
MemoryStream())
56.
{
57.
imageIn.Save(ms, System.Drawing.Imaging.ImageFormat.Gif);
58.
return
ms.ToArray();
59.
}
60.
}
61.
62.
public
Image ByteArrayToImage(
byte
[] byteArrayIn)
63.
{
64.
using
(MemoryStream ms =
new
MemoryStream(byteArrayIn))
65.
{
66.
Image returnImage = Image.FromStream(ms);
67.
return
returnImage;
68.
}
69.
}
70.
71.
}
Watson Passos Especializando em Gerenciamento de Projetos Graduado em Sistemas de Informação