insert into 老出现语法错误 是怎么回事啊
Private Sub BtSubmit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtSubmit.Click
Try
Dim StrInsert As String = "Insert Into Name,Sex,From,Head,QQ,Email,Homepage,Content Values ('" & TxtName.Text & "','" & RBman.Text & "','" & DDLFrom.SelectedItem.Value & "','" & DDHead.SelectedItem.Value & "','" & TxtQq.Text & "','" & TxtEmail.Text & "','" & TxtHomePage.Text & "','" & TxtContent.Text & "')"
OledbConnection1.Open()
InsertCmd = New OleDb.OleDbCommand(StrInsert, OledbConnection1)
InsertCmd.ExecuteNonQuery()
Catch ex As Exception
Label8.Text = ex.Message
Finally
InsertCmd.Dispose()
OledbConnection1.Close()
End Try
RepeaterBind()
End Sub
老出现Insert Into 的语法错误 数据类型都是文本类型,到底是怎么回事啊
问题点数：0、回复次数：6Top
1 楼libinguest（上善若水）回复于 2005-06-02 23:21:28 得分 0
在insert into 后面加上表名 tablename(要插入的字段) values(写入值)
你的好象没有表名吧!Top
2 楼libinguest（上善若水）回复于 2005-06-02 23:23:26 得分 0
Try
Dim StrInsert As String = "Insert Into 表名没加还有要插入的字段值象Values一样加上括号.再试试看!Name,Sex,From,Head,QQ,Email,Homepage,Content Values ('" & TxtName.Text & "','" & RBman.Text & "','" & DDLFrom.SelectedItem.Value & "','" & DDHead.SelectedItem.Value & "','" & TxtQq.Text & "','" & TxtEmail.Text & "','" & TxtHomePage.Text & "','" & TxtContent.Text & "')"
OledbConnection1.Open()
InsertCmd = New OleDb.OleDbCommand(StrInsert, OledbConnection1)
InsertCmd.ExecuteNonQuery()
Catch ex As Exception
Label8.Text = ex.Message
Finally
InsertCmd.Dispose()
OledbConnection1.Close()
End Try
RepeaterBind()
End SubTop
3 楼nadoo（）回复于 2005-06-02 23:27:34 得分 0
Dim StrInsert As String = "INSERT INTO Table (Name,Sex,From,Head,QQ,Email,Homepage,Content) VALUES ('" & TxtName.Text & "','" & RBman.Text & "','" & DDLFrom.SelectedItem.Value & "','" & DDHead.SelectedItem.Value & "','" & TxtQq.Text & "','" & TxtEmail.Text & "','" & TxtHomePage.Text & "','" & TxtContent.Text & "')"
Top
4 楼50277（柳影随风）回复于 2005-06-02 23:30:30 得分 0
INSERT 语句语法错了！
insert into 表名 values (字段1，字段2，字段3......)Top
5 楼loveno1（keep）回复于 2005-06-02 23:32:07 得分 0
表名没加上去Top
6 楼apcsherry（无敌神勇小超人）回复于 2005-06-02 23:38:43 得分 0
改成
Insert Into 表名（Name,Sex,From,Head,QQ,Email,Homepage,Content） Values ('" & TxtName.Text & "','" & RBman.Text & "','" & DDLFrom.SelectedItem.Value & "','" & DDHead.SelectedItem.Value & "','" & TxtQq.Text & "','" & TxtEmail.Text & "','" & TxtHomePage.Text & "','" & TxtContent.Text & "')"
Top
