LisrCtrl Containing a DaoRecordSet

Hi,

Can anyone direct me to sample code or explain how to implement a List Control that shows the content of a CDaoRecordset.

It also needs to allow the user to sort the records by clicking on the apropriate header.

Thanks,

Eli Vingot

[ric]

In the InitDialog() function of your dialog class that contains the listbox, fill the listbox with what is in the recordset. I do this with a work thread, but I will now show it how to do it without a thread and if you cannot do it with thread I will send you the code. Here is the simple way:

BOOL CMyDialog::InitInstance()
{
CListBox* list = (CListBox*)GetDlgItem(IDC_LIST1);
CMyDaoRecordSet set;
set.Open();
while(!set.IsEOF())
{
list->AddString(set.m_FirstField);
set.MoveNext();
}
set.Close();
list = 0;
}

[Marco]

There is a sample at codeguru:
http://www.codeguru.com/advancedui/gfxlist.shtml

That sample is rather complex, I programmed an own CListControl thats working on ODBC, but thats not well documented and not tested with DAO. If youre interested, let me know !

regards, Marco

[Dan Robbins]

I have some code that uses CListCtrlEx- a class I found here at Codeguru to show and manipulate the contents of a CDaoRecordset. If you are interested I could email you the sources. Let me know.

-dan