4,012
社区成员
发帖
与我相关
我的任务
分享
m_pRecordset->Open("SELECT * FROM Users where Uname='"+ch3+"'",_variant_t((IDispatch*)m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
上面的这句是改了的
m_pRecordset->Open(_bstr_t("SELECT * FROM Users where Uname='"+ch3+"'"),_variant_t((IDispatch*)m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
CString ch3;
ch3=GetDlgItemInt(IDC_edit_5);
try
{
m_pRecordset.CreateInstance("ADODB.Recordset");
m_pRecordset->Open("SELECT * FROM Users where Uname='"+ch3+"'",_variant_t((IDispatch*)m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
}
try
{
while(!m_pRecordset->adoEOF)
{
m_pRecordset->PutCollect("password",_variant_t("m_zhun"));
m_pRecordset->MoveNext();
}
m_pRecordset->Update();
AfxMessageBox("修改密码成功");
}
catch(_com_error* e)
{
AfxMessageBox(e->ErrorMessage());
}
m_pRecordset->Close();
m_pRecordset=NULL;
m_pConnection->Close();
m_pConnection=NULL;
}
CString strSQL;
strSQL = "SELECT * FROM Users where Uname='3'";
_variant_t var;
var = (LPCTSTR)strSQL;