Hello, To send the changes to the database, we may need to build a CommandBuilder first, for example: Dim objCommandBuilder As New OleDbCommandBuilder(da) daAuthors.Update(ds, "Test") MsgBox("updated successfully") Will you please have a try and tell me the result? For the walkthrough on updating database using DataSet, I recommend you refer to: http://support....
Thread: Syntax Error!  |
|||||||||||||
|
Started 1 month, 4 weeks ago by tonyp86
Hey, I'm having a small prob trying to add a new entry to my access databse,
the program code is:
Imports System.Data
Public Class Form1
Dim inc As Integer
Dim MaxRows As Integer
Dim con As New OleDb.OleDbConnection
Dim ds As New DataSet
Dim da As OleDb.OleDbDataAdapter
Dim sql As String
Private...
|
|
||||||||||||
|
|||||||||||||
Other posts in this thread:
tonyp86 replied 1 month, 3 weeks ago
Sorry but I have already included that code?
Dim cb As New OleDb.OleDbCommandBuilder(da)
Size: 902 bytes
Customize: 
Roahn Luo replied 1 month, 3 weeks ago
Hello, Could I ask if we checked the type? are they matched? Could we generate a small project of the issue? If you will, please zipped the project to my email account: v-roaluo@microsoft.com Thanks a lot!
Size: 247 bytes
Customize:
|
Top contributing authorsRelated threads on "MSDN Forums":Related threads on other sites: |
||||||||||||
Thread profile page for "Syntax Error!" on http://msdn.microsoft.com.
This report page is a snippet summary view from a single thread "Syntax Error!", located on the Message Board at http://msdn.microsoft.com.
This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity
Home |
About Us |
Submit Your Site |
Update Your Site |
Get Search For Your Site |
Partners |
Contact |
Search Plugin |
Blog |
 |
Last Searches | Top Searches |
Designated brands and trademarks are property of their respective owners.
Use of this website constitutes acceptance of BoardReader's User Agreement and Privacy Policy.