紧急求救,更新数据库问题!!!!!!
我通过这样更新数据库,不知对否:
CString mysql;
CString str;
str.Format("%d",theTree.GetItemData(m_htiDrag));
mysql.Format("select * from Pub_Department where ID='" + str+"'");
try
{
_RecordsetPtr pRs;
pRs.CreateInstance(__uuidof(Recordset));
_variant_t vRowsAffected;
if (pRs->State==adStateOpen)
pRs->Close();
pRs->Open((_bstr_t)(LPCTSTR)mysql,
m_Conn.GetInterfacePtr(),
adOpenForwardOnly,
adLockReadOnly,-1); //先得到一个记录集,这一不是对的,仅得
int i=pRs->RecordCount; 到一条纪录,id是主键
_variant_t vName,vValue;
vName.SetString("PID");
DWORD dw=theTree.GetItemData(m_htiDrop);
_variant_t varDes;
vValue.vt = VT_UINT;
vValue.uintVal = dw;
pRs->Update(vName,vValue); //再更新数据库,到这一步就发生异常。
}catch(...)
{
MessageBox("数据库更新失败");
return;
}