Option ExplicitPublic Rs As New ADODB.Recordset Public Conn As New ADODB.ConnectionPrivate Sub Form_Load() If Make_Connection Then MsgBox "连接成功!" Else MsgBox "连接失败" End If End SubPublic Function Make_Connection() As Boolean
Option Explicit dim conn as new adodb.connection private sub form_load dim connstr="provider=sqloledb.1;persist security info=false;user id=sa;initial catalog=数据库名.mdb;datasource=." if conn.state then conn.close conn.open connstr dim rs as new adodb.recordset rs.=(客户端游标) if rs.state then rs.close rs.open"select* from 数据库名",conn end sub end sub
我没有msdn 可否给加上注释阿!!
如果看不懂的话, 只能从MSDN中一点点地学了。
一楼的代码还是有问题的 改一下: Public Function Make_Connection() As Boolean
Dim strConn As String On Error GoTo err:
strConn = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=pubs;Data Source=127.0.0.1" Conn.CursorLocation = adUseClient if conn.state=1 then conn.close Conn.Open strConn Make_Connection = True exit function err: Make_Connection = False err.Clear End Function
Public Conn As New ADODB.ConnectionPrivate Sub Form_Load()
If Make_Connection Then
MsgBox "连接成功!"
Else
MsgBox "连接失败"
End If
End SubPublic Function Make_Connection() As Boolean
Dim strConn As String
On Error GoTo err:
strConn = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=pubs;Data Source=127.0.0.1"
Conn.CursorLocation = adUseClient
Conn.Open strConn
Make_Connection = True
err:
Make_Connection = False
err.Clear
End Function
dim conn as new adodb.connection
private sub form_load
dim connstr="provider=sqloledb.1;persist security info=false;user id=sa;initial catalog=数据库名.mdb;datasource=."
if conn.state then conn.close
conn.open connstr
dim rs as new adodb.recordset
rs.=(客户端游标)
if rs.state then rs.close
rs.open"select* from 数据库名",conn
end sub
end sub
可否给加上注释阿!!
只能从MSDN中一点点地学了。
改一下:
Public Function Make_Connection() As Boolean
Dim strConn As String
On Error GoTo err:
strConn = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=pubs;Data Source=127.0.0.1"
Conn.CursorLocation = adUseClient
if conn.state=1 then conn.close
Conn.Open strConn
Make_Connection = True
exit function
err:
Make_Connection = False
err.Clear
End Function
这个小软件如果要做出来,说难不难,说易不易,还是有一点技术性.谁能用VB写出这样子的软件,给我源码,给200元酬谢.
我的QQ 10046870
然后写上 上面的代码 即可。