SQL Helper Inserting records and returning the ID

[carlblanchard]

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 ???

[Pirate]

Here is an example : http://www.vbforums.com/showthread.p...%40%40identity

[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

[Pirate]

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

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 .

[hellswraith]

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.