SQL server连接 GetadoEOF()有关问题

SQL server连接 GetadoEOF()问题
_RecordPtr pptr;//定义连接对象
if(pptr.CreateInstance("ADODB.Recordset"))//初始化连接对象
{
AfxMessageBox("Create instance failed!");
}
CString strSRC;
strSRC="Driver=SQL Server;Server=";
strSRC+="127.0.0.1";
strSRC+=";Database=";
strSRC+="db_test";
strSRC+=";uid=sa;pwd=";
strSRC+="111111";
CString strSQL="selete ID,name,Department,jobTitle,knowHow,hobby from student where ID=";
strSQL+=modify_edit1; //modify_edit1为全局的一个CString类型的变量

_variant_t varSRC(strSRC);
_variant_t varSQL(strSQL);

if(FAILED(pptr.Open(varSQL,varSRC,adOpenStatic,adLockOptimistic,adCmdText))) //连接数据库
{
AfxMessageBox("Open table failed!");
pptr->Release();
}

while (!pptr->GetadoEOF())
{
_variant_t varID;
_variant_t varname;
_variant_t varDepartment;
_variant_t varjobTitle;
_variant_t varknowHow;
_variant_t varhobby;

varID=pptr->GetCollect("ID"); //从数据库获取字段
varname=pptr->GetCollect("name");
varDepartment=pptr->GetCollect("Department");
varjobTitle=pptr->GetCollect("jobTitle");
varknowHow=pptr->GetCollect("knowHow");
varhobby=pptr->GetCollect("hobby");

CString strID=(char*)_bstr_t(varID); //获得CString类型
CString strname=(char*)_bstr_t(varname);
CString strDepartment=(char*)_bstr_t(varDepartment);
CString strjobTitle=(char*)_bstr_t(varjobTitle);
CString strknowHow=(char*)_bstr_t(varknowHow);
CString strhobby=(char*)_bstr_t(varhobby);

strID.TrimRight(); //移除空格
strname.TrimRight();
strDepartment.TrimRight();
strjobTitle.TrimRight();
strknowHow.TrimRight();
strhobby.TrimRight();

GetDlgItem(IDC_EDIT5)->SetWindowText(_T(strID));//分别显示在下边的文本框里
GetDlgItem(IDC_EDIT7)->SetWindowText(_T(strname));
GetDlgItem(IDC_EDIT8)->SetWindowText(_T(strDepartment));
GetDlgItem(IDC_EDIT9)->SetWindowText(_T(strjobTitle));
GetDlgItem(IDC_EDIT10)->SetWindowText(_T(strknowHow));
GetDlgItem(IDC_EDIT11)->SetWindowText(_T(strhobby));

------解决方案--------------------
用while (!pptr->adoEOF)调试一下 应该可以