Re: Unable to Update Data table in Access Database via ADO


You need to call the Update method of the DataAdapter before you call the
AcceptChanges method of the DataSet. Take a look at the article at the
following URL, particularly the section 'Updating Rows in a DataSet'.

--
Brendan Reynolds (MVP)

"DesmondT" <DesmondT@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1F18482D-BEBD-455B-BBA7-605828AD447D@xxxxxxxxxxxxxxxx
> 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
>


.

Relevant Pages

  • ADO.net update problem with VB and MS Access
    ... ADO.net to retrieve the information from the database. ... the update method in ADO.NET should be able to ... Private Sub SaveData() ... Protected Sub initalizeDataAdapter(ByVal cmdSel As OleDbCommand, ...
    (microsoft.public.dotnet.framework.adonet)
  • ADO update problem
    ... ADO.net to retrieve the information from the database. ... the update method in ADO.NET should be able to ... Private Sub SaveData() ... Protected Sub initalizeDataAdapter(ByVal cmdSel As OleDbCommand, ...
    (microsoft.public.vb.database.ado)
  • Re: DataSet updates
    ... > individual DataTables. ... > DataSet back to the database. ... and how the DataSet processes multiple records on the database ... > when it's Update method is called. ...
    (microsoft.public.dotnet.framework.aspnet)
  • ADO Update Problem
    ... I am using an Access Database to store question information for a ... ADO.net to retrieve the information from the database. ... parameter queries work because data is being returned and update, ... the update method in ADO.NET should be able to ...
    (microsoft.public.dotnet.framework.adonet)
  • ADO Update Problem
    ... I am using an Access Database to store question information for a ... ADO.net to retrieve the information from the database. ... parameter queries work because data is being returned and update, ... the update method in ADO.NET should be able to ...
    (microsoft.public.vb.database.ado)