How to session the ID

Tan Kai Kai

13y1.7kSQL

Ok now that I have insert a new database in my table how can I session the ID that are just insert into the database?

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Tan Kai Kai13y ago
ok it is the e.g Table 1 I have insert some into table 1 like name, telephone and want I click next it will bring me to the next tab in the same page then I have to update the address and so on into the data then just update into table 1 that what I may how can update the data that I just add into the database?
0
mohan raj13y ago
can you share your stored procedure ?
0
Riyaz Akhtar13y ago
Please refer the below link:
http://forums.asp.net/t/1893177.aspx/1
0
Jignesh Trivedi13y ago
hi,
Please refer following link it might help you to resolve your problem
http://msdn.microsoft.com/en-us/library/ks9f57t0.aspx
http://stackoverflow.com/questions/9319532/return-value-from-sql-server-insert-command-using-c-sharp
0
Tan Kai Kai13y ago
I try your way I got error in the red world

cmd.ExecuteNonQuery like this

String id=cmd.ExecuteScalar().ToString();
Session["UserId"]=id;

Say that

ExecuteScalar: Connection property has not been initialized.
0
Iftikar Hussain13y ago
Hi,
First modify your Stored Procedure to include the below line after the insert statement
SELECT @@IDENTITY

Then in your code where you are executing the sql statement to insert the record in your db, there you need to modify write cmd.ExecuteScalar() instead on cmd.ExecuteNonQuery like this

String id=cmd.ExecuteScalar().ToString();
Session["UserId"]=id;

Let me know if you need more information.

Regards,
Iftikar
0