CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. March 13th, 2005, 09:54 PM #1
    Yarin
    Yarin is offline Junior Member
    Join Date
    Nov 2004
    Posts
    7

    Arrow SqlHelper/Typed Params/@@Identity

    Hi everybody,

    I'm working with SqlHelper and strong-typed datasets, updating my data by means of passing in a typed datarow into the ExecuteNonQueryTypedParams function. I now need to be able to retrieve the @@Identity from the stored procedure- How could I go about this? It seems that by passing in a datarow I don't have room to play with output parameters or the like. Stumped. Thanks...

    -Yarin
    Reply With Quote Reply With Quote
  2. March 14th, 2005, 09:01 AM #2
    Boumxyz2
    Boumxyz2 is offline Senior Member
    Join Date
    Sep 2001
    Location
    Montreal Canada
    Posts
    1,080

    Re: SqlHelper/Typed Params/@@Identity

    Are you using a stored proc ? if so, then just return the @@Identity in your stored proc and use

    ExecuteScalar

    instead.
    Nicolas Bohemier
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules




Click Here to Expand Forum to Full Width

Featured