dim conn as new adodb.connection dim strsql as string '建立连接 ... '建立sql语句 strsql = "delete..." '执行 conn.execute(strsql)
Option Explicit Dim com As Command Dim cn As Connection Set com = New Command Set cn = New Connection cn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=LiubingTest;Data Source=server" cn.Open com.CommandType = adCmdStoredProc com.CommandText = "AddStudent" red.Open End Sub
dim strsql as string
'建立连接
...
'建立sql语句
strsql = "delete..."
'执行
conn.execute(strsql)
Dim com As Command
Dim cn As Connection
Set com = New Command
Set cn = New Connection
cn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=LiubingTest;Data Source=server"
cn.Open
com.CommandType = adCmdStoredProc
com.CommandText = "AddStudent"
red.Open
End Sub