代码如下,错误提示为找不到对象,恳请大牛指教Dim cnn As ADODB.Connection
Dim rs_section As ADODB.Recordset
Dim rs_link As ADODB.Recordset
Dim cm As New ADODB.Command
Dim sqlstr1 As String
Dim sqlstr2 As String Set cnn = New ADODB.Connection
cnn.Open "DSN=" & str1, str2, str3
Set rs_section = New ADODB.Recordset
Set rs_link = New ADODB.Recordset
sqlstr1 = "select * from " & table_section
rs_section.CursorLocation = adUseClient
rs_section.Open sqlstr1, cnn, adOpenDynamic, adLockOptimistic
sqlstr2 = "select * from " & table_link
rs_link.CursorLocation = adUseClient
rs_link.Open sqlstr2, cnn, adOpenDynamic, adLockOptimistic
rs_section.AddNew
rs_link.AddNew
For i = 1 To jn
rs_link.Fields(0) = rs.AbsolutePosition
rs_link.Fields(1) = jsl(i).gridn & jsl(i).linkN
rs_link.Fields(2) = jsl(i).time
rs_link.Fields(3) = jsl(i).traveltime
rs_link.Fields(4) = jsl(i).n
rs_link.Fields(5) = jsl(i).lev
rs_link.AddNew
For j = 1 To jsl(i).n
rs_section.Fields(0) = rs.AbsolutePosition
rs_section.Fields(1) = jsl(i).gridn & jsl(i).linkN
rs_section.Fields(2) = jsl(i).jsects(j).time
rs_section.Fields(3) = jsl(i).n
rs_section.Fields(4) = jsl(i).jsects(j).lev
rs_section.Fields(5) = jsl(i).jsects(j).s
rs_section.Fields(6) = jsl(i).jsects(j).l
rs_section.Update
rs_section.AddNew
Next j
Next i
Dim rs_section As ADODB.Recordset
Dim rs_link As ADODB.Recordset
Dim cm As New ADODB.Command
Dim sqlstr1 As String
Dim sqlstr2 As String Set cnn = New ADODB.Connection
cnn.Open "DSN=" & str1, str2, str3
Set rs_section = New ADODB.Recordset
Set rs_link = New ADODB.Recordset
sqlstr1 = "select * from " & table_section
rs_section.CursorLocation = adUseClient
rs_section.Open sqlstr1, cnn, adOpenDynamic, adLockOptimistic
sqlstr2 = "select * from " & table_link
rs_link.CursorLocation = adUseClient
rs_link.Open sqlstr2, cnn, adOpenDynamic, adLockOptimistic
rs_section.AddNew
rs_link.AddNew
For i = 1 To jn
rs_link.Fields(0) = rs.AbsolutePosition
rs_link.Fields(1) = jsl(i).gridn & jsl(i).linkN
rs_link.Fields(2) = jsl(i).time
rs_link.Fields(3) = jsl(i).traveltime
rs_link.Fields(4) = jsl(i).n
rs_link.Fields(5) = jsl(i).lev
rs_link.AddNew
For j = 1 To jsl(i).n
rs_section.Fields(0) = rs.AbsolutePosition
rs_section.Fields(1) = jsl(i).gridn & jsl(i).linkN
rs_section.Fields(2) = jsl(i).jsects(j).time
rs_section.Fields(3) = jsl(i).n
rs_section.Fields(4) = jsl(i).jsects(j).lev
rs_section.Fields(5) = jsl(i).jsects(j).s
rs_section.Fields(6) = jsl(i).jsects(j).l
rs_section.Update
rs_section.AddNew
Next j
Next i
解决方案 »
- VB 如何实现 畸形 界面(不规则窗体)???
- TextBox如何支持维吾尔文的输入?
- 如何让VB纵向显示数据?
- 求高手一个问题..希望给个详细的解释(代码)谢谢了阿
- 请教:在SQL Server里如何定义一个a[100]这样的数组?SQL Server里有没有象VB的split那样的函数?
- 用全部家當換一個答案
- 在datagrid中如何获得当前选中行的行号
- apigid32.dll什么用处呢?代码怎么理解呢?
- 还是右键弹出菜单问题??看看哪里有错?
- 我是一位学编程的新手请大家多指导呀!!!
- 小弟是个初学者,想问问师兄们怎么样显示TreeView里的垂直和水平的滚动条啊?
- 菜鸟的MDI窗口创建问题
你为什么不把rs_section.Fields(0)改写成rs_section.Fields("name")??其中name是字段名。这样的好处是直观些,特别是字段多的时候一看name字段名就明确是哪个字段了。这是一个好习惯!!!!!!!