mfc ado数据库怎么修改数据

#include <atlbase.h> // 包含CComPtr等智能指针
#import "C:\Program Files\Common Files\System\ado\msado15.dll" rename("EOF", "adoEOF") rename("BOF", "adoBOF")

void CYourDialog::UpdateDataInDB()
{
    // 初始化COM库
    ::CoInitialize(NULL);

    try
    {
        // 创建并打开ADO连接
        _ConnectionPtr pConn(__uuidof(Connection));
        pConn->Open("Provider=SQLOLEDB;Data Source=YourServer;Initial Catalog=YourDatabase;Integrated Security=SSPI;");

        // 创建ADO命令对象
        _CommandPtr pCmd(__uuidof(Command));
        pCmd->ActiveConnection = pConn;
        pCmd->CommandText = "UPDATE YourTable SET YourColumn = 'NewValue' WHERE SomeCondition = 'SomeValue'";

        // 执行SQL命令
        pCmd->Execute(NULL, NULL, adCmdText);

        // 关闭连接
        pConn->Close();
    }
    catch (_com_error &e)
    {
        // 处理异常
        CString errMsg;
        errMsg.Format(_T("Error: %s\nDescription: %s"), (LPCTSTR)e.ErrorMessage(), (LPCTSTR)e.Description());
        AfxMessageBox(errMsg);
    }

    // 取消COM库
    ::CoUninitialize();
}