Getting ID from last inserted record

Hot Topic

Variable doesn't increment
Why is the C# team allowing this to Happen? and Why do they close threads on the topic?
Build .NET application in clustered system
c# tutorial
Close 'X' button problem on child form
How to call a method/property contained in a string variable?
ENCRYPTION
Operator + in strings
remoting WMP in C# - display video?
Binary Data & .Net Sockets, URGENT

Visual C#

Help on Lagging File Seek
key press help
Controlling a web browser control from another form?
How to Access two domain application at same time in single client pc
c#
CheckedListBox displaying blank lines
Allowing a particular class in other namespace to access a method non public method of a class in other namespace
Append text in the first line of files
download mail attachments
Finding your application's root folder

Getting ID from last inserted record

Hi, i'm inserting rows in a table using a stored procedure, but i need the autogenerated ID(by SQL server 2005) from the inserted row as a FK to insert other rows. How is it possible to get that autogenerated ID

Greetz

Answer this question

Getting ID from last inserted record

  • lee d

    Nevermind I already found the solution You have to add this in your stored procedure

    DECLARE @NEWID bigint

    SET @NEWID= (SELECT SCOPE_IDENTITY());

    RETURN @NEWID

    You also add a SqlParameter object in your c# program

    //FCID ID

    SqlParameter newid= new SqlParameter();

    newid.Direction = System.Data.ParameterDirection.ReturnValue;

    newid.ParameterName = "@NEWID";

    objCmd.Parameters.Add(newid);

    Finally you want to get the returnvalue from the stored procedure by doing this:

    SqlParameter newid= objCmd.Parameters["@NEWID"];

    myid = newid.Value.ToString();

    Greetz
  • Getting ID from last inserted record
Answer this question