ODBC连接数据库程序

void CStuInfoDlg::OnBtnAdd() 

{

// TODO: Add your control notification handler code here

m_db.Open(NULL,FALSE,FALSE,"ODBC;DSN=studata");

m_studata.m_pDatabase=&m_db;

m_studata.Open(CRecordset::snapshot,_T("SELECT * FROM student order by id Asc"));

m_studata.AddNew();

UpdateData(TRUE);

m_studata.m_ID=m_id;

m_studata.m_Name=m_name;

m_studata.m_Score=m_score;

m_studata.Update();

m_studata.Close();

m_db.Close();

}