用VC++6.0用ODBC怎么执行一条SQL语句呀
我用Crecordset基类弄了一个m_LoginSet,目的是完成数据修改,结果却程序停止运行(只要涉及到m_LoginSet->~~~~)
UpdateData(TRUE); //读入输入的资料
if(m_ChangeName.IsEmpty()||m_ChangePwd.IsEmpty())
{
AfxMessageBox("请输入相应的数据!");
return;
}
m_LoginSet->MoveFirst();
while(!m_LoginSet->IsEOF())
{
if(m_ChangeName != m_LoginSet->m_username)
{
m_LoginSet->MoveNext();
}
else
{
m_LoginSet->Edit();
m_LoginSet->m_username = m_ChangeName;
m_LoginSet->m_pwd = m_ChangePwd;
m_LoginSet->Update();
m_LoginSet->Requery();
// m_List.DeleteAllItems();
// DisplayRecord(); 8
return;
}
}
我用Crecordset基类弄了一个m_LoginSet,目的是完成数据修改,结果却程序停止运行(只要涉及到m_LoginSet->~~~~)
UpdateData(TRUE); //读入输入的资料
if(m_ChangeName.IsEmpty()||m_ChangePwd.IsEmpty())
{
AfxMessageBox("请输入相应的数据!");
return;
}
m_LoginSet->MoveFirst();
while(!m_LoginSet->IsEOF())
{
if(m_ChangeName != m_LoginSet->m_username)
{
m_LoginSet->MoveNext();
}
else
{
m_LoginSet->Edit();
m_LoginSet->m_username = m_ChangeName;
m_LoginSet->m_pwd = m_ChangePwd;
m_LoginSet->Update();
m_LoginSet->Requery();
// m_List.DeleteAllItems();
// DisplayRecord(); 8
return;
}
}
CRecordset::Open(UINT nOpenType = AFX_DB_USE_DEFAULT_TYPE, LPCTSTR lpszSQL = NULL, DWORD dwOptions = none );这两个就够了吧。
{
//open database
……
ASSERT(m_DBSet && m_DBSet->IsOpen());
if(m_DBSet && m_DBSet->IsOpen())
{
……
} //close database
……
}
catch(CDBException *e)
{
e->ReportError();
e->Delete();
}