vb能不能同时连接两个数据库并同时创建两个记录集啊?
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim cn1 As New ADODB.Connection
Dim rs1 As New ADODB.Recordset
cn.Open "upgisdb", "sa", "opensoft"
rs.Open "select * from y_gytdsp", cn, adOpenDynamic, adLockBatchOptimistic
cn1.Open "fan", "sa", "sijihuacheng2004"
rs1.Open "select * from out_land_provide", cn1, adOpenDynamic, adLockBatchOptimistic
cn1.Execute "delete from out_land_provide"
rs.MoveLast
rs.MoveFirst
Do While Not rs.EOF If rs!htze >= "2004-1-1" Then
rs1.AddNew
rs1!region_code = "210100"
rs1!land_place = rs!tdzl
rs1.Update
End If
rs.MoveNext
Loop Text1.Text = rs!htze
End Sub
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim cn1 As New ADODB.Connection
Dim rs1 As New ADODB.Recordset
cn.Open "upgisdb", "sa", "opensoft"
rs.Open "select * from y_gytdsp", cn, adOpenDynamic, adLockBatchOptimistic
cn1.Open "fan", "sa", "sijihuacheng2004"
rs1.Open "select * from out_land_provide", cn1, adOpenDynamic, adLockBatchOptimistic
cn1.Execute "delete from out_land_provide"
rs.MoveLast
rs.MoveFirst
Do While Not rs.EOF If rs!htze >= "2004-1-1" Then
rs1.AddNew
rs1!region_code = "210100"
rs1!land_place = rs!tdzl
rs1.Update
End If
rs.MoveNext
Loop Text1.Text = rs!htze
End Sub
解决方案 »
- 晒晒自己的表格控件
- 在VB中用webbrowser加载word文档后,怎么另存不了?
- 一个WINSOCK问题
- 现在什么认证最有用?
- listview中为report模式时,一行中最多前面由一个smallicon,如果要在一行的前面加入好几个图片如何做?就像outlook一样,前面用几个图片
- 急!如何使得web browser 控件显示*.bmp文件
- help!VB fans. mscomm32.ocx need
- 急死我了!!公司让把原来的一个软件里的activebar改成vb自己带的菜单,我想问一下我改怎吗该,用改程序吗?我是用toobar?还是coolbar?去改?
- 为什么不能运行?
- 天好热啊,我们这里有38度!!!!!!!!!!!!!!
- 使用WebBrowser的一个小问题。
- 谁给我解释一下option explicit关键字是起什么作用的?
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim cn1 As ADODB.Connection
Dim rs1 As ADODB.Recordset需要在定义后加:
Set cn=new adodb.connection
set rs=new adodb.recordset
Set cn1=new adodb.connection
set rs1=new adodb.recordset
另记得在最后关闭记录集和连接
Cn.close
rs.close
Cn.close
rs1.close
cn1.Execute "delete from out_land_provide"这两句似乎应该交换一下位置吧?
rs.MoveFirst
2、把adOpenDynamic 换成adOpenDynaset 试试。。
?