recordset

[xianyan519755491]

if(childItem==m_tree.GetSelectedItem())
{

CString str,sql,timeStr,sql2,teneIDStr,sql3;
int dataIDInt;
_variant_t Vtime,VteneID,VdataID;
str = m_tree.GetItemText(childItem);
//AfxMessageBox(str);
sql3 = "select teneID from relation where floorID='";
sql3 += str + "'";
pRst2->Open(sql3.AllocSysString(),_variant_t((IDispatch*)(m_pDBCon->GetActiveConnection()),true),adOpenStatic,adLockOptimistic,adCmdText);
if (pRst2->RecordCount==0)
{
AfxMessageBox("对不起，系统找不到注册用户信息！");
return;
}

pRst2->MoveFirst();
while (!pRst2->EndOfFile)
{
//AfxMessageBox("执行到这里了");
VteneID = pRst2->GetCollect("teneID");
teneIDStr = VteneID.bstrVal;
sql2 = "select max(ID) from data where teneID='";
sql2 += teneIDStr + "'";

pRst3->Open(sql2.AllocSysString(),_variant_t((IDispatch*)(m_pDBCon->GetActiveConnection()),true),adOpenStatic,adLockOptimistic,adCmdText);
VdataID = pRst3->GetCollect("ID");
dataIDInt = VdataID.intVal;
sql = "select data.roomTemp,data.hotVal,data.nowTime,data.state,relation.roomID,room.roomAre from data,room,relation where relation.floorID='";
sql += str + "' and room.roomID=relation.roomID and data.teneID=relation.teneID and data.ID='";
sql += dataIDInt + "'";
pRst->Open(sql.AllocSysString(),_variant_t((IDispatch*)(m_pDBCon->GetActiveConnection()),true),adOpenStatic,adLockOptimistic,adCmdText);
pRst2->MoveNext();

}
m_ctrlDG.SetRefDataSource(NULL);
m_ctrlDG.SetRefDataSource(pRst);
m_ctrlDG.Refresh();




威什么我无法进入“红色语句”标注的循环，pRst2中的数据不为空！

[快乐鹦鹉]

pRst2->EndOfFile的值是什么呢？

[xianyan519755491]

不就是一个Bool值吗？---#import "c:\Program Files\Common Files\System\\ADO\msado15.dll" no_namespace rename("EOF","EndOfFile")

[xianyan519755491]

不好意思哦，我是菜鸟，刚刚接触vc++开发...

[zhhunicorn]

while (!pRst2->adoEOF)
试试这样子.

[onlyliu]

m_pRst2->adoEOF//指针是否在在记录集尾