Re: Updating Access database

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

If changes are present and you're calling Update and the changes aren't
taking, the problem is likely with the update logic. Verify that you have a
key on your table first and that if you're using hte configuration wizard,
that all of the commands are correctly generated. You may need to call
EndCurrentEdit on the binding manager or the datasource so that it's not in
edit mode. Just to test this, go ahead and make your changes, then scroll
down creating a new row, don't put anything in it, then scroll back up to
the row you edited. Close the form and see if that doesn't fix it.
"Radi Radichev" <radi.radichev@xxxxxxxxxxx> wrote in message
news:emJkT2aLGHA.2036@xxxxxxxxxxxxxxxxxxxxxxx
Hi!
So first some info... So I'm adding a dataset to the solution explorer as
a new item. From there i choose my *.mdb file and then the table that i
wish to use. I then create a typed dataset using the wizard. Now i have
two new components in the toolbox. i add a personalTableAdapter and it
gives me that it has generated all needed commands including Update. Next
i added a binding source and set its datasource and data member properties
respectively to dsPersonal1 and personal(thats the tablename). i then add
a datagridview to the form. i use the dataadapters fill method to fill the
dataset on FormLoad event. It works fine. I then change a value and in the
FormClosing event i call the personalDataAdapter1.update(dsPersonal)
method. when i checked in debug mode for changes it returns a dataset with
changes, but when i close and the start the programm the changes are not
there.... I hope that helps you to understand what am I doing. Hope that
you can help me!


"W.G. Ryan - MVP" <WilliamRyan@xxxxxxxxxxxxxxxx> wrote in message
news:epms%23taLGHA.532@xxxxxxxxxxxxxxxxxxxxxxx
Radi:

The first thing to look at is to ensure that you Adapter is configured
correctly for Updates. Are you using the configuration wizard, the
commandbuilder, the enterprise library or did you write your own. If
you're using the Visual tools , make sure that all of the commands were
generated correctly at the end.

If they are, then you need to check the Rowstate of each row. When you
call Update, the adapter loops through the rows and checks the rowstate.
If the rowstate is deleted, then it uses the Adapter's Delete command and
after submitting the update, calls AcceptChanges on the row which resets
the rowstate on the row. It does the same for Inserts and Updates.
However, if you don't have Changes in your rows, then nothing gets
submitted to the server. One way to verify that is to trap the
StateChanged event of the connection and pop up a messagebox when the
state changes. if you don't see a messagebox then nothing go sent back
tot he server (in Sql Server as opposed to access, you can use Profiler
but since you're not using Sql Server, I just mention it in passing).
The better way to check for changes is to use
Debug.Assert(dsPersonal1.HasChanges, "No Changes Are Present"); right
before you call Update. If the assertion passes, then you have changes
and if the DB isn't getting updated, then the problem is almost certianly
with your commands themselves. If the assertion fails, then the problem
is that the UI isn't updating as you expected and more than likely, you
need to End the current edit of the row. You do this differently
depending on how you're binding things.

So first, verify that you have correct commands and more importantly,
verify that you have changes to be sumbitted. 99% of the time it's one
or both of these issues. if it isn't, let me know and we'll take it from
there.

Cheers,

Bill
"Radi Radichev" <radi.radichev@xxxxxxxxxxx> wrote in message
news:OYR3ucaLGHA.4060@xxxxxxxxxxxxxxxxxxxxxxx
Hi!
I have a Typed Dataset dsPersonal1 and i try to update the database
after i edit a row in a datagrid bound to the dataset. Afret I execute
personalDataAdapter1.Update(dsPersonal1) the dataset is updated but not
the actual database.Can anyone tell me what am I doing wrong? I'm usinf
Visual C# Express and .net 2.0. Please explain me how do I update the
actual database...
Thanks!







.

Relevant Pages

  • Re: Updating Access database
    ... it has generated all needed commands including Update. ... then you need to check the Rowstate of each row. ... since you're not using Sql Server, I just mention it in passing). ... So first, verify that you have correct commands and more importantly, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Updating Access database
    ... Verify that you have changes, the update is correct (sounds like ... that all of the commands are correctly generated. ... then you need to check the Rowstate of each row. ... access, you can use Profiler but since you're not using Sql Server, I ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Updating Access database
    ... Verify that you have changes, the update is correct (sounds like ... commands including Update. ... then you need to check the Rowstate of each row. ... access, you can use Profiler but since you're not using Sql Server, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Updating Access database
    ... it gives me that it has generated all needed commands including Update. ... then you need to check the Rowstate of each row. ... One way to verify that is to trap the ... tot he server (in Sql Server as opposed to access, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Updating Access database
    ... that all of the commands are correctly generated. ... then you need to check the Rowstate of each row. ... One way to verify that is ... access, you can use Profiler but since you're not using Sql Server, I ...
    (microsoft.public.dotnet.framework.adonet)