Unable to Update Data table in Access Database via ADO
- From: "DesmondT" <DesmondT@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 21 Jun 2005 05:39:04 -0700
Here is exactly what I am trying to accomplish: I have my information stored
in a Microsoft Access Database and I am using Microsoft Visual Studio 2003 to
build a front end to gain access to the database.
Step 1: I used the OleDbConnection to create a connection to the
Database (conProjectAllProjectFields)
Step 2 : I used the OleDbDataAdapter to create a data adapter
(oledataadaAllProject) and wrote a querywithin the adapter query window
(Select * from Project)
Step 3 : I created a data set (dsAllProject)
Step 4: I then created some text boxes to represent each field
Step 5: I then bind each text box to the data set via the Binding-Text
property of the text box.
Clear and Fill the data set
------------------------------
dsAllProject.Clear()
oledataadaAllProject.Fill(dsAllProject)
ACCEPT THE CHANGES
----------------------------------
oledataadaAllProject.Update(dsAllProject, "PROJECT")
dsAllProject.PROJECT.AcceptChanges()
After all that the modified data does not gets pushed to the taable
Thenks a million
.
- Follow-Ups:
- Re: Unable to Update Data table in Access Database via ADO
- From: Brendan Reynolds
- Re: Unable to Update Data table in Access Database via ADO
- Prev by Date: Re: Driving Excel from a DataSet
- Next by Date: How to Synchronize Disconnected Recordset with Datbase Changes?
- Previous by thread: invalid property value
- Next by thread: Re: Unable to Update Data table in Access Database via ADO
- Index(es):