第九章9.txt

本书在复习C++基础知识后

void CEx_A9View::DispAllRec()
{
	CListCtrl& m_ListCtrl = GetListCtrl();
	// 删除列表中所有行和列表头
	m_ListCtrl.DeleteAllItems();
	int nColumnCount = m_ListCtrl.GetHeaderCtrl()->GetItemCount();
	for (int i=0; i<nColumnCount; i++)
		m_ListCtrl.DeleteColumn(0);

	_CommandPtr pCmd;
	pCmd.CreateInstance(__uuidof(Command));			// 初始化Command指针
	pCmd->ActiveConnection = m_pConnection;			// 指向已有的连接
	CString strText = "SELECT * FROM student ORDER BY studentno";
	pCmd->CommandText = _bstr_t(strText);

	_RecordsetPtr pSet;
	pSet.CreateInstance(__uuidof(Recordset));	// 初始化Recordset指针
	pSet = pCmd->Execute(NULL, NULL, adCmdText );	
	// 建立列表控件的列表头
	FieldsPtr flds = pSet->GetFields();			// 获取当前表的字段指针
	_variant_t Index;
	Index.vt = VT_I2;
	m_ListCtrl.InsertColumn(0, "序号", LVCFMT_LEFT, 40 );
	for (i = 0; i < (int)flds->GetCount(); i++)   
{
		Index.iVal=i;
		int nWidth = flds->GetItem(Index)->GetDefinedSize()*9;
		if ( nWidth < 40 ) nWidth = 40;
		m_ListCtrl.InsertColumn(i+1, (LPSTR)flds->GetItem(Index)->GetName(), 
			LVCFMT_LEFT,  nWidth);
	}
	// 显示记录
	_bstr_t str, value;
	int nItem = 0;
	CString strItem;
	while(!pSet->adoEOF){
		strItem.Format("%d", nItem+1);
		m_ListCtrl.InsertItem(nItem, strItem );
		for (i = 0; i < (int)flds->GetCount(); i++)  
{
			Index.iVal=i;
			str = flds->GetItem(Index)->GetName();
			value = pSet->GetCollect(str);
			m_ListCtrl.SetItemText( nItem, i+1, (LPCSTR)value );
		}
		pSet->MoveNext();
		nItem++;
	}
	pSet->Close();	
}