Click here to Skip to main content
15,921,959 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
AnswerRe: Conceptual Question Pin
charlieg18-Aug-06 4:06
charlieg18-Aug-06 4:06 
AnswerRe: Conceptual Question Pin
Maximilien18-Aug-06 4:45
Maximilien18-Aug-06 4:45 
GeneralRe: Conceptual Question Pin
LCI18-Aug-06 5:13
LCI18-Aug-06 5:13 
GeneralRe: Conceptual Question Pin
BambooMoon18-Aug-06 6:10
BambooMoon18-Aug-06 6:10 
AnswerRe: Conceptual Question Pin
flippydeflippydebop21-Aug-06 12:12
flippydeflippydebop21-Aug-06 12:12 
QuestionWhy do some people use HeapAlloc instead of malloc? Pin
Chintoo72318-Aug-06 3:48
Chintoo72318-Aug-06 3:48 
AnswerRe: Why do some people use HeapAlloc instead of malloc? Pin
bob1697218-Aug-06 4:25
bob1697218-Aug-06 4:25 
AnswerRe: Why do some people use HeapAlloc instead of malloc? Pin
Andy Moore18-Aug-06 7:02
Andy Moore18-Aug-06 7:02 
GeneralRe: Why do some people use HeapAlloc instead of malloc? Pin
Chintoo72318-Aug-06 7:18
Chintoo72318-Aug-06 7:18 
GeneralRe: Why do some people use HeapAlloc instead of malloc? Pin
Andy Moore18-Aug-06 7:19
Andy Moore18-Aug-06 7:19 
AnswerRe: Why do some people use HeapAlloc instead of malloc? Pin
cmk18-Aug-06 11:31
cmk18-Aug-06 11:31 
QuestionCreating a Crystal report using a predifined template with vc++ 6.0 Pin
SabseJugs18-Aug-06 3:38
SabseJugs18-Aug-06 3:38 
Questionproblem with refresh button!! Pin
vijay_aroli18-Aug-06 3:34
vijay_aroli18-Aug-06 3:34 
AnswerRe: problem with refresh button!! Pin
Rage18-Aug-06 3:39
professionalRage18-Aug-06 3:39 
QuestionRe: problem with refresh button!! Pin
vijay_aroli18-Aug-06 5:02
vijay_aroli18-Aug-06 5:02 
QuestionRe: problem with refresh button!! Pin
David Crow18-Aug-06 6:33
David Crow18-Aug-06 6:33 
NewsRe: problem with refresh button!! Pin
vijay_aroli18-Aug-06 21:19
vijay_aroli18-Aug-06 21:19 
QuestionWord automation Pin
great_tommy18-Aug-06 3:31
great_tommy18-Aug-06 3:31 
AnswerRe: Word automation Pin
Rage18-Aug-06 3:38
professionalRage18-Aug-06 3:38 
GeneralRe: Word automation [modified] Pin
great_tommy18-Aug-06 3:50
great_tommy18-Aug-06 3:50 
GeneralRe: Word automation Pin
David Crow18-Aug-06 6:36
David Crow18-Aug-06 6:36 
QuestionHow Pin
nhoc_conxauxi18-Aug-06 2:58
nhoc_conxauxi18-Aug-06 2:58 
AnswerRe: How Pin
Hamid_RT18-Aug-06 19:35
Hamid_RT18-Aug-06 19:35 
QuestionHow to cut file Pin
nhoc_conxauxi18-Aug-06 2:49
nhoc_conxauxi18-Aug-06 2:49 
Questionhow can i read excel sheet using visual c++ MFC Pin
kamlesh987318-Aug-06 2:18
kamlesh987318-Aug-06 2:18 
Hi,
plz tell me. how can i read excel sheet using visual c++ MFC.
i have write following code but it reads only three rows.
void CReadExcelDlg::OnButton1()
{
CDatabase database;
CString sSql;
CString sItem1, sItem2,sItem3;
CString sDriver;
CString sDsn;
CString sFile = "ReadExcel.xls"; // the file name. Could also be something like C:\\Sheets\\WhatDoIKnow.xls

// Clear the contents of the listbox
m_ctrlList.ResetContent();
sDriver = GetExcelDriver();
if( sDriver.IsEmpty() )
{
// Blast! We didn´t find that driver!
AfxMessageBox("No Excel ODBC driver found");
return;
}

sDsn.Format("ODBC;DRIVER={%s};DSN='';DBQ=%s",sDriver,sFile);

TRY
{

database.Open(NULL,false,false,sDsn);
CRecordset recset( &database );
sSql = "SELECT field_1, field_2 "
"FROM demo_table "
"ORDER BY field_1";
recset.Open(CRecordset::forwardOnly,sSql,CRecordset::readOnly);
while( !recset.IsEOF() )
{
// Read the result line
recset.GetFieldValue("field_1",sItem1);
recset.GetFieldValue("field_2",sItem2);
// recset.GetFieldValue("field_3",sItem3);
// Insert result into the list
m_ctrlList.AddString( sItem1 + " --> "+ sItem2 );

// Skip to the next resultline
recset.MoveNext();
}

// Close the database
database.Close();

}
CATCH(CDBException, e)
{
// A database exception occured. Pop out the details...
AfxMessageBox("Database error: "+e->m_strError);
}
END_CATCH;
}
////plz help me

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.