大家来看看我这段代码。
Private Sub Cmdadd_Click()
Dim cn As ADODB.Connection
Set cn = New ADODB.Connection
cn.ConnectionString = "dsn=chadata;uid=sa;psw=123"
cn.Open
Dim cmd As ADODB.Command
Set cmd = New ADODB.Command
cmd.ActiveConnection = cn
cmd.CommandText = "insert into data(编号,日期,数量) values('"&text1.text%"',Private Sub Cmdadd_Click()
Dim cn As ADODB.Connection
Set cn = New ADODB.Connection
cn.ConnectionString = "dsn=chadata;uid=sa;psw=123"
cn.Open
Dim cmd As ADODB.Command
Set cmd = New ADODB.Command
cmd.ActiveConnection = cn
cmd.CommandText = "insert into data(编号,日期,数量) values('"&text1.text&"','&text2.text&','"&text3.text&"')"
cmd.Execute
End Sub
其中编号、日期、数量分别是文本、日期、数字类型。数据库用的是sqlserver
老是报缺少语句结束。 哪位能帮帮我。