Data base insert Error HELP!

[Bonzol]

Can someone tell me why I get this error

"An unhandled exception of type 'System.Data.OleDb.OleDbException'
occurred in system.data.dll"

when i do this

Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles btnAdd.Click
Dim strSQL As String
Dim cmd As OleDbCommand
strSQL = "INSERT INTO
Engineer(Eng-name,Eng-Qual,Eng-Mobile,Eng-Phone,Eng-NOK,Spec-ID)
VALUES([txtName.Text] ,[txtQual.Text], [txtMobile.Text],
[txtPhone.Text], [txtNOK.text] ,[Spec-ID.Text] )"
cmd = New OleDbCommand(strSQL, OleDbConnection1)
OleDbConnection1.Open()
cmd.ExecuteNonQuery()

End Sub

Thanx

[Cor Ligthert [MVP]]

Bonzol,

Are you sure that there is a primary key in those updates.

(The same as with your first question which should work as well)

Cor

"Bonzol" <Bo****@hotmail.com> schreef in bericht
news:11********************@i40g2000cwc.googlegrou ps.com...

Can someone tell me why I get this error

"An unhandled exception of type 'System.Data.OleDb.OleDbException'
occurred in system.data.dll"

when i do this

Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles btnAdd.Click
Dim strSQL As String
Dim cmd As OleDbCommand
strSQL = "INSERT INTO
Engineer(Eng-name,Eng-Qual,Eng-Mobile,Eng-Phone,Eng-NOK,Spec-ID)
VALUES([txtName.Text] ,[txtQual.Text], [txtMobile.Text],
[txtPhone.Text], [txtNOK.text] ,[Spec-ID.Text] )"
cmd = New OleDbCommand(strSQL, OleDbConnection1)
OleDbConnection1.Open()
cmd.ExecuteNonQuery()

End Sub

Thanx

[Bonzol]

The Primary key is an autogenerated number not to be inputed, via the
form, does that matteR?

[Cor Ligthert [MVP]]

Bonzol,

You can add this to your code and have than a look what it says.

Try
cmd.ExecuteNonQuery()
Catch ex as OleDBException
messagebox.show(ex.Tostring)
Cor

I am curious what it says,

Cor

"Bonzol" <Bo****@hotmail.com> schreef in bericht
news:11**********************@h76g2000cwa.googlegr oups.com...

The Primary key is an autogenerated number not to be inputed, via the
form, does that matteR?

[Bonzol]

It says

System.Data.oleDB.OleDbException: Syntax error in INSERT INTO
statement.
at System.data.OleDb.OleDbComman.ExecuteCommandTextEr rorHanding(Int32
hr)
at System.data.OleDb.OleDbComman.ExecuteCommandTextFo rSingle
Result(tagDBPARAMS dbParams, Object& executeResult)
at System.data.OleDb.OleDbComman.ExecuteCommandText(O bject&
executeResult)
at System.data.OleDb.OleDbComman.ExecuteCommand(Comma ndBehavior,
Object& executeResult)
at System.data.OleDb.OleDbComman.ExecuteCommandComman dBehaviour
behaviour, String method)
at System.data.OleDb.OleDbComman.ExecuteCommand.Execu teNonQuery()
at.Project1.frmNewEngineer.btnAdd_click(obkect sender, EventArgs e) in
E c:\inetpub/wwwProject1\newEngineer.vb:line 326

[Cor Ligthert [MVP]]

Bonzol,

Doi, you did not follow the code from Ghost.....

Have a look at that last part about the parameters in his code.

Cor

[Bonzol]

yeah, I had a problem with it, and am waiting a reply in that other
thread