关于VC中如何传递Recordset到ASP中的问题????

[LuoQS1]

VC中如何传递Recordset到ASP,本人在线等候

[masterz]

In your project make sure you import dll to create your ADO classes.



#import "c:\program files\common files\system\ado\msado15.dll" no_namespace rename("EOF", "adoEOF") implementation_only


Next create a method with an [out, retval] property of type _Recordset **


[id(1), helpstring("method GetADORecordset")] HRESULT GetADORecordset( [out, retval] _Recordset **ppRecordset);


Your source code should look something like this:


STDMETHODIMP CReturnADO::GetADORecordset(_Recordset **ppRecordset)
{

_ConnectionPtr pConnection;
_RecordsetPtr pRecordset;

try
{
pConnection.CreateInstance(__uuidof(Connection));
pConnection->CursorLocation = adUseClient; // Important for disconnected sets
pConnection->Open("DSN=SQLSource","loginnmae","password",-1);


pRecordset.CreateInstance(__uuidof(Recordset));
pRecordset->CursorLocation = adUseClient; // Important for disconnected sets

pRecordset->PutRefActiveConnection(pConnection.GetInterfacePtr()); // Associate the connection to this recordset

pRecordset->Open("SELECT DISTINCT name FROM TBLWHATEVER WHERE name IS NOT NULL",vtMissing,
adOpenForwardOnly, adLockReadOnly,
adCmdText);

pRecordset->PutRefActiveConnection(NULL); // Disassociate the connection from the recordset.

if(pConnection->GetState() == adStateOpen)
pConnection->Close();
pConnection = NULL;

*ppRecordset = pRecordset.Detach();

}
catch(_com_error *e)
{
return AtlReportError(CLSID_ReturnADO,e->ErrorMessage(),IID_IReturnADO,E_FAIL);
}
catch(...)
{
return AtlReportError(CLSID_ReturnADO,"Unknown Error.",IID_IReturnADO,E_FAIL);
}

return S_OK;
}
http://www.codeguru.com/mfc_database/disconnectedado.shtml

[LuoQS1]

先谢谢masterz() 我试试

[LuoQS1]

to masterz():
我试了一下发现在idl文件中的接口定义中
[id(5), helpstring("method GetADORecordset")] HRESULT GetADORecordset([out, retval] _Recordset **ppRecordset);
出现如下的编译错误如何解决
syntax error : expecting a type specification near "_Recordset"