MFC连接SQL Server数据库,操作步骤:1、在stdafx.h中加入 #import "C:/Program Files/Common Files/System/ado/msado15.dll" no_namespace rename("EOF","adoEOF") 2、在APP中的InitInstance()中,写 AfxEnableControlContainer(); ::CoInitialize(NULL); HRESULT hr; hr = m_pConnection.CreateInstance(__uuidof(Connection));//创建Connection对象 try { m_pConnection->PutCursorLocation(adUseClient); _bstr_t strSQL="Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=sa;Initial Catalog=pubs;Data Source=ZJYSUN;"; if(SUCCEEDED(hr)) { hr=m_pConnection->Open(strSQL,"","",-1); } } catch(_com_error e)///捕捉异常 { ::CoUninitialize(); ::AfxMessageBox(e.ErrorMessage()); return FALSE; } 3、与DataGrid控件绑定UpdateData(TRUE); m_pRecordset.CreateInstance("ADODB.Recordset"); CString strSQL="exec return_result";//执行存储过程; m_pRecordse