如何将下面代码合并，在数据库中把员工基本信息和照片存放在同一行
UpdateData(TRUE);
CoInitialize(NULL);
ConnectionPtr pConn(_uuidof(Connection));
RecordsetPtr pRst(_uuidof(Recordset));
pConn->ConnectionString=(_T("Provider=SQLOLEDB.1;User ID=sa;Password=123456;Persist Security Info=True;Data Source=localhost;Initial Catalog=test"));
pConn->Open(_T(""),_T(""),_T(""),adConnectUnspecified);
CString sqlstr;
sqlstr.Format(_T("insert into information(id,house,source) values ('%s','%s', '%s')"),str,str1,str2);
pRst=pConn->Execute((_bstr_t)sqlstr,NULL,adCmdText);
上面是员工基本信息存放数据库
下面是员工照片存放数据库
UpdateData(TRUE);
CoInitialize(NULL);
ConnectionPtr pConn(_uuidof(Connection));
RecordsetPtr pRst(_uuidof(Recordset));
pConn->ConnectionString=(_T("Provider=SQLOLEDB.1;User ID=sa;Password=123456;Persist Security Info=True;Data Source=localhost;Initial Catalog=test"));
pConn->Open(_T(""),_T(""),_T(""),adConnectUnspecified);
pRst->Open("SELECT * FROM dbo.cow_information",_variant_t((IDispatch*)pConn),adOpenStatic,adLockOptimistic,adCmdText);
pRst->AddNew();
pRst->Fields->GetItem("id")->Value=(_variant_t)m_cid;//jpgid
VARIANT pvList;
SetPictureToVariant(pvList,(unsigned char *)m_pJPGBuffer);
pRst->Fields->GetItem("photos")->AppendChunk(pvList); //JPG图像文件
VariantClear(&pvList);
pRst->Update();
pRst->Close();
UpdateData(false);
AfxMessageBox(_T("JPG图像保存成功！"));
在数据库中显示如下：