16,471
社区成员
发帖
与我相关
我的任务
分享
_CommandPtr spCommand;
spCommand.CreateInstance( __uuidof( Command ) );
spCommand->ActiveConnection = m_pConnection;
spCommand->CommandText = _bstr_t("spAddtbRepository");
spCommand->CommandType = adCmdStoredProc;
// 下面的代码是创建存储过程的参数
// 根据你的实际情况进行修改
_ParameterPtr spParam;
spParam = spCommand->CreateParameter( _bstr_t("@param1"), ADODB::adLongVarChar, ADODB::adParamInput, strProgramCode.GetLength() + 1);
BSTR bstr = strProgramCode.AllocSysString();
spParam->Value = _variant_t( bstr );
::SysFreeString(bstr);
spCommand->Parameters->Append( spParam );
//
_ParameterPtr spParam1;
spParam1 = spCommand->CreateParameter( _bstr_t("@param2"), ADODB::adLongVarChar, ADODB::adParamInput, strChnID.GetLength() + 1);
bstr = strChnID.AllocSysString();
spParam1->Value = _variant_t( bstr );
::SysFreeString(bstr);
spCommand->Parameters->Append( spParam1 );
// 执行存储过程
_RecordsetPtr pRet = spCommand->Execute( NULL, NULL, adCmdStoredProc );