34,590
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
iainet 2003-05-11
- 打赏
- 举报
rdo
ado
oledb
ADO.net
下面是它的ado.net联接代码：(本地SQL SERVERL)
imports system.data.sqlclient
Dim cn As SqlConnection
Dim cnstr As String
cnstr = "data source=create;initial catalog=pubs;user id=sa;"
cn = New SqlConnection(cnstr)
cn.Open()
ado
oledb
ADO.net
下面是它的ado.net联接代码：(本地SQL SERVERL)
imports system.data.sqlclient
Dim cn As SqlConnection
Dim cnstr As String
cnstr = "data source=create;initial catalog=pubs;user id=sa;"
cn = New SqlConnection(cnstr)
cn.Open()
shuchang0626 2003-05-10
- 打赏
- 举报
ado连接:
首先project->references->microsoft activex data objects 2.7 library
下面是一小段代码
Dim cnn As New ADODB.Connection
Dim rst As New ADODB.Recordset
cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="数据库文件路径";Persist Security Info=False"
cnn.CursorLocation = adUseClient
cnn.Open
rst.Open "select * from 表", cnn, adOpenStatic, adLockPessimistic
首先project->references->microsoft activex data objects 2.7 library
下面是一小段代码
Dim cnn As New ADODB.Connection
Dim rst As New ADODB.Recordset
cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="数据库文件路径";Persist Security Info=False"
cnn.CursorLocation = adUseClient
cnn.Open
rst.Open "select * from 表", cnn, adOpenStatic, adLockPessimistic
benxie 2003-05-10
- 打赏
- 举报
ado
dao
dao
chendaiyin 2003-05-10
- 打赏
- 举报
远程?本地?
ODBC BDE ADO?
ODBC BDE ADO?
