常用SQL语句开发实例!

我的源码用DELPHI编写的无任何密码的 大家多提宝贵意见呀-I use the source code prepared by the Delphi without any password you more valuable opinions!

（转载） 一个简单灵巧的ODBC包库 直接调用ODBC的方法非常复杂。每一个试图使用ODBC的人都这么说。 ODBC是一个功能层次接口。它是一个好的通用接口,但是所有的C++结构应用调用ODBC时将会非常可怕。 来源: http://www.codeguru.com/mfc_database/gsodbc.html- (Reprint) a simple clever ODBC package of storehouse directly transfers ODBC the method to be extremely complex. Each the people which attempts to use ODBC all such said. ODBC is a function level connection. It will be a good general connection, when all C structure application transfers ODBC will be able to be extremely fearful. Origin: Http://www.codeguru.com/mfc_database/gsodbc.html

数据库代理，基于xml，可以有效的降低对数据库的访问次数，也有利于协议的分层实现。是数据库操作与应用层接连的好的构件模式-The database proxy, based on xml, may effective reducing to the database the access, also is advantageous to the agreement lamination realization. Is the database operation and the application layer one after another good component pattern

vc++数据库开发的药品进销管理系统数据库及源代码-vc database development marketing of pharmaceuticals into the database management system and source code

超市进销存管理系统,基于mfc开发，应用sql数据库-Supermarket Invoicing Management System, based on mfc development and application of sql database

在很多管理信息系统的窗体都有一些共同点：可以通过框架菜单打开各种类型的视图窗口，而这些视图窗口具有MDI的一些特点，可以在框架窗体中最小化最大化还原等，并且点击菜单只能产生一个窗口（象SDI）。这种形式的窗口设计给人与一种条理感。于是我用VC6.0尝试创建这种窗口，现将整个过程为大家写下来，这里应含有MFC的一些内幕技术。 -Management information systems in many of the forms have some common elements: the menu can be opened through the framework of various types of view window, which has a view window MDI some of the features, you can form in the framework of maximizing the smallest reduction, etc., and Click on the menu can only have a window (as SDI). This form of window design gives people with a sense of well-organized. So I use VC6.0 attempt to create such a window, now the whole process for everyone to write down here should contain a number of insider MFC technology.

一个比较完整的医院管理系统，配有数据库文件，把数据库文件导入后即可使用-a more complete hospital management system, equipped with the database files, database files into ready for use

数据库开发指南二-Database Development Guide 2

Excel表格是输入输出经常需要涉及到的。操作Excel表格的方式也多种多样。比如，通过调用Excel程序的COM组件对Excel进行操作。但是，这种方式限制较多，且实现难度比较大。但是，用于访问数据库的组件ADO，是支持多种数据源的，其中就包括Excel文件。我们可以通过ADO组件对Excel文件进行读写访问。当然，在.NET平台上对应ADO数据访问组件的是ADO.NET组件。我编写的这个类就是通过ADO.NET实现了Excel文件的读写。由于时间仓促，功能还不是很完善，会在以后有时间的时候进行版本升级。也请各位高手多多批评指正。 -Excel spreadsheet input and output is often of the need to address. Operation Excel variety of ways. For example, by calling the Excel COM procedures for the operation of Excel. However, this approach is more limited and more difficult to achieve. However, for access to the database components ADO, is to support multiple data sources, including Excel file. We can ADO components to read and write Excel files visit. Of course,.NET platform counterparts ADO data access components of ADO.NET components. I prepared this category is achieved through ADO.NET read and write Excel files. Because time is so short, the function is still not perfect, will in future have the time for version upgrades. Members also criticized many

在Windows系统的管理工具中，选择Internet信息服务，进入web页面管理界面。设置默 认web站点的路径为本目录的绝对路径。 确保您的机器上安装了SQL Server 2000或以上的版本，建立一个新的数据库ASPData，再将 存放在datasource子目录下的mydb_1文件导入到新建的数据库中，并进行还原备份。-on Windows systems management tool, select Internet Information Services, access web pages management interface. Web site set up by default the path to catalog the full path. To ensure that your machine installed SQL Server 2000 or more versions, the creation of a new database ASPData and then stored in a subdirectory under the datasource mydb_1 documents imported into the new database, backup and restore.