How Do I Retrieve SQLCE Bitmap Image

Hello,

I have not seen a response to this specific question so here goes. I had working code for loading an image into my smart device SQLCE db and for retrieving images. But after upgrading my application to SQLCE 2.0 I am unable to use my retrieve code. This is what was previously working,



Dim ImageBytes As Byte = rs.GetValue(rs.GetOrdinal("OLE"))

Dim ImageStream As New System.IO.MemoryStream(ImageBytes)

frmFlashcardActive.picboxBlobToPicBox.Image = New Bitmap(ImageStream)



Help!



This is what I successfully use to save the image to the database



Dim PictureInfo As New FileInfo("My DocumentsUSAFlag.bmp") 'OpenDialog.FileName

Dim PictureSize(PictureInfo.Length) As Byte

If PictureSize.GetValue(0) <= 69 Then

Dim fsPicture As New FileStream(PictureInfo.FullName, FileMode.Open)

Dim PictureReader As New BinaryReader(fsPicture)

PictureReader.Read(PictureSize, 0, PictureSize.Length)

'find the previous record and add the picture

rs.SetValue(rs.GetOrdinal("OLE"), PictureSize) 'could be FlashcardAPic

rs.SetValue(rs.GetOrdinal("Picture"), "True")

rs.Update()

fsPicture.Close()