如何判断读出的纪录某一字段值为空？

[jiaguiyun]

用ADO读出数据，如果这条纪录某一个字段值为空，则进行处理，请问该如何判断？

[abc_rain]

_variant_t vtFld;
vtFld = m_pRecordset->Fields->GetItem(lpFieldName)->Value;
if(vtFld.vt == VT_EMPTY || vtFld.vt == VT_NULL)
{
// TODO: Add your code here


}

[cadinfo]

这是打开记录集之后访问数据的一段代码，希望对你有用：
-------------------------------------------------
try
{
m_pRecordset->MoveFirst();
_variant_t vtHolder1,vtHolder2; CString strName; short nage;
while(m_pRecordset->adoEOF==VARIANT_FALSE)
{
//Retrieve column's value:
vtHolder1=m_pRecordset->GetCollect("name");
if(vtHolder1.vt!=VT_NULL)
strName=(char*)(_bstr_t)vtHolder1;
vtHolder2=m_pRecordset->GetCollect("age");
if(vtHolder2.vt!=VT_NULL)
nage=(short)(_bstr_t)vtHolder2;
//Do something what you want to do:
......
m_pRecordset->MoveNext();
}
}
catch (_com_error &e)
{
::MessageBox(NULL,e.Description(),"提示信息",MB_OK | MB_ICONWARNING);
}

采用的方法是m_pRecordset->GetCollect，注意比较abc_rain提供的m_pRecordset->Fields->GetItem(lpFieldName)->Value，看你喜欢用哪一个了！

[jiaguiyun]

OK!thank you!!!

[jiaguiyun]

多谢两位兄台了。希望以后我再问问题时，两位兄台可要多关照啊！