>How to return the autoinc field from sql server. >I think the @@identity should do the work but am confused with the insertrefreshcmd. >Rajesh
*** I suppose you use CursorAdapter*** Let's say the identity column in your table is named IDthis.InsertRefreshCmd = [SELECT Id FROM MyTable WHERE Id = @@IDENTITY]this.InsertCMDRefreshFieldList = [Id]
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller The only thing normal about database guys is their tables.