>>> Use IDataAdapter's RowUpdated event. >> >> And whar next? Fill new dataset and merge it with existing?
>It's up to you ;-) >> Why would you need this when you could use INSERT ... RETURNING? >> >> It's not clear for me how to return values from this command. I've >> generated INSERT command, but in execute mode i see only NonQuery and >> Scalar. IMHO It sounds like you are doing something that the table adaptor might not be the best fit for. I have never been a big fan of loading a million records (or anything close to that in a data set) on a client machine. No matter what solution you use to refresh you data it's going to be expensive on the server and the client. You may want to consider writing a stored procedure for your inserts that has a returning value of the generator for each insert that you do. Then instead of using a table adaptor, you can write a class and use a generic collection to store the data (much faster). You will have to write the S,I,U,D methods yourself, but you can then capture the return values for each row you updated or insert. This is a very common practice where I work, and then it is easy to get the row ID of the row being inserted. Steven Ramacher Sramacher @ valleyit net ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
