VB.NET向access数据库插入数据出错

[podongxi100]

Dim conn As OleDbConnection
Dim sql As String
Dim rs As New DataSet()
Dim cmd As OleDbCommand
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
If Trim(userID.Text) <> "" Then
sql = " INSERT INTO user ( userid, username, userpw , userstyle ) VALUES ('" + userID.Text + "','" + username.Text + "','" + userPW.Text + "','" + ComboBox1.Text + "')"
cmd = New OleDbCommand(sql, conn)
Dim exp As Exception
Try
conn.Open()
cmd.ExecuteNonQuery()
conn.Close()
MessageBox.Show("添加记录成功")
Catch exp
MessageBox.Show("发生错误，没有正常添加记录")
End Try
End If
Call binddata()
End Sub
插入的数据类型都是文本的

[fairy4]

不用try，看输出什么错误！！！！！！！！

[amandag]

sql = " INSERT INTO [user] ( userid, username, userpw , userstyle ) VALUES ('" + userID.Text + "','" + username.Text + "','" + userPW.Text + "','" + ComboBox1.Text + "')"

user是sql的关键字，请加[]

[ymx1121]

[Quote=引用 2 楼 amandag 的回复:]
sql = " INSERT INTO [user] ( userid, username, userpw , userstyle ) VALUES ('" + userID.Text + "','" + username.Text + "','" + userPW.Text + "','" + ComboBox1.Text + "')"

user是sql的关键字，请加[]
[/Quote]

楼主正解!

[chamme]

不要用 " + " 用 " & "

[podongxi100]

没有什么错误，就是不能插入数据，cmd.ExecuteNonQuery()执行完了以后直接跳到了 Catch exp，该怎么改啊