getting the last id

[orangeblue]

Hi
I need to get the last id of the record i have inserted in s sql sever db.

i know in asp i can use @@identity but what to i do with asp.net


the insert code is below
cmdinsert = new sqlCommand("sp_Insert_event", myConnection)
cmdInsert.CommandType = COMMANDTYPE.storedProcedure

cmdInsert.Parameters.Add("@frm_event_type", lstFAQs.text)
cmdInsert.Parameters.Add("@frm_date", cdate(Eventdate.text))
cmdInsert.Parameters.Add("@frm_time", lsttime.text)


cmdInsert.Parameters.Add("@frm_location", txt_location.text)
cmdInsert.Parameters.Add("@frm_desc", frm_desc.text)



and my store proc id


CREATE PROCEDURE sp_insert_event

@frm_event_type int,
@frm_date datetime,
@frm_time nvarchar(10),
@frm_location nvarchar(100),
@frm_desc text,
@id int output



AS


insert tble_events
(
events_type,
events_date,
events_time,
events_location,
events_notes

)
values
(
@frm_event_type,
@frm_date,
@frm_time,
@frm_location,
@frm_desc
)


SELECT @ID = @@identity
GO


please can anyone explain how to do this
thanks
hesh

 

[DotNetGnat]

first off...using Ident_current() instead of @@Identity...

secondly...you need to do something like this in asp.net

myCommand.ExecuteNonQuery()


here is the link:

http://aspnet.4guysfromrolla.com/articles/050602-1.aspx

-DNG

 

[DotNetGnat]

sorry i got little mixed up...you need to you Scope_Identity() and ExecuteScalar()

here is the link on the same topic...

http://www.experts-exchange.com/Pro...Languages/Dot_Net/ASP_DOT_NET/Q_21421666.html

-DNG

 

[Tarwn]

For future reference, there is a forum specifically for ASP.Net located here: forum855