oledb.txt

来自「这是一个基于COM的数据库访问技术」· 文本 代码 · 共 27 行

CDataSource ds;
ds.Open(...); // Setup data source

CSession session;
session.Open(ds);

CDynamicCommand<CDynamicAccessorEx> cmd;
cmd.SetCommandTemplate(
    _T("SELECT Telephone, Mobile, Fax, Email FROM Person "
       "WHERE FirstName LIKE ?"));
cmd.SetParamValue(0, "A%");
cmd.Open(session);

HRESULT hr = cmd.MoveFirst(); 
while(S_OK == hr) {
    CString strTel, strMob, strFax, strEmail;

    cmd.GetValue(_T("Telephone"), &strTel);
    cmd.GetValue(1, &strMob);
    cmd.GetValue(_T("Fax"), &strFax);
    cmd.GetValue(4, &strEmail);

    DoSomething(strTel, strMob, strFace, strEmail);
    hr = cmd.MoveNext();
}
cmd.Close();