problem in vb.net

Ayesha Hafeez

Nowadays I am working on one of my assignments in vb.net. Assignment is about making a software that work like ATM.
I am facing problem in this query for the access database
error is syntax error but there is no error as far i know
I will appreciate if you can help
statement is

cmd = New OleDbCommand("INSERT INTO Transaction VALUES('" & WithDrawTxt.Text & "','" & AccountNo.ToString & "','" & dt.ToString & "')", cn)
i = cmd.ExecuteNonQuery

Table Transaction has fields Amount, Account_Number, Transaction_Date and last is Transaction#. All have field text except Transaction# which is auto number.

I have changed it to following statement too but its not working even then

cmd = New OleDbCommand("INSERT INTO Transaction(Amount,Account_Number,Transaction_date) VALUES('" & WithDrawTxt.Text & "','" & AccountNo.ToString & "','" & dt.ToString & "')", cn)
i = cmd.ExecuteNonQuery

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Guest User17y ago
Can you post the contents of the following string:

Dim s as string = "INSERT INTO Transaction(Amount,Account_Number,Transaction_date) VALUES('" & WithDrawTxt.Text & "','" & AccountNo.ToString & "','" & dt.ToString & "')"
Ayesha Hafeez17y ago
Thanx for your concern

but this answer is not solving my problem
Guest User17y ago
In your query, put square brackets around the word "Transaction", as in:

INSERT INTO [Transaction]

"Transaction" is a reserved word, meaning that it can cause problems if you use it as the name of a table or field. By placing square brackets around it you're telling the database that it's the name of an object.