i'm a newbee, so maybee a simple question
i have a parent table, with , lets say an id, and another field
i have another table, the child table which uses the id of the parent, for the master-detail relation.
the id is defined as datatype int, allow nulls = no, unique = yes, primary key = yes, identity=true, identityIncrement=1, identitySeed=1
so the id is auto incremented.
i am using ado.net and have a SqlCeDataAdapter, and SqlCeCommand to set InsertCommand
when inserting data and calling the Update() method of the SqlCeDataAdapter, reload the table, i see a nice id.
but, before the table is updated, the Id field is empty, and i would like to see what the id is, because i have also a child table which uses this id.
so, how can i see the id, or how can i add the values to the child, and use a reference (the id or something else) before updating the table ? or is it better to use another technique. I would like to work with the dataset because the data is loaded in memory,
and will not save everytime the changes.
if you know some nice samples, please let me know.
thanks ! andy
View Complete Post