请问在vb中如何实现不添加adodc控件,而纯用代码实现连接access2000数据库
解决方案 »
- 如何解决在多表关系中添加记录的问题(修正图片不显示问题)
- VB+ACCESS 中在select语句中如何选择数据在大值啊?
- 关于word的问题,清各位帮忙!!
- 关于自定义控件的制作
- 关于on error goto 问题!!!
- 求SQL语句:把sql server的数据导入access.
- 用vb如何对word 文档中,file 菜单下properties里的内容进行设置。
- 希望大家给我点意见
- 找关于大小写互换方面的源代码--初学者
- ControlService这个API如何使用?
- 请问ado中如何不用odbc直接连接access数据库?
- 用winsock控件连接,经常会出现“所需事物或请求的错误协议或连接状态”
先定义一个ADOCONNECTION ,连接字符串就是ADODC中一样的字符串
再OPEN CONNECTION再定义一个ADORecordSet,用SQL语句打开,应该是这样吧,最简单的方式
Dim rs As New ADODB.Recordset
cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\ado\test.mdb;Persist Security Info=False"
cn.Openrs.Open "select * from table", cn, 3, 3
Dim rs As New ADODB.Recordset
'连接 SQL ANYWHERE 数据库
'cn.ConnectionString = "Driver={Sybase SQL Anywhere 5.0};DatabaseFile=" & App.Path & "\数据库\Refer.DB;DatabaseName=Refer;UID=dba;PWD=sql;AutoStop=yes;Agent=engine;Start=" & App.Path & "\数据库\dbeng50.exe -Q"
cn.ConnectionString = "DSN=refer;UID=dba;PWD=sql" '连接 SYBASE 数据库
cn.ConnectionString = "Driver={Sybase System 11};SRVR=;DATABASE=;UID=;PWD="
'连接 SQL SERVER 数据库
'cn.ConnectionString = "Driver={SQL Server};SERVER=;DATABASE=;UID=;PWD="
rs.open "select * from tablename", cn, adOpenDynamic, adLockPessimistic
'打开数据表
Option Explicit
Public MdbConn As New ADODB.Connection'功能简介:建立本地数据库公共链接
'参数一:MDB数据库地址路径
'返回值:"ok"--成功
Function PulbicMdbConn(ByVal StrPath As String) As String
On Error GoTo MdbConnErr
Dim StrSql As String
StrSql = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & StrPath & ";Persist Security Info=False"
If MdbConn.State <> 0 Then MdbConn.Close
MdbConn.Open StrSql
PulbicMdbConn = "ok"
Exit Function
MdbConnErr:
PulbicMdbConn = Err.Description
If MdbConn.State <> 0 Then MdbConn.Close: Set MdbConn = Nothing
End Function'功能简介:关闭本地数据库公共链接
Function PublicMdbClose()
If MdbConn.State <> 0 Then MdbConn.Close: Set MdbConn = Nothing
End Function
'"工程/引用"菜单,选择"Microsoft Activex DataObjects 2.5"
dim N as long
Dim strSQL As String
dim conn as New ADODB.Connection
dim rs as New ADODB.Recordset
strSQL = App.Path & "\Biblio.mdb"
strSQL = Replace(strSQL, "\\", "\")
With conn
If .State = adStateOpen Then
.Close
End If
.CursorLocation = adUseClient
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=" & strSQL
.Open
End With
With rs
.Open "Select * from Authors;", conn, adOpenStatic, adLockOptimistic
If .BOF And .EOF Then
msgbox "没有任何记录"
Exit Sub
End If
.MoveFirst
.movelast
msgbox "有" & .recordcount & "条记录!"
N = .recordcount
End With