Click here to Skip to main content
15,923,142 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
GeneralRe: Help Pin
manu_22054-Jan-07 0:07
manu_22054-Jan-07 0:07 
GeneralRe: Help Pin
Hamid_RT4-Jan-07 0:13
Hamid_RT4-Jan-07 0:13 
GeneralRe: Help Pin
manu_22054-Jan-07 2:28
manu_22054-Jan-07 2:28 
GeneralRe: Help Pin
Hamid_RT4-Jan-07 5:30
Hamid_RT4-Jan-07 5:30 
GeneralRe: Help Pin
Hamid_RT4-Jan-07 17:43
Hamid_RT4-Jan-07 17:43 
QuestionSocketNotification error Pin
Kiran Pinjala3-Jan-07 19:40
Kiran Pinjala3-Jan-07 19:40 
AnswerRe: SocketNotification error Pin
Rajesh R Subramanian3-Jan-07 19:49
professionalRajesh R Subramanian3-Jan-07 19:49 
QuestionRetrieve image file from Access database Pin
Vishvanathan3-Jan-07 19:21
Vishvanathan3-Jan-07 19:21 
Hi Friends,

I am developing a database application. I have one problem in this application.such as
How to retrieve the image file like jpeg image from mdb file.

Information:

IDE : VC++ 6.0
Provider=Microsoft.Jet.OLEDB.4.0
class:
CDaoDatabase and CDaoRecordset

Fields in Image table ( db1.mdb ),
1. Name - Text
2. Id - Number
3. DOB - Date
4. Photo - OLE Object

Sample code:

CDaoDatabase database;

CDaoRecordset m_recordset ( &database );

CString strName = "D:\\db1.mdb";

database.Open ( strName,TRUE ,TRUE , _T(";PWD=vichu") );



//
if ( ! m_recordset.IsOpen ( ) )
{
m_recordset.Open ( dbOpenDynaset, "SELECT * FROM images", 0);
}

COleVariant var;

if ( ! (m_recordset.IsBOF ( ) && m_recordset.IsEOF ( ) ) )
{
m_recordset.MoveFirst ( );
}


while ( ! m_recordset.IsEOF ( ) )
{
var = m_recordset.GetFieldValue ( "AF_Text" );

str.Format ( "%s", var.bstrVal );

AfxMessageBox ( str );

var = m_recordset.GetFieldValue ( "AF_Number" );

str.Format ( "%d", var.intVal );

AfxMessageBox ( str );

var = m_recordset.GetFieldValue ( "AF_Date" );

COleDateTime m_date ( var );

str.Format ( "%d/%d/%d", m_date.GetDay ( ), m_date.GetMonth ( ), m_date.GetYear ( ) );


AfxMessageBox ( str );

<code>var = m_recordset.GetFieldValue ( "AF_Photo" );
</code>
str.Format ( "%s", var.bstrVal );

AfxMessageBox ( str );


m_recordset.MoveNext ( );
}

m_recordset.Close ( );


Pls anyone give suggestion/examples to me asap.

Thanks & Regards,

Vichu
AnswerRe: Retrieve image file from Access database Pin
Hamid_RT4-Jan-07 17:42
Hamid_RT4-Jan-07 17:42 
GeneralRe: Retrieve image file from Access database Pin
Vishvanathan5-Jan-07 18:34
Vishvanathan5-Jan-07 18:34 
GeneralRe: Retrieve image file from Access database Pin
Hamid_RT5-Jan-07 21:29
Hamid_RT5-Jan-07 21:29 
QuestionHelp Pin
messages3-Jan-07 19:12
messages3-Jan-07 19:12 
AnswerRe: Help Pin
Rage3-Jan-07 22:33
professionalRage3-Jan-07 22:33 
GeneralRe: Help Pin
messages3-Jan-07 23:49
messages3-Jan-07 23:49 
QuestionModeless dialog having Static methods and variables Pin
RajiRaghu3-Jan-07 18:20
RajiRaghu3-Jan-07 18:20 
QuestionRe: Modeless dialog having Static methods and variables Pin
prasad_som3-Jan-07 18:35
prasad_som3-Jan-07 18:35 
AnswerRe: Modeless dialog having Static methods and variables Pin
Mark Salsbery3-Jan-07 18:36
Mark Salsbery3-Jan-07 18:36 
GeneralRe: Modeless dialog having Static methods and variables Pin
RajiRaghu3-Jan-07 19:24
RajiRaghu3-Jan-07 19:24 
GeneralRe: Modeless dialog having Static methods and variables Pin
Mark Salsbery4-Jan-07 4:58
Mark Salsbery4-Jan-07 4:58 
QuestionMulti Lingual GUI Pin
kiranin3-Jan-07 17:53
kiranin3-Jan-07 17:53 
AnswerRe: Multi Lingual GUI Pin
prasad_som3-Jan-07 19:01
prasad_som3-Jan-07 19:01 
AnswerRe: Multi Lingual GUI Pin
Rajesh R Subramanian3-Jan-07 19:53
professionalRajesh R Subramanian3-Jan-07 19:53 
GeneralRe: Multi Lingual GUI Pin
kiranin3-Jan-07 19:58
kiranin3-Jan-07 19:58 
GeneralRe: Multi Lingual GUI Pin
Rajesh R Subramanian3-Jan-07 20:05
professionalRajesh R Subramanian3-Jan-07 20:05 
QuestionRe: Multi Lingual GUI Pin
prasad_som3-Jan-07 20:05
prasad_som3-Jan-07 20:05 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.