添加动态数据.frm

来自「vb 中数据库的调用」· FRM 代码 · 共 41 行

VERSION 5.00
Begin VB.Form 添加动态数据 
   Caption         =   "Form1"
   ClientHeight    =   3090
   ClientLeft      =   60
   ClientTop       =   450
   ClientWidth     =   4680
   LinkTopic       =   "Form1"
   ScaleHeight     =   3090
   ScaleWidth      =   4680
   StartUpPosition =   3  '窗口缺省
End
Attribute VB_Name = "添加动态数据"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim cn As ADODB.Connection
Dim cmd As ADODB.Command
Attribute cmd.VB_VarHelpID = -1
Private Sub Form_Load()
Dim par2(12) As String
Dim i As Integer


'打开数据库
Set cn = New ADODB.Connection
Set cmd = New ADODB.Command
cn.ConnectionString = "DSN=student" '设定数据源名称为student
cn.Open

'动态存储数据
For i = 1 To 9 Step 1
      par2(i) = "Jose" & i & ""
      strSQL = "INSERT INTO Customers (FirstName, LastName) VALUES ('" & par2(i) & "','" & par2(i) & "')"
      cn.Execute (strSQL)
Next i
      cn.Close
End Sub