Database

<br />
CommandPtr pCommand;<br />
//Create the C++ ADO Command Object<br />
pCommand.CreateInstance(__uuidof(Command)); <br />
pCommand->ActiveConnection = this->pConnection;<br />
//Make the ADO C++ command object to accept stored procedure<br />
pCommand->CommandType = CommandTypeEnum::adCmdText;<br />
//Tell the name of the Stored Procedure to the command object<br />
pCommand->CommandText = _bstr_t("select test from Table_1"); <br />
<br />
//get recordset<br />
pRecordset = pCommand->Execute(NULL,NULL,CommandTypeEnum::adCmdText); <br />
BYTE* buffer = NULL;<br />
if(pRecordset != NULL)<br />
{<br />
     while (!pRecordset->GetEndOfFile())<br />
     {<br />
          VARIANT var = pRecordset->Fields->GetItem("test")->Value;<br />
          void * pData = NULL;<br />
          SafeArrayAccessData(var.parray, &pData);<br />
          long size = GetArraySize(var, NULL);<br />
          buffer = new BYTE[size];<br />
          memcpy(buffer, pData, size);<br />
          SafeArrayUnaccessData(var.parray); <br />
          pRecordset->MoveNext();<br />
     }<br />
     pRecordset->Close();<br />
}<br />

<br />
long GetArraySize(const VARIANT& var, long * nElems)<br />
{<br />
     if ( !(var.vt & VT_ARRAY) ) return -1; <br />
<br />
     long size = 0;<br />
     long dims = SafeArrayGetDim(var.parray);<br />
     long elemSize = SafeArrayGetElemsize(var.parray);<br />
     long elems = 1;<br />
     for ( long i=1; i <= dims; i++ )<br />
     {<br />
          long lbound, ubound;<br />
          SafeArrayGetLBound(var.parray, i, &lbound);<br />
          SafeArrayGetUBound(var.parray, i, &ubound);<br />
          elems *= (ubound - lbound + 1);<br />
     }<br />
<br />
     if ( nElems ) *nElems = elems;<br />
     <br />
     size = elems*elemSize;<br />
     return size;<br />
}<br />