scope_identity not working

yogarajan

hi am developing c# project am create dataset and dataadapter my code here

Expand|Select|Wrap|Line Numbers

 
shoppingDataSet1TableAdapters.productdetailsTableAdapter productadapter = new shoppingDataSet1TableAdapters.productdetailsTableAdapter();

            int productid = productadapter.insertproduct(categoryid, productname, productdesc, prodcutrate, isnew,brandid, picname);

my sql statement here

Expand|Select|Wrap|Line Numbers

 INSERT INTO [productdetails] ([categoryid], [productname], [productdesc], [rate], [status], [isnew], [brandid], [homeimg]) VALUES (@categoryid, @productname, @productdesc, @rate, 1, @isnew, @brandid, @homeimg);

select @@identity as  productid

but it is always return 1

pls help

ck9663

Here, read this...

Good luck!

--- CK

pankajvtcse

Insted of "select @@identity as productid[/code]"
You can use select SCOPE_IDENTITY()

_Pankaj Tambe

scope_identity not working

re: scope_identity not working

re: scope_identity not working

Similar Microsoft SQL Server bytes

/bytes/development

/bytes/it

/bytes/about