基本模块中的代码如下:Public Function acs1(ByVal strsql As String) As ADODB.Recordset '打开一个access数据库文件Dim conn As New ADODB.Connection
Dim rs As New ADODB.Recordset
conn.ConnectionString = " Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=S:\A30\YS0951\VB\批号系统.mdb"
conn.Open
rs.Open strsql, conn, adOpenDynamic, adLockPessimistic, adCmdText
Set acs1 = rs
Set conn = Nothing
Set rs = NothingEnd Function窗体中的代码如下:Private Sub Form_Load()
Dim rs As New ADODB.Recordset
Dim str As String
str = " select * from 批号表 "
Set rs = acs1(str)
Set DataGrid.DataSource = rsEnd Sub
Dim rs As New ADODB.Recordset
conn.ConnectionString = " Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=S:\A30\YS0951\VB\批号系统.mdb"
conn.Open
rs.Open strsql, conn, adOpenDynamic, adLockPessimistic, adCmdText
Set acs1 = rs
Set conn = Nothing
Set rs = NothingEnd Function窗体中的代码如下:Private Sub Form_Load()
Dim rs As New ADODB.Recordset
Dim str As String
str = " select * from 批号表 "
Set rs = acs1(str)
Set DataGrid.DataSource = rsEnd Sub
解决方案 »
- 菜鸟问题,如何判断未赋值的字符串为空值????谢谢!在线等待!
- 怎样将相关信息写到网页模板的固定位置?
- 如何用SQL语句直接读取Excel表中某些指定的单元格数据?
- 关于treeview的小问题,请进来看看,有分!
- 由于commondialog的使用改变了路径,如何改回来,或如何设定VB程序执行路径?谢谢。
- 客户端怎么连接服务器端的oracle数据库
- 怎样用vb做程序使win2000进入休眠或等待状态?
- 请问各位哪个报表控件能完全导出html文件包括里面的网线?多谢了
- 怎样实现自动更改名字?
- !!!高手请教,以下问题用VB如何实现!!!
- 房地产古代版-超强爆笑
- 菜鸟:游标有什么用的?记录集.CursorLocation = adUseClien
------------------------
把其中的3.51改为4.0再试试
Dim rs As New ADODB.Recordset
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; " _
& "Data Source=" & App.Path & "\db.mdb;Persist " _
& "Security Info=False;Jet OLEDB:Database Password=123"
conn.Open
rs.Open strsql, conn, adOpenDynamic, adLockPessimistic
Set acs1 = rs
Set conn = Nothing
Set rs = Nothing数据库在程序目录下可以用app,否则你按你的写
不是加: cn.CursorLocation=adUseClicent
Dim rs As New ADODB.Recordset
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=S:\A30\YS0951\VB\批号系统.mdb Security Info=False;Jet OLEDB:Database Password=123"
connCursorLocation=adUseClicent
conn.Open
rs.Open strsql, conn, adOpenDynamic, adLockPessimistic
Set acs1 = rs
conn.close
Set conn = Nothing
rs.close
Set rs = Nothing