TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Leo Lynch
NA
1
0
keep getting syntax error when trying to update database
Apr 23 2009 9:46 PM
i keep getting a "syntax error in INSERT INTO statement"
could i be informed on where my error is here is the code:
Dim cb As New OleDb.OleDbCommandBuilder(da2)
Dim cb2 As New OleDb.OleDbCommandBuilder(da3)
Dim dsNewRow As DataRow
Dim balanceDecimal As Decimal = ds2.Tables("dbInfo").Rows(0).Item(3)
dsNewRow = ds3.Tables("dbInfo").NewRow()
dsNewRow.Item("TransDate") = mtxbDate.Text
dsNewRow.Item("CheckNumber") = Decimal.Parse(txtCheck.Text)
dsNewRow.Item("Desc") = txtDesc.Text
If MessageBox.Show("Is this a withdraw?", "Comfirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question) _
= Windows.Forms.DialogResult.Yes Then
dsNewRow.Item("Withdraw") = Decimal.Parse(txtAmount.Text)
balanceDecimal = balanceDecimal - Decimal.Parse(txtAmount.Text)
ds2.Tables("dbInfo").Rows(0).Item(3) = balanceDecimal
Else
dsNewRow.Item("Deposit") = Decimal.Parse(txtAmount.Text)
balanceDecimal = balanceDecimal + Decimal.Parse(txtAmount.Text)
ds2.Tables("dbInfo").Rows(0).Item(3) = balanceDecimal
End If
ds3.Tables("dbInfo").Rows.Add(dsNewRow)
da3.Update(ds3, "dbInfo") '<---- the error hits here
da2.Update(ds2, "dbInfo")
Reply
Answers (
0
)
Unexplained Error on Grouping
Problem with binary files