hiraldesai
Posts: 38
|
| Posted: 03/05/2007, 10:00 PM |
|
Hi,
I have got a simple editable grid that uses just one database table with no custom insert/updates/deletes on a page. The database I am using is SQL server and the primary key field is set to auto generate. There are 3 empty rows on this grid for insertion.
All I want to be able to do is every time the grid is submitted, I want to get the value of the primary key field that got affected by the insert/update/delete operations performed on the back-end and use all those primary key field values to do some custom stuff after all grid operations are performed.
I have used Nicole's example (http://forums.codecharge.com/posts.php?post_id=60507) as a start point to loop through the grid records on server side. But as the inserts are done all at once and not one for each row, i am not able to get the identity field using CCDLookUp (see below) and I have got no idea about how to get ID of the only records that are updated/deleted not the ones which are left as is.
CCDLookUp("@@identity","Table_Name","",DBConnection)
Any help on this would be greatly appreciated.
Many Thanks...
_________________
-------
Hiral |
