Using a Virtual CListView with a Dynaset

This example illustrates how to use an Access database file with an IE 4.0 virtual list view.

Download sample project 63KB.

Loading large amounts of data into a CListView derived class is a very slow process, even when the data is maintained in memory. Accessing data in a database slows the process down even further. One of new features of a list view control is the ability to load data when it is needed. Below are the steps envolved.

You must have a version of COMCTL32.DLL that came with IE 3.0 or later.

Open up you database file.

Use your document object to open your database, and record set. In this example I use a dynaset type recordset. This allows me to set the relative record number of a recordset object's current record by using CDaoRecordSet's SetAbsolutePosition member function. Pass the a pointer to the recordset to your view class in an appropriate manner.


BOOL CVirtualListDoc::OnOpenDocumentFile(LPCTSTR lpszPathname)
{
	CString m_FileName = lpszPathname;
	pDBase = new CDaoDatabase;
	pDBase->Open(m_FileName);
	CString strSQL = "SELECT * FROM TableName ORDER BY ColumnName";//Set up SQL statement
	pRecordSet = new CDaoRecordset(pDBase);
	pRecordSet->Open(dbOpenDynaset, strSQL);//Open recordset using SQL statement
	pRecordSet->MoveLast();//you have to access the records in the dynaset to get GCDaoRecordSet::etRecordCount() to work
}

Set the ListView's style to LVS_OWNERDATA:

BOOL CVirtualListView::PreCreateWindow(CREATESTRUCT& cs)
{
	cs.lpszName = WC_LISTVIEW;
	cs.style &= ~LVS_TYPEMASK;
	cs.style |= LVS_REPORT;
	cs.style |= LVS_EDITLABELS;
	cs.style |= LVS_OWNERDATA;
	CListView::PreCreateWindow(cs);
}

Set number of items in list:

You have to tell the list view how many items it will contain. This is done by sending a LVM_SETITEMCOUNT to the list control. Do this and set up the list views columns in the views OnInitialUpdate() member function. You can send a LVM_SETEXTENDEDLISTVIEWSTYLE message to the control to set any of the new extended listview styles.

void CVirtualListView::OnInitialUpdate()
{
	CListView::OnInitialUpdate();
	/*set number of items in list to number of items in RecordSet*/
	
	/* create image list*/
	imageList.Create(IDB_IMAGELIST, 16, 1, RGB(0,0,0));
	GetListCtrl().SetImageList(&imageList, LVSIL_SMALL);

	/* set extended stlyes*/
	DWORD dwExStyle = LVS_EX_FULLROWSELECT | LVS_EX_GRIDLINES | /*LVS_EX_SUBITEMIMAGES |*/
						LVS_EX_HEADERDRAGDROP | LVS_EX_TRACKSELECT;
	GetListCtrl().SendMessage(LVM_SETEXTENDEDLISTVIEWSTYLE, 0, LPARAM(dwExStyle));
	
	LV_COLUMN lvColumn;
	lvColumn.mask = LVCF_FMT | LVCF_WIDTH | LVCF_TEXT | LVCF_SUBITEM;
	lvColumn.fmt = LVCFMT_LEFT;
	lvColumn.cx = 120;
	for(int i = 0; i < GetFieldCount(); i++) // set up columns
	{
		CDaoFieldInfo fieldinfo;
		pRecordSet->GetFieldInfo(i, fieldinfo);//get field name
		int len = fieldinfo.m_strName.GetLength();
		CString temp = fieldinfo.m_strName;
		TCHAR* szBuffer = new TCHAR[len + 1];
		strcpy(szBuffer, temp.GetBuffer(len));
		temp.ReleaseBuffer();
		lvColumn.pszText = szBuffer;
		GetListCtrl().InsertColumn(i, &lvColumn);//insert column
		delete szBuffer;
	}
	/*set number of items in ListView*/
	count = pRecordSet->GetRecordCount();//Get number of records
	GetListCtrl().SendMessage(LVM_SETITEMCOUNT, (WPARAM)count, (LPARAM)LVSICF_NOINVALIDATEALL);
}

