_variant_t v_Team_no,v_Team_name,v_Team_coach,v_Team_home;
sql = "SELECT * FROM Team";//"SELECT * FROM Team WHERE Team_Cname='";
//sql += m_Team_name;
//sql += "'";
CSoccerLab2Dlg dlg = (CSoccerLab2Dlg *)GetParent()->GetParent();
dlg->m_pRecordset->Close();///关闭记录集
dlg->m_pRecordset->Open((_variant_t)sql,_variant_t((IDispatch)dlg->m_pConnection,true),
adOpenStatic,adLockOptimistic,adCmdText);
int i = dlg->m_pRecordset->GetRecordCount();
if (dlg->m_pRecordset->GetRecordCount() != 0) //表中有记录
{
dlg->m_userlist.DeleteAllItems();
try{
v_Team_no = dlg->m_pRecordset->GetCollect("Team_no");
v_Team_name = dlg->m_pRecordset->GetCollect("Team_Cname");
v_Team_home = dlg->m_pRecordset->GetCollect("Team_home");
v_Team_coach = dlg->m_pRecordset->GetCollect("Team_coach");
}
catch(_com_error& e)
{
dump_com_error(e);
}
nItem=dlg->m_userlist.InsertItem(0xffff,(_bstr_t)v_Team_no);
dlg->m_userlist.SetItem(nItem,1,1,(_bstr_t)v_Team_name,NULL,0,0,0);
dlg->m_userlist.SetItem(nItem,2,1,(_bstr_t)v_Team_home,NULL,0,0,0);
dlg->m_userlist.SetItem(nItem,3,1,(_bstr_t)v_Team_coach,NULL,0,0,0);
dlg->m_pRecordset->MoveNext();
dlg->m_userlist.SetItemState(dlg->m_nCurrentSel,LVIS_SELECTED|LVIS_FOCUSED,LVIS_SELECTED|LVIS_FOCUSED);
dlg->m_userlist.SetFocus();
}
代码如上,写成select * from Team是因为查询得到的结果m_pRecordset里面明明有22个数据,但是插入的时候为什么只有一条数据插入到了listcontrol里面
求解