A-better-Database

用ADO打开关闭数据库的简单程序 初步了解关于ADO在MFC中的使用(用ADO打开关闭数据库的简单程序 初步了解关于ADO在MFC中的使用 Simple procedures for opening and closing the database with ADO preliminary understanding about use of ADO in MFC )

ODBC 操作，包括连接、检索、返回结果集、插入删除(ODBC operation, including connection, retri , return the result set, insert delete)

MFC操作数据库ADO操作数据库, MFC操作数据库ADO操作数据库.(use MFC to handle the databases.)

可视化数据库管理，提供添加，删除，插入，查询等操作(visualized management of database)

使用ADO导出数据,在数据库编程中应用很多。(Use ADO export data, many applications in database programming.)

例子2(Example 2)

MDAC（Microsoft Data Access Components）是微软数据库访问组件，Netpise和许多利用数据库的软件都需要操作系统安装MDAC。很多用户的操作系统中已经存在了MDAC，有些是操作系统内置的、有些是其它应用程序安装的。(MDAC (Microsoft Data Access Components) is a Microsoft database access components, Netpise and many need to use the database software operating system to install MDAC. Many users of the operating system already exists in the MDAC, some built-in operating system, some other applications installed.)

说明：  直接通过ODBC读写Excel表格文件。基于数据库编写源程序。(Directly through ODBC to read and write Excel spreadsheet file. Prepared based on the source database.)

个人理财系统是我用MFC做的一个有界面的程序，里面涉及了数据库编程，常用的控件等知识。里面的数据都存储在SQL Server2005里面，我用的是ado方式访问数据库，实现了记录日常每餐的消费食物，消费水平，并可以自动算出一段时间的消费金额。(Personal financial management system is an interface program I do with MFC, which involves a database programming, controls and other knowledge. Inside the data stored in SQL Server 2005 which I use ado to access the database, to record daily meal consumption of food, consumption levels, and can automatically calculate the amount of the consumer for a period of time.)

使用ODBC访问数据库，一则ODBC是直接封装在MFC库里面的，二则忙着考研没有时间学习dao。 ODBC和DAO用起来可能最大的区别就是ODBC使用之前得先建立数据源，根据不同的数据库，使用的参数也不同。具体请看在这之前的一片文章。里面有许多东西没有说，属于高级技巧性东西，得学你们自己摸索。(Using ODBC to access the database, an ODBC database directly encapsulated in the MFC inside, two busy Kaoyan no time to learn dao. ODBC and DAO can be at the biggest difference is that must be built before using ODBC data source, depending on the database, the parameters used are also different. Details, please read an article before this. There are many things not said, things are high skill, have to learn your own. )