Create a handler to handle LVN_GETDISPINFO messages:

void CVirtualListViewView::OnGetDispInfo(NMHDR* pNMHDR, LRESULT* pResult) 
{
	LV_DISPINFO* pDispInfo = (LV_DISPINFO*)pNMHDR;
	TCHAR szValue[MAX_PATH];
	COleVariant varValue;		
	long index = pDispInfo->item.iItem;
	long subItem = 	pDispInfo->item.iSubItem;
	if(pDispInfo->item.mask & LVIF_TEXT)
	{
		try
		{
			pRecordSet->SetAbsolutePosition(index);//Set the file to desired index
		}
		catch(CDaoException* e)
		{
			return;		
		}
		
		try
		{
			if(subItem)	
				pRecordSet->GetFieldValue(subItem, varValue);
			else
				pRecordSet->GetFieldValue(0, varValue);
		}
		catch(CDaoException* e)
		{
			return;
		}

		const VARIANT* variant = LPCVARIANT(varValue);
		switch(variant->vt)
		{
			case VT_I2:{	wsprintf(szValue, "%d", variant->iVal);
							break;
					   }
			case VT_I4:{	wsprintf(szValue, "%d", variant->lVal);
							break;
					   }
			case VT_R4:{	wsprintf(szValue, "%f", variant->fltVal);
							break;
					   }	
			case VT_R8:{	wsprintf(szValue, "%f", variant->dblVal);
							break;
					   }
			case VT_CY:{	COleCurrency c(varValue);
							CString s = c.Format();//ie. 1.00
							strcpy(szValue, s.GetBuffer(s.GetLength()));
							s.ReleaseBuffer();
							break;
					   }
			case VT_DATE:{	COleDateTime t(variant->date);
							CString s = t.Format( "%A, %B %d, %Y" );//Day of Week, Month Day, Year
							strcpy(szValue, s.GetBuffer(s.GetLength()));
							s.ReleaseBuffer();
							break;
						 }
			case VT_BSTR:{  CString str = V_BSTRT( &varValue );//convert BSTR to CString
							strcpy(szValue, str.GetBuffer(str.GetLength()));
							str.ReleaseBuffer();
							break;
						}
			case VT_BOOL:{	if(variant->boolVal)
								strcpy(szValue, "TRUE");
							else
								strcpy(szValue, "FALSE");
							break;
						 }
			case VT_UI1:{	strcpy(szValue, (char*)variant->bVal);
							break;
						}

			default: break;

		}
		
		lstrcpyn(pDispInfo->item.pszText, szValue, pDispInfo->item.cchTextMax);//set item text
	}
	
	if(pDispInfo->item.mask & LVIF_IMAGE)
		pDispInfo->item.iImage = 0;//set image to first in list

	*pResult = 0;
} 



Comments

  • There are no comments yet. Be the first to comment!

Leave a Comment
  • Your email address will not be published. All fields are required.

Top White Papers and Webcasts

  • With 81% of employees using their phones at work, companies have stopped asking: "Is corporate data leaking from personal devices?" and started asking: "How do we effectively prevent corporate data from leaking from personal devices?" The answer has not been simple. ZixOne raises the bar on BYOD security by not allowing email data to reside on the device. In addition, Zix allows employees to maintain complete control of their personal device, therefore satisfying privacy demands of valued employees and the …

  • Flash technology is becoming more prominent in the storage industry. Offering superior speed and reliability when compared to traditional hard disk drives – flash storage is a flexible and increasingly cost-effective technology that can be used to optimize enterprise storage environments. This ebook explores the many uses and benefits of flash storage technology in the enterprise. Check it out to discover and learn all you need to: Optimize storage performance Leverage server flash as storage cache …

Most Popular Programming Stories

More for Developers

Latest Developer Headlines

RSS Feeds