在模块中
fileName = App.Path & "\server.mdb"
constr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" & fileName & "';Persist Security Info=False"
Set con = New ADODB.Connection
con.ConnectionString = constr
con.Open在窗体中Dim rs As ADODB.Recordset
Set rs = New Recordset
rs.Open "select * from 工资", conSet DataGrid1.DataSource = rs
con.CursorLocation = adUseClient
DataGrid1.ReBind
DataGrid1.Refresh请问为什么显示The rowset is not bookable
我应该怎么改呀
fileName = App.Path & "\server.mdb"
constr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" & fileName & "';Persist Security Info=False"
Set con = New ADODB.Connection
con.ConnectionString = constr
con.Open在窗体中Dim rs As ADODB.Recordset
Set rs = New Recordset
rs.Open "select * from 工资", conSet DataGrid1.DataSource = rs
con.CursorLocation = adUseClient
DataGrid1.ReBind
DataGrid1.Refresh请问为什么显示The rowset is not bookable
我应该怎么改呀
解决方案 »
- eval 为什么不能执行 变量
- 如何用程序控制中泰PCI8403采集卡
- 经典库存报表数据库设计文档---在线等!
- 以我现在的水平找工作的话应该要多少Money比较合适
- 新手问题:怎样将一个窗体中文本的内容传递到另一个窗体
- 运行一个VB的EXE程序,怎么用API来获得一个控件的托动句柄?
- visual foxpro表单集
- 怎样设定报表的表格问题,高手请进!(毕设急用,可另外加分)
- 请问如何用mciExecute播放资源文件中的WAV或者MP3?我这样做不行啊......
- 如何在运行时修改数据报表(DataReport)中Label控件的名字?
- 能不能用ADSL实现远程数据库管理???
- 敬请李洪根先生和陈建华先生等各位师兄指教怎样利用OPTIONBUTON添加记录到SQL问题
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
rs.LockType = adLockBatchOptimistic
rs.CursorLocation = adUseClientrs.Open "select * from 工资", con
set rs.activeconnection=nothingSet DataGrid1.DataSource = rs
fileName = App.Path & "\server.mdb"
constr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" & fileName & "';Persist Security Info=False"
Set con = New ADODB.Connection
con.CursorLocation = adUseClient
con.ConnectionString = constr
con.Open在窗体中Dim rs As ADODB.Recordset
Set rs = New Recordset
rs.Open "select * from 工资", con, adOpenKeyset, adLockReadOnlySet DataGrid1.DataSource = rs
必须加在模块中才可以?
///可以加在窗體中間,但是必須加在rs.Open "select * from 工资", con,3,1的上面
Set rs = New ADODB.Recordset
rs.LockType = adLockBatchOptimistic
rs.CursorLocation = adUseClientrs.Open "select * from 工资", conSet DataGrid1.DataSource = rs
Datagrid1.refresh
还是告诉我怎么给分呀?