Database connection from MFC application

0
votes

I am a complete beginner in MFC. Just for practice I have created a dialog-box which consist of a combo box, 2 editboxes and a button. Now I want to connect to database when I click the button from my dialog-box so that the data that is entered in the combo box and editboxes will be stored in a database table. Can anyone tell how to do this?

1
databasevisual-c++mfc
What exactly do you need help with ? The database connection, the SQL, or the MFC code (how to fetch values from CComboBox / CEdit / etc.) ? Post some code of your attempt(s) please. - Blacktempel
The MFC code to connect to the database. Thank you. - BaluS

1 Answers

1
votes

There are several classes in MFC to work with database including CDatabase and CRecordset. So called Data Source Name (DSN) is used to access the database. Here is the sample code that stores data to ODBC-compliant DB:

  CString sID;
  m_EditBox.GetWindowText(sID);
  int nID = _ttoi(sID);

  CString sName;
  m_ComboBox.GetWindowText(sName);

  CDatabase db;

  try
  {
     db.OpenEx(_T("DSN=MYDSN"), CDatabase::noOdbcDialog);
     CString sSQL;
     sSQL.Format(_T("insert into mytable (ID, NAME) values(%d, '%s')"), nID, sName); 
     db.ExecuteSQL(sSQL);
  }
  catch(CDBException* pEx)
  {
     pEx->ReportError();
     pEx->Delete();
  }
  db.Close();