求救,菜鸟问题,怎么样从数据库中取出数据并赋值给CString定义的参数

[ronandu]

采用的是MFC ODBC,ACCESS

[mousefj]

一段例子
CRecordset *m_pRecordset;
m_pRecordset=new CRecordset(pDb);
CString m_sSql;
m_sSql.Format("SELECT * FROM MailInfo where mailto like '%%s%'",m_ClientSock->UserInfo.UserName);
m_pRecordset->Open(CRecordset::snapshot,m_sSql);

CString m_sVal;
long m_lData;
CDBVariant m_dbVarVal;
m_pRecordset->GetFieldValue("mailSender",m_sVal);
m_pRecordset->GetFieldValue("mailDate",m_dbVarVal);
m_lData=m_dbVarVal.m_lVal;
char pTmp[32];
_ltoa(m_lData,pTmp,10);

[lazio88]

CString sValue;
_variant_t vValue = 从数据库表中取值
if(vValue.vt == VT_NULL)
sValue = "";
else
sValue = (char *)_bstr_t(vValue);

[ronandu]

等于没说嘛,我就是要问怎么取值的