我不想用ADODC控件,我想用记录集对象来与我的表连接,但同时设定几个记录集的话,好象不能用。我这么设的 dim conn as New ADODB.connection dim rs1,rs2,rs3 as New ADODB.recordset 好象不行
Public conn As New ADODB.Connection Public rs1 As New ADODB.Recordset Public rs2 As New ADODB.Recordset Public connStr As StringconnStr="数据库路径" conn.open connStrrs1="select * from 表1" rs2="select * from 表2" 控件1.datasource=rs1 控件2.datasource=rs2
dim conn as New ADODB.connection
dim rs1,rs2,rs3 as New ADODB.recordset
好象不行
Public rs1 As New ADODB.Recordset
Public rs2 As New ADODB.Recordset
Public connStr As StringconnStr="数据库路径"
conn.open connStrrs1="select * from 表1"
rs2="select * from 表2"
控件1.datasource=rs1
控件2.datasource=rs2