Click here to Skip to main content
16,005,080 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
AnswerRe: permission Pin
Paresh Chitte26-Apr-07 23:38
Paresh Chitte26-Apr-07 23:38 
GeneralRe: permission Pin
Try27-Apr-07 0:50
Try27-Apr-07 0:50 
AnswerRe: permission Pin
David Crow27-Apr-07 3:16
David Crow27-Apr-07 3:16 
Questiondatabase &CListCtrl Pin
hero199526-Apr-07 23:21
hero199526-Apr-07 23:21 
AnswerRe: database CListCtrl Pin
Hamid_RT26-Apr-07 23:28
Hamid_RT26-Apr-07 23:28 
GeneralRe: database CListCtrl Pin
hero199527-Apr-07 6:52
hero199527-Apr-07 6:52 
GeneralRe: database CListCtrl Pin
Hamid_RT27-Apr-07 20:07
Hamid_RT27-Apr-07 20:07 
GeneralRe: database CListCtrl Pin
hero199529-Apr-07 15:54
hero199529-Apr-07 15:54 
hey, how can change these code in CDaoDatabase... thanks
void CReadDBDlg::OnRead()
{
// TODO: Add your control notification handler code here
CDatabase database;
CString SqlString;
CString sCatID, sCategory;
CString sDriver = "MICROSOFT ACCESS DRIVER (*.mdb)";
CString sDsn;
CString sFile = "C:\\Documents and Settings\\common.MIT-SGP\\Desktop\\new\\ReadDB\\Test.mdb";
// You must change above path if it's different
int iRec = 0;

// Build ODBC connection string
sDsn.Format("ODBC;DRIVER={%s};DSN='';DBQ=%s",sDriver,sFile);
TRY
{
// Open the database
database.Open(NULL,false,false,sDsn);

// Allocate the recordset
CRecordset recset( &database );

// Build the SQL statement
SqlString = "SELECT CatID, Category "
"FROM Categories";

// Execute the query
recset.Open(CRecordset::forwardOnly,SqlString,CRecordset::readOnly);
// Reset List control if there is any data
ResetListControl();
// populate Grids
ListView_SetExtendedListViewStyle(m_ListControl,LVS_EX_GRIDLINES);

// Column width and heading
m_ListControl.InsertColumn(0,"Category Id",LVCFMT_LEFT,-1,0);
m_ListControl.InsertColumn(1,"Category",LVCFMT_LEFT,-1,1);
m_ListControl.SetColumnWidth(0, 120);
m_ListControl.SetColumnWidth(1, 200);

// Loop through each record
while( !recset.IsEOF() )
{
// Copy each column into a variable
recset.GetFieldValue("CatID",sCatID);
recset.GetFieldValue("Category",sCategory);

// Insert values into the list control
iRec = m_ListControl.InsertItem(0,sCatID,0);
m_ListControl.SetItemText(0,1,sCategory);

// goto next record
recset.MoveNext();
}
// Close the database
database.Close();
}
CATCH(CDBException, e)
{
// If a database exception occured, show error msg
AfxMessageBox("Database error: "+e->m_strError);
}
END_CATCH;
}
GeneralRe: database CListCtrl Pin
David Crow30-Apr-07 2:41
David Crow30-Apr-07 2:41 
AnswerRe: database &CListCtrl Pin
David Crow27-Apr-07 3:17
David Crow27-Apr-07 3:17 
QuestionIXMLHTTPRequest & PKCS#12 certificate Pin
Andy H26-Apr-07 23:21
Andy H26-Apr-07 23:21 
QuestionLinker Error ... Pin
Anamika200526-Apr-07 23:15
Anamika200526-Apr-07 23:15 
Questioninsert variable Pin
dec8226-Apr-07 23:05
dec8226-Apr-07 23:05 
AnswerRe: insert variable Pin
Hamid_RT26-Apr-07 23:24
Hamid_RT26-Apr-07 23:24 
AnswerRe: insert variable Pin
David Crow27-Apr-07 3:24
David Crow27-Apr-07 3:24 
GeneralRe: insert variable Pin
hero199529-Apr-07 21:45
hero199529-Apr-07 21:45 
GeneralRe: insert variable Pin
hero199529-Apr-07 21:48
hero199529-Apr-07 21:48 
QuestionRe: insert variable Pin
David Crow30-Apr-07 2:45
David Crow30-Apr-07 2:45 
QuestionHow to create a dynamic two dimensional array for string? Pin
$uresh $hanmugam26-Apr-07 22:50
$uresh $hanmugam26-Apr-07 22:50 
AnswerRe: How to create a dynamic two dimensional array for string? Pin
Paresh Chitte26-Apr-07 23:02
Paresh Chitte26-Apr-07 23:02 
GeneralRe: How to create a dynamic two dimensional array for string? Pin
$uresh $hanmugam26-Apr-07 23:28
$uresh $hanmugam26-Apr-07 23:28 
AnswerRe: How to create a dynamic two dimensional array for string? Pin
Hamid_RT26-Apr-07 23:05
Hamid_RT26-Apr-07 23:05 
GeneralRe: How to create a dynamic two dimensional array for string? Pin
$uresh $hanmugam26-Apr-07 23:28
$uresh $hanmugam26-Apr-07 23:28 
GeneralRe: How to create a dynamic two dimensional array for string? Pin
Hamid_RT27-Apr-07 0:29
Hamid_RT27-Apr-07 0:29 
AnswerRe: How to create a dynamic two dimensional array for string? Pin
CPallini26-Apr-07 23:07
mveCPallini26-Apr-07 23:07 

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.