vc可以绑定数据库的控件

#include <afxdb.h>

void CMyDialog::DoDataExchange(CDataExchange* pDX)
{
    CDialogEx::DoDataExchange(pDX);
    DDX_Control(pDX, IDC_LIST1, m_ListCtrl);
}

BOOL CMyDialog::OnInitDialog()
{
    CDialogEx::OnInitDialog();

    // 连接数据库
    CDatabase db;
    CString strConnection = _T("ODBC;DSN=mydsn;UID=myuser;PWD=mypassword");
    if (!db.OpenEx(strConnection, CDatabase::noOdbcDialog))
    {
        AfxMessageBox(_T("无法连接到数据库"));
        return FALSE;
    }

    // 执行查询
    CRecordset rs(&db);
    rs.Open(CRecordset::forwardOnly, _T("SELECT * FROM mytable"));

    // 绑定数据到控件
    m_ListCtrl.InsertColumn(0, _T("ID"), LVCFMT_LEFT, 100);
    m_ListCtrl.InsertColumn(1, _T("Name"), LVCFMT_LEFT, 150);

    int nIndex = 0;
    while (!rs.IsEOF())
    {
        CString strID, strName;
        rs.GetFieldValue(_T("ID"), strID);
        rs.GetFieldValue(_T("Name"), strName);
        m_ListCtrl.InsertItem(nIndex, strID);
        m_ListCtrl.SetItemText(nIndex, 1, strName);
        rs.MoveNext();
        nIndex++;
    }

    rs.Close();
    db.Close();

    return TRUE;
}