Re: Updating Access database

I've changed my Update Query and when i execute it it runs perfectly but i
still can't update the database when i close the program.... Any Ideas??


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