连接数据库
BOOL COutpatientSVEApp::InitInstance()
{
........
::CoInitialize(NULL);
AfxOleInit();
m_pConnection.CreateInstance("ADODB.Connection");
try
{
//m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;DataSource=Demo.mdb","","",adModeUnknown);
m_pConnection->Open("Provider=SQLOLEDB.1;Data Source=211.66.26.176;Initial Catalog==r;UID=sa;PWD=sa","","",adModeUnknown);
}
catch(_com_error e)
{
AfxMessageBox("出错");
return FALSE;
}.........
}
void CShoukuandlg::Count()
{ m_pConnection=theApp.m_pConnection; try
{
m_pRecordset->Open("SELECT * FROM r", // ²éѯDemoTable±íÖÐËùÓÐ×Ö¶Î
(IDispatch*)m_pConnection, // »ñÈ¡¿â½Ó¿âµÄIDispatchÖ¸Õë
adOpenDynamic,
adLockOptimistic,
adCmdText);
}
catch(_com_error *e)
{
AfxMessageBox(e->ErrorMessage());
} _variant_t var;
_variant_t RecordsAffected;
CString value;
CString string;
try
{// m_Lshuju.SetHeadings(_T(value));
//¶ÁÊý¾Ý
m_pRecordset->MoveFirst(); while(!m_pRecordset->adoEOF)
{
// m_MyListCtrl.AddItem(_T("1"),_T("èïÒåÃ÷"),_T("1979-07-25"));
// int j=0;
var=m_pRecordset->Fields->Item[_variant_t(long(1))]->Value; string=Format(var);
if(string==stringXingming)
{
m_pRecordset->Close();
m_pParent->dlgShoukuan=NULL;
DestroyWindow();
return;
} m_pRecordset->MoveNext(); } m_pRecordset->MovePrevious();
m_pConnection->Execute("INSERT INTO rr(jiuzhanghao,xingming,xingbie,nianling,dizhi) VALUES (222, ""Washington"",""男"",1,""广州"")",&RecordsAffected,adCmdText);
//jiuzhanghao(int),xingming(text),xingbie(text),nianling(int),dizhi(text)
// m_pRecordset->PutCollect("jiuzhanghao", _variant_t(long(11)));
m_pRecordset->Close(); }
catch(_com_error *e)
{
AfxMessageBox(e->ErrorMessage());
}
// m_pParent->dlgShoukuan=NULL;
// DestroyWindow();
}他说这里出错m_pConnection->Execute请问是什么错误 谢谢那位高手能帮我看看 谢谢
BOOL COutpatientSVEApp::InitInstance()
{
........
::CoInitialize(NULL);
AfxOleInit();
m_pConnection.CreateInstance("ADODB.Connection");
try
{
//m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;DataSource=Demo.mdb","","",adModeUnknown);
m_pConnection->Open("Provider=SQLOLEDB.1;Data Source=211.66.26.176;Initial Catalog==r;UID=sa;PWD=sa","","",adModeUnknown);
}
catch(_com_error e)
{
AfxMessageBox("出错");
return FALSE;
}.........
}
void CShoukuandlg::Count()
{ m_pConnection=theApp.m_pConnection; try
{
m_pRecordset->Open("SELECT * FROM r", // ²éѯDemoTable±íÖÐËùÓÐ×Ö¶Î
(IDispatch*)m_pConnection, // »ñÈ¡¿â½Ó¿âµÄIDispatchÖ¸Õë
adOpenDynamic,
adLockOptimistic,
adCmdText);
}
catch(_com_error *e)
{
AfxMessageBox(e->ErrorMessage());
} _variant_t var;
_variant_t RecordsAffected;
CString value;
CString string;
try
{// m_Lshuju.SetHeadings(_T(value));
//¶ÁÊý¾Ý
m_pRecordset->MoveFirst(); while(!m_pRecordset->adoEOF)
{
// m_MyListCtrl.AddItem(_T("1"),_T("èïÒåÃ÷"),_T("1979-07-25"));
// int j=0;
var=m_pRecordset->Fields->Item[_variant_t(long(1))]->Value; string=Format(var);
if(string==stringXingming)
{
m_pRecordset->Close();
m_pParent->dlgShoukuan=NULL;
DestroyWindow();
return;
} m_pRecordset->MoveNext(); } m_pRecordset->MovePrevious();
m_pConnection->Execute("INSERT INTO rr(jiuzhanghao,xingming,xingbie,nianling,dizhi) VALUES (222, ""Washington"",""男"",1,""广州"")",&RecordsAffected,adCmdText);
//jiuzhanghao(int),xingming(text),xingbie(text),nianling(int),dizhi(text)
// m_pRecordset->PutCollect("jiuzhanghao", _variant_t(long(11)));
m_pRecordset->Close(); }
catch(_com_error *e)
{
AfxMessageBox(e->ErrorMessage());
}
// m_pParent->dlgShoukuan=NULL;
// DestroyWindow();
}他说这里出错m_pConnection->Execute请问是什么错误 谢谢那位高手能帮我看看 谢谢
解决方案 »
- _beginthreadex 编译问题
- 编程连接一个IPsec的vpn,大概都需要什么步骤?
- DLL导出函数 与 extern "C"的小问题 (小白的初级问题)
- 关于两张声卡间数据传送!
- 请各位指教:我在复制磁盘目录(比如把D:\\下面的内容考到C:\\Dir\\下面),为什么SHFileOperation一复制就说磁盘或者目录错误
- 关于VC调用VB的动态库问题!急!!!
- DX背景下,用户输入ID和密码的框怎么做?
- 希望和各位熟悉DirectX或MFC ActiveX编程的朋友交个朋友
- VC的问题:用ADO连接数据库?
- 关于中文的问题,请关注!!有点深度的!!多字节,unicode....
- 如何把CString转化为int,还有如何把int转化为CString?
- 高分请教,怎么把数据中binary字符串,转化为0x开头的16进制形式的字符串?
改成这样试试:m_pConnection->Execute("INSERT INTO (jiuzhanghao,xingming,xingbie,nianling,dizhi) VALUES (222, 'Washington','男',1,'广州')",&RecordsAffected,adCmdText);
建议楼主修改sql语句的写法。