C / C++ / MFC

<br />
void CLoadTablesDlg::OnButtonOpen() <br />
{<br />
	CTableDlg dlgTable;<br />
	<br />
	_RecordsetPtr m_pRstOpenSchema;<br />
	_ConnectionPtr m_pConnection;<br />
	<br />
	TCHAR szFilters[] = _T("Access files(*.mdb) | *.mdb | All files(*.*) | *.*||");<br />
<br />
	CFileDialog dlg (TRUE, _T("mdb"), _T("*.mdb"),<br />
		OFN_FILEMUSTEXIST | OFN_HIDEREADONLY, szFilters);<br />
<br />
	if(dlg.DoModal () == IDOK)<br />
		m_sFileName = dlg.GetPathName();<br />
	<br />
	HRESULT hr;<br />
<br />
	_bstr_t strCnn("Provider=Microsoft.Jet.OLEDB.3.51; Data Source= " + m_sFileName + ";");<br />
	<br />
	try<br />
	{<br />
		hr = m_pConnection.CreateInstance(__uuidof(Connection));<br />
		if(SUCCEEDED(hr))<br />
		{<br />
			m_pConnection->Open(strCnn, "", "", adModeUnknown);<br />
			m_pRstOpenSchema = m_pConnection->OpenSchema(adSchemaTables);<br />
			<br />
			while (!(m_pRstOpenSchema->adoEOF))<br />
			{<br />
				_bstr_t table_name = m_pRstOpenSchema->Fields->GetItem("TABLE_NAME")->Value;<br />
				<br />
				CString strTableName = (LPCSTR)table_name;<br />
				dlgTable.m_lstTables.AddString(strTableName);<br />
				m_pRstOpenSchema->MoveNext();<br />
			}<br />
			<br />
		}<br />
	}<br />
	catch (_com_error &e)<br />
	{<br />
		// Get info from _com_error<br />
        _bstr_t bstrSource(e.Source());<br />
        _bstr_t bstrDescription(e.Description());<br />
        TRACE( "Exception thrown for classes generated by #import" );<br />
        TRACE( "\tCode = %08lx\n", e.Error());<br />
        TRACE( "\tCode meaning = %s\n", e.ErrorMessage());<br />
        TRACE( "\tSource = %s\n", (LPCTSTR) bstrSource);<br />
        TRACE( "\tDescription = %s\n", (LPCTSTR) bstrDescription);<br />
    }<br />
    catch(...)<br />
    {<br />
		TRACE( "*** Unhandled Exception ***" );<br />
    }<br />
	<br />
}<br />

void SettingsDlg::OnLoadButton() 
{
	UpdateData();
	CString cstrFileName;
	CFileDialog FileDlg(TRUE,	/* Make a open dialog box. */
			"cnf",	/* Default file name extension. */
			NULL,	/* No default filename. */
			OFN_HIDEREADONLY | OFN_OVERWRITEPROMPT | OFN_NOCHANGEDIR,
			"Configuration files (*.cnf)|*.cnf|All files (*.*)|*.*||");

	if ( FileDlg.DoModal() == IDOK )
	{
		cstrFileName = FileDlg.GetPathName();

		/* Create a new file and open it. */
		CFile* pFile = new CFile();
		ASSERT (pFile != NULL);

		CFileException *pExc = new CFileException(TRUE);

		if ( !pFile->Open(cstrFileName, CFile::modeRead | CFile::shareExclusive, pExc) )
		{
			MessageBox("Error: Unable to open the file.");
			delete pFile;
			pFile = 0;
			return;
		}
		
		bool bReading = true;	/* We'll read. */
		CArchive* pArchive = NULL;
		
		try
		{
			pFile->SeekToBegin();
			UINT uMode = (bReading ? CArchive::load : CArchive::store);
			pArchive = new CArchive (pFile, CArchive::load);
			ASSERT (pArchive != NULL);
		}
		catch (...)
		{
			MessageBox("Error: Unable to read from the file");
			pFile->Close();
			delete pFile;
			pFile = 0;
			return;
		}

		Serialize(*pArchive);
		
		UpdateData(FALSE);

		delete pArchive;
		pArchive = 0;

		pFile->Close();

		delete pFile;
		pFile = 0;
	}
		
}