64,682
社区成员
发帖
与我相关
我的任务
分享
_CommandPtr pCommand;
pCommand.CreateInstance(__uuidof(Command));
pCommand->CommandText = "proc_EventLog";
pCommand->CommandType = adCmdStoredProc;
_ParameterPtr partype = pCommand->CreateParameter("type", adBSTR, adParamInput, 255, _variant_t(""));
_ParameterPtr partime = pCommand->CreateParameter("time", adDate, adParamInput, 255, _variant_t(""));
_ParameterPtr parname = pCommand->CreateParameter("name", adBSTR, adParamInput, 255, _variant_t(""));
_ParameterPtr parEvent1 = pCommand->CreateParameter("event1", adBSTR, adParamInput, 255, _variant_t(""));
_ParameterPtr parEvent2 = pCommand->CreateParameter("event2", adBSTR, adParamInput, 255, _variant_t(""));
pCommand->Parameters->Append(partype);
pCommand->Parameters->Append(partime);
pCommand->Parameters->Append(parname);
pCommand->Parameters->Append(parEvent1);
pCommand->Parameters->Append(parEvent2);
do something....
_variant_t vType("type"),
vUser("user"),
vTime("2011-02-02 02:02:02"),
vName("name"),
vEvent("1");
pCommand->Parameters->Item["@type"]->Value = vType;
pCommand->Parameters->Item["@time"]->Value = vTime;
pCommand->Parameters->Item["@name"]->Value = vName;
pCommand->Parameters->Item["@event1"]->Value = vUser;
pCommand->Parameters->Item["@event2"]->Value = vEvent;