_StreamPtr m_stream;
m_stream.CreateInstance("ADODB.Stream");
_variant_t vtEmpty (DISP_E_PARAMNOTFOUND, VT_ERROR);
m_stream->PutType(adTypeBinary);
m_stream->Open(vtEmpty,adModeUnknown,adOpenStreamUnspecified,L"",L"");
m_stream->LoadFromFile(_bstr_t("d:/1.txt"));
//能够成功加载文件,但是不知道如何将该流添加到数据库的_RecordsetPtr中;
_RecordsetPtr m_pRecordset;
_ConnectionPtr m_pConnection;
m_pConnection.CreateInstance("ADODB.Connection");
m_pRecordset.CreateInstance("ADODB.Recordset");
m_pConnection->Open("DataSource=suixin;UID=;PWD=;","","",adConnectUnspecified);
m_pRecordset->Open("select * from big_number",variant_t((IDispatch*)m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdUnknown);
//想将流存入表big_number中的数据列中;但无法实现
m_pRecordset->Fields("数据")=((char*)(_bstr_t)m_stream->Read(adReadAll));
m_stream.CreateInstance("ADODB.Stream");
_variant_t vtEmpty (DISP_E_PARAMNOTFOUND, VT_ERROR);
m_stream->PutType(adTypeBinary);
m_stream->Open(vtEmpty,adModeUnknown,adOpenStreamUnspecified,L"",L"");
m_stream->LoadFromFile(_bstr_t("d:/1.txt"));
//能够成功加载文件,但是不知道如何将该流添加到数据库的_RecordsetPtr中;
_RecordsetPtr m_pRecordset;
_ConnectionPtr m_pConnection;
m_pConnection.CreateInstance("ADODB.Connection");
m_pRecordset.CreateInstance("ADODB.Recordset");
m_pConnection->Open("DataSource=suixin;UID=;PWD=;","","",adConnectUnspecified);
m_pRecordset->Open("select * from big_number",variant_t((IDispatch*)m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdUnknown);
//想将流存入表big_number中的数据列中;但无法实现
m_pRecordset->Fields("数据")=((char*)(_bstr_t)m_stream->Read(adReadAll));
上面有介绍,他是将图片转化为流,然后保存到SQL
VB6向SQL SERVER存入图象:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;258038
VB.NET向SQL SERVER存入图象:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;308042
C#向SQL SERVER存入图象:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;309158