Re: Updating Access database

Ahm I can't seem to fix it:(
I saw the update Command and ist seems fine.. I must add though that I call
the Personal form from another from. and when i close the personal form and
start it again without closing the main form the changes are there. but when
i clos the main form and run it again and call personal form there are no
changes... can this be the problem??

greetz:)
"W.G. Ryan - MVP" <WilliamRyan@xxxxxxxxxxxxxxxx> wrote in message
news:udw5E6bLGHA.2064@xxxxxxxxxxxxxxxxxxxxxxx
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
    ... 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
    ... 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
    ... 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)
Loading