[求助]insert into 语句有语法错误?
我写了下面的代码,在调试时老说我的insert into 语句有语法错误,请高手帮帮忙,谢谢啦!!!~~
If number.Text = "" Then
MsgBox("学号不能为空!")
number.Focus()
ElseIf rkk.Checked = False And rzt.Checked = False And rqj.Checked = False Then
MsgBox("请选择要添加的类型!")
Else
Dim fd() As String = {number.Text}
Dim rd As DataRow = DataSet11.kq.Rows.Find(fd)
Dim kk, zt, qj As String
If rd Is Nothing Then
tkk.Text = ""
tzt.Text = ""
tqj.Text = ""
OleDbConnection1.Open()
If rkk.Checked Then
kk = 1
zt = 0
qj = 0
OleDbCommand1.CommandText = String.Format("INSERT INTO kq(number,kk,zt,qj) VALUES('{0}','{1}','{2}','{3}')", number.Text, kk, zt, qj)
ElseIf rzt.Checked Then
kk = 0
zt = 1
qj = 0
OleDbCommand1.CommandText = String.Format("INSERT INTO kq(number,kk,zt,qj) VALUES('{0}','{1}','{2}','{3}')", number.Text, kk, zt, qj)
Else
kk = 0
zt = 0
qj = 1
OleDbCommand1.CommandText = String.Format("INSERT INTO kq(number,kk,zt,qj) VALUES('{0}','{1}','{2}','{3}')", number.Text, kk, zt, qj)
End If
Try
OleDbCommand1.ExecuteNonQuery()
MsgBox("添加成功!")
Catch ex As Exception
MsgBox(ex.Message)
End Try
OleDbConnection1.Close()
Else
MsgBox("该记录已存在,请在右边修改!")
tkk.Text = rd("kk")
tzt.Text = rd("zt")
tqj.Text = rd("qj")
End If
End If
搜索更多相关主题的帖子:
insert 语法 语句 求助