Re: Updating Access database

When you say the changes are there, then aren't, is the same dataset being
used (the same instance) or do you fill it each time when the form opens?
"Radi Radichev" <radi.radichev@xxxxxxxxxxx> wrote in message
news:OC9zfZcLGHA.3492@xxxxxxxxxxxxxxxxxxxxxxx
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
    ... 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
    ... 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
    ... 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