数据库问题,!~!~!~!分不够再加!~!~!~
我连接了两个数据库,我想把一个数据库里的表中的一个字段值直接付给另一个数据库表中的字段值,应该怎么做?我的这断代吗怎么不行,请高手们指教一下,急用!~!~
void linkVIN(char* biaoming,long xuhao)
{ /////
_RecordsetPtr Recordset,Recordset1;
_variant_t RecordsAffected,Sname,VName;
CString sName,sql,sql1;
sql = "SELECT * FROM 底盘号表";
sql1.Format("SELECT * FROM %s WHERE 序号>%d",biaoming,xuhao);
try
{
Recordset.CreateInstance("ADODB.Recordset");
Recordset->Open((_bstr_t)sql,_variant_t((IDispatch*)m_pConnection,true),adOpenDynamic,adLockOptimistic,adCmdText);
Recordset1.CreateInstance("ADODB.Recordset");
Recordset1 = m_pConnection1->Execute((_bstr_t)sql1,&RecordsAffected,adCmdText);
//while(!Recordset1->adoEOF)
{
Recordset1->MoveFirst();
VName = Recordset1->GetCollect("VIN");
Recordset->AddNew();
if(VName.vt!=VT_NULL)
{
Recordset->PutCollect("底盘号",(_bstr_t)VName);
}
Recordset->Update();
Recordset1->MoveNext();
}
Recordset->Close();
Recordset1->Close();
}
catch(_com_error e)///捕捉异常
{
AfxMessageBox("读取数据库失败!\nlinkVIN()");///显示错误信息
}
}