Public cnn As New ADODB.Connection
Public cmm As New ADODB.Command
Public rs As New ADODB.Recordset
Public strcnn As StringPublic Sub main()
strcnn = "Provider=sqloledb;Data Source=(local);Initial Catalog=hotel;Integrated Security=SSPI"
cnn.Open strcnnEnd SubPrivate Sub Command1_Click()
Dim sql As Stringsql = "insert into test1 (t1) values( '" & Text1(0).Text & "')"
Set rs = cnn.Execute("sql")
Public cmm As New ADODB.Command
Public rs As New ADODB.Recordset
Public strcnn As StringPublic Sub main()
strcnn = "Provider=sqloledb;Data Source=(local);Initial Catalog=hotel;Integrated Security=SSPI"
cnn.Open strcnnEnd SubPrivate Sub Command1_Click()
Dim sql As Stringsql = "insert into test1 (t1) values( '" & Text1(0).Text & "')"
Set rs = cnn.Execute("sql")
顺便说下,好怪异的结帖率
cnn.execute sql
http://download.csdn.net/source/1498324
Dim sql As String
On Error GoTo er
sql = "insert into test1 (t1) values( '" & Text1(0).Text & "')"
cnn.Execute (sql)
er:
MsgBox Err.Description
提示"对像关闭时,不可以操作"