Wednesday, January 12, 2011

Insert With Scop Identity

ALTER PROCEDURE AddAdvertisementDetails
@adtitle nvarchar(max),
@adcontent nvarchar(max)

AS
insert into tbl_AdvertisementDetails
(
AdTitle,
AdContent

)
values
(
@adtitle,javascript:void(0)
@adcontent
);
select SCOPE_IDENTITY()

Code Part :
int id =int.Parse(cmd.ExecuteScalar().ToString());

No comments: