Membru cu cele mai relevante răspunsuri
Hi I'm attempting to update details to an external Microsoft access file, database connection to the file is ok.
I'm getting the following syntax error on line "Dadapt.Update(Dset, "CustomerBook")" :
OleDBException was unhandled
Syntax error in UPDATE statement.
Private Sub btnUpdate_Click(sender As System.Object, e As System.EventArgs) Handles btnUpdate.Click Dim CommandBuild As New OleDb.OleDbCommandBuilder(Dadapt) Dset.Tables("CustomerBook").Rows(count).Item(1) = txtbxName.Text Dset.Tables("CustomerBook").Rows(count).Item(2) = txtSurname.Text Dset.Tables("CustomerBook").Rows(count).Item(3) = txtbxaddress.Text Dset.Tables("CustomerBook").Rows(count).Item(4) = txtbxPost.Text --> Dadapt.Update(Dset, "CustomerBook") MsgBox("Details updated") End Sub
This error only occurs when the dataset is changed before updating.
any suggestions would be great!
- Mutat de Bob_BaoMVP 3 mai 2012 04:25 (From:Visual Studio Tools for Office)
This question would probably be better in a forum that supports database connections. It has nothing to do with the VSTO technology, so you're more likely to get quick and useful asisstance in a forum that specializes in working with data... Would you like us to move it for you?
Cindy Meister, VSTO/Word MVP
- Editat de Cindy Meister MVPMVP 1 mai 2012 07:31 added question about moving