How To store and retrieve images from database in VC++
-
Hi All, I'm savitri here. I'm doing FingerPrint project. In this project i want to store fingerprint in database and retrieve that fingerprint for comparision.I created one table called "Images" with 2 fields called ID(AutoNumber)and Image(OLE Object). While inserting fingerprint i'm writing SQL statement like this. BYTE* buffer=new BYTE[1632]; buffer=m_RegTemplate.pbData;//m_RegTemplate is DATA_BLOB Type. "INSERT INTO Images(Image) VALUES('"+buffer+"')"; I'm not getting how to retrieve the fingerprint from the database table. i want to save that retrieved fingerprint into m_RegTemplate.pbData for comparision. Please tell me how to solve this problem and Give me some hints. Thanks in Advance Regards, Savitri P :)
-
Hi All, I'm savitri here. I'm doing FingerPrint project. In this project i want to store fingerprint in database and retrieve that fingerprint for comparision.I created one table called "Images" with 2 fields called ID(AutoNumber)and Image(OLE Object). While inserting fingerprint i'm writing SQL statement like this. BYTE* buffer=new BYTE[1632]; buffer=m_RegTemplate.pbData;//m_RegTemplate is DATA_BLOB Type. "INSERT INTO Images(Image) VALUES('"+buffer+"')"; I'm not getting how to retrieve the fingerprint from the database table. i want to save that retrieved fingerprint into m_RegTemplate.pbData for comparision. Please tell me how to solve this problem and Give me some hints. Thanks in Advance Regards, Savitri P :)
You posted your question only 1 hour ago. This is a forum, not a chat. If you can't wait, then go on rentacoder and pay somebody to do the job for you.
Cédric Moonen Software developer
Charting control [v1.5] OpenGL game tutorial in C++ -
You posted your question only 1 hour ago. This is a forum, not a chat. If you can't wait, then go on rentacoder and pay somebody to do the job for you.
Cédric Moonen Software developer
Charting control [v1.5] OpenGL game tutorial in C++ -
Hi All, I'm savitri here. I'm doing FingerPrint project. In this project i want to store fingerprint in database and retrieve that fingerprint for comparision.I created one table called "Images" with 2 fields called ID(AutoNumber)and Image(OLE Object). While inserting fingerprint i'm writing SQL statement like this. BYTE* buffer=new BYTE[1632]; buffer=m_RegTemplate.pbData;//m_RegTemplate is DATA_BLOB Type. "INSERT INTO Images(Image) VALUES('"+buffer+"')"; I'm not getting how to retrieve the fingerprint from the database table. i want to save that retrieved fingerprint into m_RegTemplate.pbData for comparision. Please tell me how to solve this problem and Give me some hints. Thanks in Advance Regards, Savitri P :)
-
what format is your image? If you're storing a bitmap file, you have to first insert the correct header information & then the raw data (i forget how many bytes the header is, but it's more than a few) Might check out "serializable" interfaces too
Hi All, It is fingerprint template. I'm using DATA_BLOB Data type to store the image from the device.I'm not getting how to retrieve the stored image from the database. When i'm trying to retrieve the image from record set.that format is recset.GetFieldValue("Image",buffer);//buffer is of CDBVariant type.I want to assign the buffer value to another BYTE* variable. But i'm not getting how to do this? So please give me any hints to solve this problem. I'm also searching the solution and trying for all the options. Thanks in Advance. Regards, Savitri.