xs_con.bas

一个简单的学生信息管理系统

Attribute VB_Name = "xscon"
Public xs As ADODB.Connection
Public rstxs As ADODB.Recordset
Public cmmxs As ADODB.Command
Public Sub xs_con()
Set xs = New ADODB.Connection
xs.CursorLocation = adUseClient
xs.Open "provider=microsoft.jet.OLEDB.4.0;Data source=" & VB.App.Path & "\db4.mdb"
Set rstxs = New ADODB.Recordset
Set rstxs.ActiveConnection = xs
rstxs.Open "select*from 学生", xs, adOpenStatic, adLockBatchOptimistic
Set cmmxs = New ADODB.Command
Set cmmxs.ActiveConnection = xs
End Sub