C / C++ / MFC

Stefan Spenz wrote:

When I try like this if (pManager->bMember)

pManager = new Manager(); // or whatever the class name is

Tara14 wrote:

Is ADO faster than DAO?

Tara14 wrote:

Is that good enough

myListCtrl.SetRedraw(FALSE);

// add items
. . .

myListCtrl.SetRedraw(TRUE);

Viorel. wrote:

If you know the number of items to be added, you can call SetItemCount before.

Viorel. wrote:

Additionally, you can investigate the "virtual list" concept.

void CXBudget::AddPayeeList2()
{
CDBcreate *p = new CDBcreate; // this is the class I have make to handle creating a database, adding tables, adding fields, getting value as double etc ...
	CDaoDatabase *pdB=new CDaoDatabase();
	pdB->Open(path,FALSE,FALSE,pwd);
	CString TabNam = curTableName;
	sql = ("SELECT * FROM "+TabNam+" WHERE param='budget' ORDER BY cat,payee");

	CDaoRecordset *rs;
	rs = new CDaoRecordset(pdB);
	rs->Open(AFX_DAO_USE_DEFAULT_TYPE,sql,NULL);
	CString strCategory, strPayee;
	CString strTp;
	int nFeldCount;
	nCol = 2; ;
	int nRow = 0;
	CString strRowTotal;
	
	m_XBudgetLIST_Main.DeleteAllItems(); // main list
	m_XBudgetLIST_RowTotal.DeleteAllItems();// list on the side of main list to display row total values

	nFeldCount = p->getFieldCount(pdB,strBudgetName);
	while (!rs->IsEOF()) // looping through all the rows of the database
	{
		strCategory = p->GetAsString(rs,1);
		m_XBudgetLIST_Main.InsertItem(nRow,strCategory);
		strPayee = p->GetAsString(rs,2);
		m_XBudgetLIST_Main.SetItemText(nRow,1,strPayee);
		for ( int i = 3;i<nFeldCount;i++)// looping through the columns
		{
			strTp = pCol->SetValue(p->GetAsDouble(rs,i));
			m_XBudgetLIST_Main.SetItemText(nRow,nCol,strTp);
		
			nCol++;
		}
		nCol = 2;
		strRowTotal = pCol->SetValue(Payee_RowTotal(strCategory,strPayee));
		m_XBudgetLIST_RowTotal.InsertItem(nRow,strRowTotal);
		rs->MoveNext();
		nRow++;
	}
	
	pdB->Close();
	rs->Close();
   	delete p;
	delete pdB;
	delete rs;