TR)_bstr_t(varValue);
}else
continue;
m_BanjiList.MyInsertItem(nCount,_T(""),nDianming); //复选框位置名为空
//m_BanjiList.InsertItem(nCount,ruxueNianStr,1);
m_BanjiList.SetItemText(nCount,1,ruxueNianStr);
m_BanjiList.SetItemText(nCount,2,banjiStr);
m_BanjiList.SetItemText(nCount,3,xueqiStr);
varValue=pRecordSet->GetCollect(_T("ID"));
if (varValue.vt!=VT_NULL)
{
nID=_ttoi((LPCTSTR)_bstr_t(varValue));
}else
continue;
if (nID==m_pParentStudentInfo->m_nXueqiID)
{
bSelected=TRUE;
m_BanjiList.SetItemState (nCount,LVIS_SELECTED,LVIS_SELECTED);
}
varValue=pRecordSet->GetCollect(_T("班级ID"));
if (varValue.vt!=VT_NULL)
{
banjiID=_ttoi((LPCTSTR)_bstr_t(varValue));
}
nCount++;
pRecordSet->MoveNext ();
}
if (!bSelected&&nCount>0) //为选择任何项，则默认选择最后一项
{
m_BanjiList.SetItemState (nCount-1,LVIS_SELECTED,LVIS_SELECTED);
m_pParentStudentInfo->m_nXueqiID=nID;
m_pParentStudentInfo->m_nClassID=banjiID;
}
}
catch(_com_error & e)
{
AfxMessageBox(e.ErrorMessage());
}
获得学生信息
_RecordsetPtr pRecordSet;
pRecordSet.CreateInstance(_uuidof(Recordset));
CString recordStr;
recordStr.Format (_T("Select * from 班级表%d order by 学号 "),
m_pParentStudentInfo->m_nClassID);
try{
pRecordSet->Open(
(LPCTSTR)recordStr,
m_pConnection.GetInterfacePtr(),
adOpenDynamic,
adLockOptimistic,
adCmdText
);
if (!pRecordSet->adoBOF)
{
pRecordSet->MoveFirst ();
}else
return; //数据库为空
CString nXuehaoStr;
CString nameStr;
CString addStr;
CString lianxiStr;
CString beizhuStr;
_variant_t varValue;
unsigned nCount=0;
while (!pRecordSet->adoEOF)
{
varValue=pRecordSet->GetCollect(_T("学号"));
if (varValue.vt!=VT_NULL)
{
nXuehaoStr=((LPCTSTR)_bstr_t(varValue));
if (_ttoi(nXuehaoStr)==0)
continue;
}else
continue;
varValue=pRecordSet->GetCollect (_T("姓名"));
if (varValue.vt!=VT_NULL)
{
nameStr=(LPCTSTR)_bstr_t(varValue);
}else
nameStr=L"";
varValue=pRecordSet->GetCollect (_T("地址"));
if (varValue.vt!=VT_NULL)
{
addStr=(LPCTSTR)_bstr_t(varValue);
}else
addStr=L"";
varValue=pRecordSet->GetCollect (_T("联系方式"));
if (varValue.vt!=VT_NULL)
{
lianxiStr=(LPCTSTR)_bstr_t(varValue);
}else
lianxiStr=L"";
varValue=pRecordSet->GetCollect (_T("备注"));
if (varValue.vt!=VT_NULL)
{
beizhuStr=(LPCTSTR)_bstr_t(varValue);
}else
beizhuStr=L"";
m_XueShengList.InsertItem(nCount,nXuehaoStr);
m_XueShengList.SetItemText(nCount,1,nameStr);
m_XueShengList.SetItemText(nCount,2,addStr);
m_XueShengList.SetItemText(nCount,3,lianxiStr);
m_XueShengList.SetItemText(nCount,4,beizhuStr);
nCount++;
pRecordSet->MoveNext ();
}
}
catch(_com_error & e)
{
AfxMessageBox(e.ErrorMessage());
}
?