ADO

visual basic和access 数据库开发实例 (vb access database)

以G列分成多个工作表(以宏运行VBA) (Sub aa() Dim a As Integer, b As Integer, c As Integer, sh As Worksheet For a = 2 To [g65536].End(3).Row If Cells(a, 7) <> Cells(a- 1, 7) Then b = a End If c = Range("g:g").Find(Cells(a, 7), , , , , xlPrevious).Row Set sh = Sheets.Add(, Sheets(Sheets.Count)) sh.Name = Sheets("sheet1").Cells(a, 7).Value With Sheets("Sheet1") Sheets("Sheet1").Range(.Cells(b, 1), .Cells(c, 10)).Copy Destination:=sh.[a2] Sheets("Sheet1").Range("a1:j1").Copy Destination:=sh.[a1] a = c End With Sheets("Sheet1").Select Next End Sub )

Sqlite3 的确很好用。小巧、速度快。但是因为非微软的产品，帮助文档总觉得不够。这 些天再次研究它，又有一些收获，这里把我对 sqlite3 的研究列出来，以备忘记。(Sqlite3 really good use. Small, fast. But for the Microsoft products, always feel that not enough to help document. This Some day to study it, and have some harvest, here I study on SQLite3 list, to forget.)

 职责描述：，系统信息设计，学生出操考勤管理、学生上课考勤管理、学生参加活动考勤管理，学生寝室考勤管理，综合统计与查询等六大模块。  项目简述：该系统利用MFC框架 Excel工具开发，来实现学生考勤管理。()

c++ 链接access 建立的一个小型人员统计系统管理 代码简单(c++ link access to the set of a small staff Biejiao simple statistical system management code)

利用MFC开发的数据库系统，用的是微软的Access，有详细的链接数据库的代码。(Use of MFC development of database systems, using Microsoft Access, there are more links to the database code.)

此demo包含vc操作Access数据库的链接、以及增删改查的基本操作，均提供的有接口，方便用户操作，并且提供了一些模糊查询语句供用户参考~~(This demo contains the Access database, the link vc operations, as well as additions or deletions to change the basic operation of search are provided with interfaces, user-friendly operation, and provides a number of fuzzy query for the user' s reference ~ ~)

基于VFP的出题小系统，以前做的，传上来分分享一下(Test system based on VFP, before doing, Chuan up points to share)

说明：  VC操作ADO和datagrid控件的源码，是动态的的。不受目录改变的限制(ADO and VC operation datagrid source control is the dynamic. From the directory to change the restrictions)

A very simple VB Source that can read / write from access database to Grid