具体代码如下:但问题是DataGrid1没有任何数据,但运行又不报错!
Dim cn As ADODB.Connection
Dim strcn As String
Dim strora As String
Dim rs As ADODB.Recordset
strcn = "Provider=MSDAORA.1;Password=manager;User ID=system;Data Source=ora;Persist Security Info=True"
Set cn = New ADODB.Connection
cn.Open strcn
strora = "select * from dd"
Set rs = New Recordset
rs.CursorLocation = adUseClient
rs.CursorType = adOpenKeyset
rs.LockType = adLockOptimistic
'Set Rs = CN.Execute(strsql)
rs.Open strora, cn, , , adCmdText
Set DataGrid1.DataSource = rs
Dim cn As ADODB.Connection
Dim strcn As String
Dim strora As String
Dim rs As ADODB.Recordset
strcn = "Provider=MSDAORA.1;Password=manager;User ID=system;Data Source=ora;Persist Security Info=True"
Set cn = New ADODB.Connection
cn.Open strcn
strora = "select * from dd"
Set rs = New Recordset
rs.CursorLocation = adUseClient
rs.CursorType = adOpenKeyset
rs.LockType = adLockOptimistic
'Set Rs = CN.Execute(strsql)
rs.Open strora, cn, , , adCmdText
Set DataGrid1.DataSource = rs
解决方案 »
- 请问一下.net2003的msdn怎么运行啊??
- 如何访问远程PC的文件系统
- 请各位高手了??
- 这是什么原因??
- 新手问题在线等待
- 还有20天,我要完成一个c/s结构的软件,以前只有单机数据库编程经验,紧急求救!!!
- 100分求助:界面设计问题,高手请进!!
- 怎么向串口发送16进制数字 ?
- 请大家谈谈关于控件的鼠标事件究竟该怎么用好吗?我的一个LISTBOX控件用了Click DbClick Getfouse LostFouse,结果发现双击经常需要双击2
- 请问有谁知道wm_lbuttondown消息中的lparam如何转换成VB中的x,y坐标
- 一个关于表格打印的问题,80分送上
- 一个基础问题快看看
Dim rs As ADODB.Recordset
Dim strcn As String
Dim strora As Stringstrcn = "Provider=MSDAORA.1;Password=manager;User ID=system;Data Source=ora;Persist Security Info=True"
Set cn = New ADODB.Connection
cn.Open strcn
strora = "select * from dd"
Set rs = New Recordset
set rs.a....=cn
rs.CursorLocation = adUseClient
rs.CursorType = adOpenKeyset
rs.LockType = adLockOptimisticrs.Open strora
Set DataGrid1.DataSource = rs
datagrid1.refresh