Re: Transaction and RowState problem

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

I want to keep the data that user has entered..
In master table after inserting I return the Identity column.
If I set the UpdatedRowSource InsertCommand to UpdateRowSource.None it
keeps the RowState but dosen't update Identoty column.


"Dave Sexton" <dave@jwa[remove.this]online.com> wrote in message
news:%23PGO0Cd$GHA.3380@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

Try calling DataRow.RejectChanges().

--
Dave Sexton

"perspolis" <rezarms@xxxxxxxxxxx> wrote in message
news:u7j1cgc$GHA.3536@xxxxxxxxxxxxxxxxxxxxxxx
Hi all
I have a master detail table which I use them in Transaction to Update
them.
in some cases the detail table generates error and I Rollback transaction
but RowState of master table dosen't go back to previous state and no
data
has entered in database yet but in my master table in memory it has
data..
????
how can I change RowState of master table to previous RowState before
begining Save.

thanks in advance








.

Relevant Pages

  • Re: Transaction and RowState problem
    ... In the 2.0 framework you can just call the SetAddedmethod on the master ... DataRow to return its RowState back to Added, ... In earlier versions of the framework you'll have to remove the row and then ... In either case, setting UpdatedRowSource to None isn't really necessary, ...
    (microsoft.public.dotnet.languages.csharp)
  • binder.Current.row.rowstate not reflecting actual state of child row
    ... master along with a datadgrid for the child data. ... CheckRowSTate looks at the rowstate and calls the SaveRecord routnine if ... Call saveRecord() ... The problem i'm having is this: after changing a value in the child ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Transaction and RowState problem
    ... I have a master detail table which I use them in Transaction to Update them. ... but RowState of master table dosen't go back to previous state and no data ...
    (microsoft.public.dotnet.languages.csharp)
  • Transaction and RowState problem
    ... I have a master detail table which I use them in Transaction to Update them. ... in some cases the detail table generates error and I Rollback transaction ... but RowState of master table dosen't go back to previous state and no data ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Getting autonumber after insert
    ... If the identity column is included in your recordset on the master, ... > I just need someway to capture that number. ...
    (borland.public.delphi.database.ado)