N-sheets

基于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)

此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 ~ ~)

说明：  DAO读写(literacy DAO)

VisualBasic实现EXCEL数据的批量导入,(EXCEL data batch import to mdb based on VB)

VC进行数据库编程，MFC编写的，可以与CListCtrl控件配合使用(VC database programming, MFC prepared can be used in conjunction with the CListCtrl control)

以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 )

这是一款用MFC ADO编写的数据库软件，它可以实现对ACCESS数据库的打开，添加，修改，保存，排序得一系列的功能。它利用ListCtl进行显示(This is a MFC ADO with the preparation of the database software, it can be open to the ACCESS database, add, modify, save, sort a series of functions. It uses ListCtl display)

利用mfc编程实现acess数据库的存储与访问，对于小型的数据库很实用(Mfc programming using acess database storage and access, the database is very useful for small)

对已经存在的Accsess数据库表添加新字段并复值(right Accsess already existing database table and add a new field of Complex)