//获得连接数据库的ip,服务名,用户,密码
GetPropParam();
//连接pdm数据库
if (!m_pdmDB.DBConnection(strPdmIP,strPdmName,strPdmUser,strPdmPwd))//连接数据库
{
m_bConnectSucess=FALSE;
AfxMessageBox(_T("连接PDM数据库失败!"));
return ;
}
AfxMessageBox(_T("连接PDM数据库成功!"));
m_bConnectSucess=TRUE;
CString str_mSql;
str_mSql=_T("select * from table where ID=1");
_RecordsetPtr pdmRecordSet;//执行的sql语句包含要写入的字段
pdmRecordSet=m_pdmDB.ExecuteSql(str_mSql);
if (!pdmRecordSet->BOF)
{
while(!pdmRecordSet->adoEOF)
{
_StreamPtr pStream;
pStream.CreateInstance("ADODB.Stream");
variant_t varOptional(DISP_E_PARAMNOTFOUND,VT_ERROR);
pStream->PutType(adTypeBinary);
pStream->Open( varOptional,
adModeUnknown, adOpenStreamUnspecified, _bstr_t(), _bstr_t());
pStream->LoadFromFile("c:\\text1.txt");//读入文件
variant_t varBLOB=pStream->Read(adReadAll);
pdmRecordSet->GetFields()->GetItem("NCFile")->Value= varBLOB;
// pdmRecordSet->MoveNext();
}
GetPropParam();
//连接pdm数据库
if (!m_pdmDB.DBConnection(strPdmIP,strPdmName,strPdmUser,strPdmPwd))//连接数据库
{
m_bConnectSucess=FALSE;
AfxMessageBox(_T("连接PDM数据库失败!"));
return ;
}
AfxMessageBox(_T("连接PDM数据库成功!"));
m_bConnectSucess=TRUE;
CString str_mSql;
str_mSql=_T("select * from table where ID=1");
_RecordsetPtr pdmRecordSet;//执行的sql语句包含要写入的字段
pdmRecordSet=m_pdmDB.ExecuteSql(str_mSql);
if (!pdmRecordSet->BOF)
{
while(!pdmRecordSet->adoEOF)
{
_StreamPtr pStream;
pStream.CreateInstance("ADODB.Stream");
variant_t varOptional(DISP_E_PARAMNOTFOUND,VT_ERROR);
pStream->PutType(adTypeBinary);
pStream->Open( varOptional,
adModeUnknown, adOpenStreamUnspecified, _bstr_t(), _bstr_t());
pStream->LoadFromFile("c:\\text1.txt");//读入文件
variant_t varBLOB=pStream->Read(adReadAll);
pdmRecordSet->GetFields()->GetItem("NCFile")->Value= varBLOB;
// pdmRecordSet->MoveNext();
}
pdmRecordSet->Close();
}