vc odbc

 CDatabase m_dbAgent;
 m_dbAgent.OpenEx("DSN=EIDSQL;UID=sa;PWD=123456"); 
 CString sql,str;
 //CTime tCurTime;
 CString strCurTime;
 CRecordset *p_rs=new CRecordset;    //定义记录集对象指针 
 p_rs->m_pDatabase=&m_dbAgent;    //使数据库指向m_dbAgent
 sql = _T("select getdate() as CurTime");    //使用集函数查询对象个数
 p_rs->Open(AFX_DB_USE_DEFAULT_TYPE,sql);    //获得有效的查询记录集
 p_rs->GetFieldValue("CurTime",strCurTime);  //取出查询记录集中的数据
 p_rs->Close();
 m_dbAgent.Close();
 delete p_rs;

 

// CUserSet

CUserSet *m_pUserSet;
CUserSet m_UserSet;

IMPLEMENT_DYNAMIC(CUserSet, CRecordset)

CUserSet::CUserSet(CDatabase* pdb)
 : CRecordset(pdb)
{
 //{{AFX_FIELD_INIT(CUserSet)
 m_ID = 0;
 m_PC_IP = _T("");
 m_ProgramVersion = 0;
 m_UserAuthority = 0;
 m_nFields = 4;
 m_pUserSet = &m_UserSet;
 //}}AFX_FIELD_INIT
 m_nDefaultType = dynaset;
}

CString CUserSet::GetDefaultConnect()
{
    return _T("ODBC;DSN=EIDSQL;UID=sa;PWD=123456;"); 
}

CString CUserSet::GetDefaultSQL()
{
 return _T("[dbo].[User1407]");
}

void CUserSet::DoFieldExchange(CFieldExchange* pFX)
{
 //{{AFX_FIELD_MAP(CUserSet)
 pFX->SetFieldType(CFieldExchange::outputColumn);
 RFX_Long(pFX, _T("[ID]"), m_ID);
 RFX_Text(pFX, _T("[PC_IP]"), m_PC_IP);
 RFX_Long(pFX, _T("[ProgramVersion]"), m_ProgramVersion);
 RFX_Long(pFX, _T("[UserAuthority]"), m_UserAuthority);
 //}}AFX_FIELD_MAP
}

/
// CUserSet diagnostics

#ifdef _DEBUG
void CUserSet::AssertValid() const
{
 CRecordset::AssertValid();
}

void CUserSet::Dump(CDumpContext& dc) const
{
 CRecordset::Dump(dc);
}
#endif //_DEBUG