Dim cn As New ADODB.Connection, rs As New ADODB.Recordsetrs.open
For i=0 to 9
rs.AddNew
rs(0) = Date
rs(1) = strCond
rs(2) = strList
rs.UpdateBatch
Next i应该怎么写???
For i=0 to 9
rs.AddNew
rs(0) = Date
rs(1) = strCond
rs(2) = strList
rs.UpdateBatch
Next i应该怎么写???
cn.Open "Provider=SQLOLEDB.1;Password=;Persist Security Info=False;User ID=sa;Initial Catalog=testDB;Data Source=testSvr"rs.Open "select top 1 * from 表",cn,adOpenDynamic ,adLockBatchOptimistic
For i=0 to 9
rs.AddNew
rs(0) = Date
rs(1) = strCond
rs(2) = strList
Next i
rs.UpdateBatch
For i=0 to 9
Adodc1.Recordset.AddNew
Adodc1.Recordset(0) = Date
Adodc1.Recordset(1) = strCond
Adodc1.Recordset(2) = strList
Next i
Adodc1.Recordset.UpdateBatch
zou19820704 你来晚了,不过也表示一下。谢谢两位,我做好了,哈哈。