转载请注明出处——(作者:王晖)http://blog.csdn.net/wangminjing/archive/2008/09/14/2927637.aspx
CListCtrl m_list;
//初始m_list的数据表
void CMyDlg::ChuShiLie()
{
//插入三个列,分别是“身份证号”、“姓名”、“职务”
m_list.InsertColumn(0,"身份证号",LVCFMT_CENTER,18*4);
m_list.InsertColumn(1,"姓名",LVCFMT_CENTER,18*2);
m_list.InsertColumn(2,"职务",LVCFMT_CENTER,18*2);
//设置m_list的颜色,及文字颜色,并设置其选择方式
m_list.SetBkColor(RGB(192,192,192));
m_list.SetTextColor(RGB(128,0,0));
m_list.SetTextBkColor(RGB(192,192,192));
m_list.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES|LVS_EX_HEADERDRAGDROP);
}
//刷新数据,将数据显示到m_list控件内。
void CMyDlg::Refresh()
{
//删除m_list的原内容
m_list.DeleteAllItems();
m_pRecordset.CreateInstance("ADODB.Recordset");
m_pRecordset->Open("SELECT * FROM cbjxmd order by 身份证证 ASC",_variant_t((IDispatch *)m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
_variant_t Holder;
CString str;
if(0==m_pRecordset->GetRecordCount())
return;
while(!m_pRecordset->EOF)
{
Holder=m_pRecordset->GetCollect("身份证号");
str=Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_list.InsertItem(i,str);
Holder=m_pRecordset->GetCollect("姓名");
str=Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_list.SetItemText(i,1,str);
Holder=m_pRecordset->GetCollect("职务");
str=Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_list.SetItemText(i,2,str);
m_pRecordset->MoveNext();
}
}