Printable View
Hi all ive just started using the SQLHelper and am in need of inserting a record and returning the @@identity
im using the transaction method but it does not return anything "its not ment to"
reading the help file it got members and one of them is
ExecuteReaderTypedParams
Executes a command that returns rows as a SqlDataReader using a DataRow’s column values as parameters.
but how to in invoke it ???
Here is an example : http://www.vbforums.com/showthread.p...%40%40identity
hey pirate
i know how to do @@indentity but i would like to know and to do it using the microsoft data access block (sqlhelper)
many thanks
Sorry dude , I've never worked on that thing before but I believe the concept is identical . You might need to change OLE prefix for Sql prefix .Quote:
Originally posted by carlblanchard
hey pirate
i know how to do @@indentity but i would like to know and to do it using the microsoft data access block (sqlhelper)
many thanks
You probably are going to have to make a SqlParameter that is an output one. Then you can set it's value to the identity in the procedure. When the procedure returns, you then access the value of this parameter to get it.
I don't have specific code for this, but it seems pretty simple.