高手相助：vc ado如何实现存储过程？谢谢！！！

同上

解决方案 »

  1.   

    执行SQL语句“exec 存储过程名 参数”
      

  2.   

    _CommandPtr pCommand;
    pCommand.CreateInstance(__uuidof(Command));
    pCommand->ActiveConnection=m_pConnection;
    pCommand->CommandType=adCmdStoredProc;
    pCommand->CommandText=_bstr_t("dbo.indexlock");
    pCommand->Parameters->Append
    (//@point_id_in
    pCommand->CreateParameter
    (
            _bstr_t("@point_id_in"),
    adInteger,
    adParamInput,
    sizeof(short),
    _variant_t(point)
    )
    );
    pCommand->Execute(NULL, NULL, adExecuteNoRecords);

    _ParameterPtr ParOut;

    ParOut=pCommand->Parameters->GetItem(_variant_t("VindexStartindex_out"));
    VindexStartindex=ParOut->Value;