请问:如何用ADO执行存储过程并返回OUTPUT值及记录集

[asoftcn]

CAdoCommand m_adoCommand;
m_adoCommand.SetConnection(&m_adoConnection);
m_adoCommand.SetCommandType(adCmdStoredProc);
m_adoCommand.SetCommandText("PROC_USER_CHECKUSERA");
_ParameterPtr param;
//////////////////////////////////////////////////////
param =m_adoCommand.CreateParameter("UserCode",adBigInt, adParamInput,sizeof(long),_variant_t("100000"));

m_adoCommand.Append(param);
param=m_adoCommand.CreateParameter("IsPass",adBigInt, adParamOutput, sizeof(long),(long)(0));
m_adoCommand.Append(param);

CAdoRecordSet m_adoRecordSet
m_adoRecordSet = m_adoCommand.Execute(adCmdStoredProc);
long b=(long)m_adoCommand.GetParameters()->GetItem("IsPass")->GetValue();

结果m_adoRecordSet 记录集能得到但IsPass返回值b得不到,如果将执行语句改成:
m_adoCommand.Execute(adCmdStoredProc); 直接执行,那么IsPass返回值b就能正确的得到
请问各高手,这是什么问题如何处理!

[asoftcn]

帮助三!

[wxp]

我有用VC2003条通的例子,但你的信誉太低,能保证给分吗?

[hydra2004]

先关闭记录集，就可以取到output参数了