Re: How Do I setup a RowChangedEvent in a Typed DataSet

It seems to me I discussed this in my article posted to Developer.Com. See the article on using the TableAdapter for Hierarchical ops.

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker’s Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________
"Devon-S" <DevonS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:5F423902-C699-4A86-9AB8-2DF6757AA1D4@xxxxxxxxxxxxxxxx
Greetings,

I have a strongly typed dataset and when I write the identity column to the
database, I set it and retrieve it. This works fine.

Now I want an event to trigger for each record that is set and retrieved
from the DataSet to update the children of the DataSet with the new identity
column.

The DataSet Created two Classes for the Products Class called

ProductsRowChangeEvent - and -
ProductsRowChangeEventHandler

which will probably do the trick if I knew how to use them, or could find
some documentation on these two Classes.

Any thoughts would be greatly appreciated.


-Devon



.

Relevant Pages

  • Refresh not working on TableAdapter
    ... so I've read various articles on setting up a TableAdapter to ... retrieve a newly generated identity column value back into the dataset ... So then I name this new insert "InsertSingleRecord" (I've tried this ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SSIS - Retrieve Identity from DB-DataFlow Destination(ID after ins
    ... > Is there an easy method to retrieve a identity value during/after a row is ... > 3) Create customer record with the AddressID (identity column) from ...
    (microsoft.public.sqlserver.dts)
  • SQLCeCommandBuilder...
    ... I retrieve a dataset with 0-1 rows of a table. ... an identity column as primary key. ... Identity column is selected into the ... Dim dcConn As New SqlCeConnection ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: SqlCommand which INSERTS and then SELECTs single value
    ... The Select statement to retrieve the Identity column can just be: ... You can append it to the INSERT statement separated by a semi-colon and use ExecuteScalar to execute the INSERT and retrieve the new Identity. ... The CommandText consists of the INSERT followed by and separated by a; ...
    (microsoft.public.dotnet.framework.adonet)