当前位置:开发者网络 >> 技术教程 >> .NET教程 >> 数据库应用 >> 内容
精彩推荐
分类最新教程
分类热点教程
  
本地使用RecordSet 对象
作者:未知
日期:2005-08-16
人气:
投稿:(转贴)
来源:未知
字体:
收藏:加入浏览器收藏
以下正文:
Dim i As Integer
    Dim rsConstruct As ADODB.Recordset
    Set rsConstruct = New ADODB.Recordset

'构造Recordset 的字段名和类型
    rsConstruct.Fields.Append "Field1", adInteger
    rsConstruct.Fields.Append "Field2", adVarWChar, 128
    rsConstruct.Fields.Append "Field3", adVarWChar, 128
    rsConstruct.Fields.Append "Field4", adVarWChar, 128
    rsConstruct.Open
    '增加记录至Reocrdset
    If colTemp.count > 0 Then
        For i = 1 To colTemp.count
            rsConstruct.AddNew
                   rsConstruct.Fields("Field1") = 0
                   rsConstruct.Fields("Field2") = colTemp.Item(i).Subject
                   rsConstruct.Fields("Field3") = colTemp.Item(i).Description
                   rsConstruct.Fields("Field4") = colTemp.Item(i).RefURL
            rsConstruct.Update
        Next

相关文章: