Question

大家好，有些地方不懂，insert into 表 values（值，）这个值能是表达式吗，为什么我运行一下程序，会出错

OleDbConnection1.Open()
Dim stt As String
Dim a, b, c As Integer
a = TextBox1.Text
b = TextBox2.Text
c = TextBox3.Text
stt = "insert into表1(num,name,age)values(a,b,c)"
OleDbCommand1.CommandText = stt
OleDbCommand1.ExecuteNonQuery()
OleDbConnection1.Close()

Answer 1

你这样试试
stt= "insert into表1(num,name,age)values(' "+a+" ',' "+a+" ',' "+a+" ')"