Is there a way to select the value of the PK of the inserted data into sql DB and then store it into a session on ASP.NET C#?
For example: I've insert something into the database. During that insert, I want to return that PK back to me and store it into a session.
Agree this is a somewhat vague question, but hopefully this will help.
Assuming this is SQL Server, you could use scope_identity(). Use a stored procedure to insert the row, and read back the value
e.g. assuming this table
create table Foo(FooId int identity(1,1) primary key, Field varchar(50))
create a procedure
create procedure dbo.usp_FooInsert @fieldValue varchar(50) as insert into Foo(field) values(@fieldValue) select SCOPE_IDENTITY() as InsertedFooId go
Use the procedure in place of your current insert statement and read back the result.