CListCtrl m_listLinkInfo;
/////////////////////////////////
// TODO: Add extra initialization here
m_listLinkInfo.SetExtendedStyle(LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT);
int i=0;
m_listLinkInfo.InsertColumn(i++, "姓名", LVCFMT_LEFT, 90);
m_listLinkInfo.InsertColumn(i++, "电话", LVCFMT_LEFT, 90);
m_listLinkInfo.InsertColumn(i++, "邮件", LVCFMT_LEFT, 100);
m_listLinkInfo.InsertColumn(i++, "地址", LVCFMT_LEFT, 120);
m_listLinkInfo.InsertColumn(i++, "邮编", LVCFMT_LEFT, 90);
m_listLinkInfo.InsertColumn(i++, "ID", LVCFMT_LEFT, 0);
/////////////////////////////////////////
m_listLinkInfo.DeleteAllItems();
int i=0, j=0;
CString strTmp;
while(!m_pRecordset->adoEOF)
{
var = m_pRecordset->GetCollect("Name"); //获取Name字段的值
if(var.vt != VT_NULL)
strTmp = (LPCSTR)_bstr_t(var);
m_listLinkInfo.InsertItem(i, strTmp);
var = m_pRecordset->GetCollect("Phone"); //获取Phone字段的值
if(var.vt != VT_NULL)
strTmp = (LPCSTR)_bstr_t(var);
m_listLinkInfo.SetItemText(i, ++j, strTmp);
var = m_pRecordset->GetCollect("Email");//获取Email字段的值
if(var.vt != VT_NULL)
strTmp = (LPCSTR)_bstr_t(var);
m_listLinkInfo.SetItemText(i, ++j, strTmp);
var = m_pRecordset->GetCollect("Address");//获取Address字段的值
if(var.vt != VT_NULL)
strTmp = (LPCSTR)_bstr_t(var);
m_listLinkInfo.SetItemText(i, ++j, strTmp);
var = m_pRecordset->GetCollect("Postcode"); //获取Postcode字段的值
if(var.vt != VT_NULL)
strTmp = (LPCSTR)_bstr_t(var);
m_listLinkInfo.SetItemText(i, ++j, strTmp);
var = m_pRecordset->GetCollect("PersonID"); //获取PersonID字段的值
if(var.vt != VT_NULL)
strTmp = (LPCSTR)_bstr_t(var);
m_listLinkInfo.SetItemText(i, ++j, strTmp);
i++;
j=0;
m_pRecordset->MoveNext(); //记录集指针移动到下一条记录
}
///////////////////////////////////////////////
POSITION pos;
int iPos;
CString strPersonID;
pos = m_listLinkInfo.GetFirstSelectedItemPosition();
if (pos == NULL)
{
::MessageBox(NULL, "请选择要删除的记录!", "通信录",
MB_OK|MB_ICONINFORMATION|MB_TASKMODAL);
return;
}
if(AfxMessageBox("真的要删除该记录吗?", MB_ICONQUESTION | MB_YESNO|MB_DEFBUTTON2) == IDNO)
return;
iPos = m_listLinkInfo.GetNextSelectedItem(pos);
strPersonID = m_listLinkInfo.GetItemText(iPos, 5); //获取要删除用户的ID
///////////////////////////////////////
POSITION pos;
int iPos;
pos = m_listLinkInfo.GetFirstSelectedItemPosition();
if (pos == NULL)
{
AfxMessageBox("请选择要修改的记录!");
return;
}
iPos = m_listLinkInfo.GetNextSelectedItem(pos);
dlg.m_strName = m_listLinkInfo.GetItemText(iPos, 0);
dlg.m_strPhone = m_listLinkInfo.GetItemText(iPos, 1);
dlg.m_strEmail = m_listLinkInfo.GetItemText(iPos, 2);
dlg.m_strAddress = m_listLinkInfo.GetItemText(iPos, 3);
dlg.m_strPostcode = m_listLinkInfo.GetItemText(iPos, 4);
dlg.m_strPersonID = m_listLinkInfo.GetItemText(iPos, 5);
///////////////////////////////////////////
CListCtrl用法
最新推荐文章于 2019-05-28 14:04:48 发布