mysql-connector-net-6.0.4

说明：  因本人没有充足的时间，写的比较简陋了 没有办法，也是帮别人的忙了，还望看了 不要笑话本人，如有不足，请多指教(because I do not have sufficient time to write a simple comparison is no way is anybody a favor, but he still saw hope I do not joke, if inadequate, please enlighten)

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

vb操作excel的各种方法：包括ado操作、模板操作等(Copy the source workbook file (the "template") to the destination filename。Open the ADO connection to the Excel workbook。Open a connection to the Northwind database and retrieve the Order information)

本软件系本人自学VB过程中试写,后来经不断改进完成,经试用比较完整,又修补了一些漏洞,可以放心投入使用,并供学习编程爱好者参考. 本软件简单易用,操作方便,基本可以不用鼠标,直接通过键盘操作. ACCESS数据库+sql语句+VB6.0 数据库采用MD5加密 测试系统:WINDOWSXP(This software grades the course of my self-VB try to write, and later by the completion of continuous improvement, the more complete the trial, but also fixes some vulnerabilities, you can rest assured that put into use, and for enthusiasts to learn programming reference. This software is simple and easy to operate , the basic can be a mouse, directly through the keyboard. ACCESS database+ sql statement+ VB6.0 database using MD5 encryption test system: WINDOWSXP)

VFP数据库继承了以往传统数据库的优点，是采用了面向对象的程序设计思想和可视化的编程工具，操作简单、易学，极大的方便了软件的开发。人们在使用它作为开发工具时，可以高效的开发出全新的可视化图形界面应用程序。(VFP database inherits the advantages of traditional databases, is the use of object-oriented program design and visual programming tools, simple operation, easy to learn, which greatly facilitates the software development. People use it as a development tool, you can efficiently develop a new visual GUI applications.)

VB的基础教程，特别适合刚刚入行的新手学习练习使用。(The basis of VB tutorials, and are particularly suited to the trip just to practice using the new study.)

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

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

说明：  technical support to achieve the highest levels of MySQL scalability

acess数据库中关于ADO控件和DATAgrid控件以及sql语言添加查询删除编辑等功能的实现(acess database in ADO controls and a DataGrid control, as well as the sql language query to delete editing functions )