VC数据库变量引用问题 (刚刚没分，重发

[mxgd123]

#pragma once
#include <iostream>


#import "C:\Program Files\Common Files\System\ado\msado15.dll" no_namespace rename("EOF","rsEOF")
using namespace std;


#include "stdafx.h"

int main(){

_ConnectionPtr m_pConnection;

CoInitialize(NULL);

m_pConnection.CreateInstance(__uuidof(Connection));

try
{
m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db1.mdb","","",adModeUnknown);

}
catch(_com_error e)
{
cout < <"数据库连接失败，确认数据库db1.mdb是否在当前路径下!" < <endl;
return FALSE;
}
_RecordsetPtr m_pRecordset;

m_pRecordset.CreateInstance(__uuidof(Recordset));
try
{
m_pRecordset->Open("SELECT * FROM users",
m_pConnection.GetInterfacePtr(),
adOpenDynamic,
adLockBatchOptimistic,
adCmdText);
}
catch(_com_error *e)
{

cout < <e->ErrorMessage() < <endl;
}


int IDa,olda;
char usernamea,sexa;
IDa=11;
olda=12;
usernamea='j';
sexa='M';
_variant_t RecordsAffected;


_CommandPtr m_pCommand;
_variant_t vNULL;
vNULL.vt = VT_ERROR;
vNULL.scode = DISP_E_PARAMNOTFOUND;


m_pCommand.CreateInstance ("ADODB.Command");
m_pCommand->ActiveConnection =m_pConnection;
m_pCommand->CommandText = "(_bstr_t)strSQL";
m_pCommand->CommandText ="SELECT*FROM users";

m_pCommand->CommandText ="Insert INTO users(ID,username,old,sex)VALUES('"+IDa+"',1,1,1)";
m_pCommand->Execute (&vNULL,&vNULL,adCmdText);
if(m_pConnection->State)
m_pConnection->Close();
m_pConnection= NULL;
return 0;
}


出现错误：error C2110: cannot add two pointers
求高手指教

[liuchaotao]

m_pCommand->CommandText ="Insert INTO users(ID,username,old,sex)VALUES('"+IDa+"',1,1,1)";
两个字符串怎么相加?
LZ大概是从VB转过来的吧?

[mxgd123]

变量的引用啊。。。其实我是新手，不太懂。。。现在我要把指点的变量数据，存进数据库，但是一引用变量就有问题，不知道为什么

[Conry]

char sql[512];

sprintf(sql,"Insert INTO users(ID,username,old,sex)VALUES(' %s ',1,1,1",IDa);

m_pCommand->CommandText =sql;//不清楚CommandText什么类型，这里只是示意

[见习学术士]

LZ可以定义一个变量
CString strSql;
然后把SQL语句格式化到strSql就好了。
strSql.Format("insert into users(id,username,old,sex) values('%s',1,1,1)",IDa);

[shakeyou123]

定义一个cstring变量，cstring可以进行+的，把你的sql语句放在cstring 里就OK了

[flyoxs]

CString strSql;
strSql.Format("insert into users(id,username,old,sex) values('%d',1,1,1)",IDa);

[LPR_Pro]

CString strQL;
strSQL.Format("insert into users(id,username,old,sex) values('%d',1,1,1)",IDa);
m_pCommand->CommandText = strSQL;
或者
m_pCommand->CommandText = (LPSTR) strSQL.GetBuffer();