database-conn.rar_DEMO_databaseconn

DAO database library DLL Introduction ------------------------------------------------------------------------------ I have noticed that working with DAO databases and recordsets can often be tedious and time consuming. That is why I created this DAO database library. My goal was to create a library to speed up coding time when working with DAO. My library allows you to a) quickly open database and recordset objects b) close them quickly without worrying about memory leaks b) easily read and write from the database for given data types These functions are not intended to replace the given DAO functionality, but rather to extend up them for speed of coding. DLL Setup ------------------------------------------------------------------------------ 1. Open the project and compile the DLL using "rebuild all", it will create a .dll and .lib file for you in your release folder. Client EXE Setup ------------------------------------------------------------------------------ 1. In project -> settings -> link -> object libraries include daolibrary.lib 2. In Release folder add daolibrary.dll 3. In project workspace add daolibrary.lib 4. Add dllHeader.h to project and following lines in client .cpp file. #include "dllHeader.h" CDaoDB db; // database CDaoRS rs; // recordset ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ CDaoDB Documentation CDaoDB extends the CDaoDatabase class ------------------------------------------------------------------------------ bool CDaoDB::dbOpen(CString strFilePathName); Opens connection to CDaoDatabase given a database filename with path. ----------------------------------------------------------------------------- bool CDaoDB::dbClose(); Closes the CDaoDatabase, deletes variables to prevent memory leaking. ----------------------------------------------------------------------------- CString CDaoDB::GetTableName(int tableNum); Returns the name of a table based on the table number. ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- CDaoRS Documentation CDaoRS extends the CDaoRecordset class ------------------------------------------------------------------------------ bool CDaoRS::rsOpen(CString sql,CDaoDatabase* db); Opens connection to CDaoRecordset given sql and database. i.e. rs.rsOpen("SELECT * FROM TABLE",database.db); *note that this opens the recordset as dbOpenDynaset ----------------------------------------------------------------------------- bool CDaoRS::rsClose(); Closes the CDaoRecordset, deletes variables to prevent memory leaking. ----------------------------------------------------------------------------- double CDaoRS::GetAsDouble(int col); Returns a double value from the specified column in the recordset. ----------------------------------------------------------------------------- int CDaoRS::GetAsInt(int col); Returns an int value from the specified column in the recordset. ----------------------------------------------------------------------------- long CDaoRS::GetAsLong(int col); Returns a long value from the specified column in the recordset. ----------------------------------------------------------------------------- CString CDaoRS::GetAsString(int col); Returns a long value from the specified column in the recordset. ----------------------------------------------------------------------------- CString CDaoRS::GetDateAsString(int col); Returns a date value in CString format from the specified column in the recordset. The CString will be returned with mm/dd/yyy format. ----------------------------------------------------------------------------- CString CDaoRS::GetTimeAsString(int col); Returns a date value in CString format from the specified column in the recordset. The CString will be returned with hh:mm:ss format. ----------------------------------------------------------------------------- void CDaoRS::SetAsString(CString field,CString string); Set specified fieldname field in recordset to the CString value string. ----------------------------------------------------------------------------- void CDaoRS::SetAsInt(CString field,int integer); Set specified fieldname field in recordset to the integer value int. ----------------------------------------------------------------------------- void CDaoRS::SetAsLong(CString field,long lngValue); Set specified fieldname field in recordset to the long value lngValue. ----------------------------------------------------------------------------- void CDaoRS::SetAsDouble(CString field,double dblValue); Set specified fieldname field in recordset to the double value dblValue. ----------------------------------------------------------------------------- CString CDaoRS::GetFieldName(int col); Returns the field name of the specified column number in the recordset. ----------------------------------------------------------------------------- int CDaoRS::GetRecordCount(); Returns the number of records in the recordset.