Hi im using asp.net vs05 with sql05 , I Started on creating a Stored Procedure where i wrote some insert statement and i just got the Auto Generated column value by using Scope identity or @@identity,
But what is my Problem is iam using Bussiness Logic , Xsd file (Table adapter to get access to the Database) , Out there in the Table Adapter i Tried inserting some values , it worked but i couldnt get the Auto Generated Primary key value ?
Is it Possible to Get the (Auto Generated)Inser ted item from the Db if so ! Kindly Provide me with the Valid Code.
But what is my Problem is iam using Bussiness Logic , Xsd file (Table adapter to get access to the Database) , Out there in the Table Adapter i Tried inserting some values , it worked but i couldnt get the Auto Generated Primary key value ?
Is it Possible to Get the (Auto Generated)Inser ted item from the Db if so ! Kindly Provide me with the Valid Code.