16,551
社区成员
发帖
与我相关
我的任务
分享
SetStrTable("select 名字 from 456"); //查询表语句
//打开记录表:
if (m_rs->Open(m_strTable,CADORecordset::openUnknown))
{
GetValue();
AfxMessageBox(m_FieldName[m_rs->GetFieldCount()-1]+" 的值为 "+m_Value[m_rs->GetFieldCount()-1]);
m_rs->Open("select * from 456");
GetValue();
AfxMessageBox(m_FieldName[m_rs->GetFieldCount()-1]+" 的值为 "+m_Value[m_rs->GetFieldCount()-1]);
}
BOOL CADOAppDlg::GetValue()
{
if (!m_rs->IsOpen())
{
return false;
}
long cols=m_rs->GetFieldCount(); //取得字段总数
_variant_t var;
m_FieldName.RemoveAll();
m_FieldName.FreeExtra();
m_Value.RemoveAll();
m_Value.FreeExtra();
for (int i=0;i<cols;i++)
{
m_rs->GetFieldInfo(i,&m_FieldInfo); //取得第i项的数据(用CADOFieldInfo)
m_FieldName.Add(m_FieldInfo.m_strName); //把CADOFieldInfo转成CString
m_rs->GetFieldValue(m_FieldName[i],var);
m_Value.Add((LPTSTR)_bstr_t(var));
}
return true;
}