ODBC增删改

/
// CTestDlg message handlers

void CTestDlg::OnBtnAdd() 
{
// TODO: Add your control notification handler code here
	CTestDB &m_set=*(this->m_pSet);
if (m_set.IsOpen())
{
m_set.Close();
}
m_set.Open();
if (!m_set.CanUpdate())
{
AfxMessageBox(_T("无法更新"));
}
else
{
m_set.MoveLast();
m_set.AddNew();
UpdateData(true);
m_set.m_column1= m_e1;
m_set.m_column2 = m_e2;
m_set.m_column3 = m_e3;
m_set.m_column4 = m_e4;
m_set.m_column5 = m_e5;
m_set.m_VC__ = m_e6;
UpdateData(false);
m_set.Update();
m_set.Close();
m_pt->Invalidate();
}
	
}

void CTestDlg::OnBtnAlter() 
{
 CTestDB &m_set=*(this->m_pSet);
// TODO: Add your control notification handler code here
if (m_set.IsOpen())
{
m_set.Close();
}
m_set.Open();
if (!m_set.CanUpdate())
{
AfxMessageBox(_T("无法更新"));
}
else
{
UpdateData(true);
for (int i=0;i<m_set.GetRecordCount();i++)
{
if(strcmp(m_set.m_column1,m_e1))
{
m_set.MoveNext();
}
else
{
m_set.Edit();
m_set.m_column1 = m_e1;
m_set.m_column2 = m_e2;
m_set.m_column3 = m_e3;
m_set.m_column4 = m_e4;
m_set.m_column5 = m_e5;
m_set.m_VC__ = m_e6;
m_set.Update();
break;
}
}
}
m_pt->Invalidate();	
}

void CTestDlg::OnBtnDelete() 
{
CTestDB &m_set=*(this->m_pSet);

if (m_set.IsOpen())
{
m_set.Close();
}
m_set.Open();
UpdateData(true);
m_set.MoveFirst();
for (int i=0;i<m_set.GetRecordCount();i++)
{
if(strcmp(m_set.m_column1,m_e1))
{
m_set.MoveNext();
}
else
{
m_set.Delete();
break;
}
if (m_set.IsEOF())
{
AfxMessageBox(_T("不存在此记录"));
}
}
m_set.Close();
/*m_set.Update();*/
UpdateData(false);
m_pt->Invalidate();
	
}