save Contact Photo (bitmap) as Blob Field in DB

[stefanoa]

hi,
i need to save a contact photo into a Blob field of a sqlite db.

this code don't work, because i think photo field has to be converted:

Dim photo As Bitmap
...
dim c as Contact
...
photo = c.GetPhoto
...
sqlcmd = "UP DATE Contacts "
sqlcmd = sqlcmd & " SET image = " & photo    '<--- image is a BLOB field in DB
sqlcmd = sqlcmd & " WHERE LocalContactID = " & ContactID
...
SQL1.ExecNonQuery(sqlcmd)
...

any suggestions?
thanks

 

[stefanoa]

:sign0085:

 

[mangojack]

stefanoa , cant help you personally but maybe this might help.

help saving blob field into DB

Cheers mj

 

[Erel]

You can use KeyValueStore. It allows you to store all kinds of objects including Bitmaps.

 

[stefanoa]

thanks, but i need to store the bitmap in my DB (sqlite).
The table have a blob field (image) and i need to store the contact photo (bitmap) into this field..

 

[Erel]

KeyValueStore uses a SQLite database. You can either use it or just take the relevant code.