向数据库写入数据时的问题
qong 2003-10-16 11:42:04 小弟遇到以下问题:
rivate Sub Command1_Click()
Dim aa As String
Dim bb As String
Dim cc As String
Dim dd As String
Dim ee As String
Dim ff As String
aa= Text1.Text
bb = Text2.Text
cc = Text3.Text
dd = Text4.Text
ee = Text5.Text
ff = Text6.Text
Dim cnn As ADODB.Connection
Set cnn = New ADODB.Connection
Dim cmd As ADODB.Command
Set cmd = New ADODB.Command
cnn.ConnectionString = "Provider=SQLOLEDB;User ID=sa;Password=;database=gaojianchuli;Data Source=(local)"
cnn.Open
cmd.CommandText = "insert into zuozhe(aa,bb,cc,dd,ee,ff)values('aa,'bb','cc','dd','ee','ff)"
cmd.ActiveConnection = cnn
cmd.Execute
cnn.Close
Set cnn = Nothing
End Sub
我设计了六个textbox用于输入
但每次输在数据库的是aa,bb,cc,dd,ee,ff
我也知道values内的值要是常量
是不是向表内插入数据不能用这条语句,应用recordset对象的addnew方法
各位高手是否有类似的经历,望指点。。。