scope_identity not working

[yogarajan]

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

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

my sql statement here

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