MFC连接Sqlserver

 

下载 ado2.h和ado2.cpp文件

 

在VC++ 目录-->包含目录 -->添加  msado15.dll, msjro.dll 目录。

 

// TODO: 连接sqlserver， 在stdafx.h 中定义这些，
#define _BS_DLL_EXPORT_
# ifdef _BS_DLL_EXPORT_
# define BS_DLL_EXPORT __declspec(dllexport)
# else
# define BS_DLL_EXPORT __declspec(dllimport)
# endif

 

连接sqlserver数据库
bool connectToSqlServer()
{
    CADODatabase *g_pAdoDatabase;
    try{
        if (g_pAdoDatabase == NULL)
                g_pAdoDatabase = new CADODatabase();

        CString strConnString = "Provider=SQLOLEDB;Persist Security Info=False;Data Source=" + \
            strServer + ";Initial Catalog=" + strDatabase + ";User Id=" + strUser + ";Password=" + strPwd;

        g_pAdoDatabase->SetConnectionString((LPCTSTR)strConnString);
    }
    catch (...)
    {
        return false;
    }
    return true;
}

 

if(g_pAdoDatabase->Open())
{
        // 查询
        CString sqlText = "select ...";
         
        CADORecordset* pRs = new CADORecordset(g_pAdoDatabase);

        if(pRs->Open((LPCTSTR)sqlText))
        {
            while (!pRs->IsEof())
            {
                pRs->GetFieldValue("id", ID);
                pRs->MoveNext();
            }
        }
        pRs->Close();
        delete pRs;        
}
catch (...)
{
    return false;
}

if(g_pAdoDatabase->IsOpen())
{
    g_pAdoDatabase->Close();
}