ole db动态写blob类型数据

[hz张三]

动态写。就是直接使用sql语句的那种。

[PiggyXP]

// 这样就OK了 pBuf 存储图片内容，p_nLen式长度^_^

void AddImage( BYTE* pBuf,const int p_nLen)
{
try
{
VARIANT varBLOB;
SAFEARRAY *psa;
SAFEARRAYBOUND rgsabound[1];
if(pBuf)
{
rgsabound[0].lLbound = 0;
rgsabound[0].cElements = p_nLen;
psa = SafeArrayCreate(VT_UI1, 1, rgsabound);
for (long i = 0; i < (long)p_nLen; i++)
SafeArrayPutElement (psa, &i, pBuf++);
varBLOB.vt = VT_ARRAY | VT_UI1;
varBLOB.parray = psa;
m_pImageRecordset->GetFields()->GetItem("pic")->AppendChunk(varBLOB);
}
m_pImageRecordset->Update();
}
catch(_com_error e)
{
CString errormsg;
errormsg.Format("image失败\r\n信息：%s",e.ErrorMessage());
AfxMessageBox(errormsg);
return;
}
}