How to show Record Inserted into a table ID by ID in a Label

Abraham Olatubosun

Dear All,

Trust this Question meet you all in happiness and good health.

I am trying to show in a label each record inserted into a table, I mean, as i insert record D1001 it should show in the front end label likewise record D1002, D1003........ so on and so forth. Each record Id should show one after the other.

I know how to Insert the record into a table but when I try passing it to a label it only shows the last record ID.

Please, I need your help as this is an additive to a timeline project.

Thank you all in advance for help

5 Replies

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

Sagar Malde7y ago
Accepted answer
Hi Abraham,

I think you are assigning the ID to the Label text. Instead of assigning the Text (ID) you should append the Id to your Label.

Like
idLabel.Text= idLabel.Text+", "+IdfromDB;
Thanks.
Laxmidhar Sahoo7y ago
yes you all currect
SELECT MAX(LocationID) FROM Production.Location;
GO
INSERT INTO Production.Location (Name, CostRate, Availability, ModifiedDate)
VALUES ('Damaged Goods', 5, 2.5, GETDATE());
GO
SELECT @@IDENTITY AS 'Identity';
GO
--Display the value of LocationID of the newly inserted row.
SELECT MAX(LocationID) FROM Production.Location;
GO
Rajanikant Hawaldar7y ago
Hi Abraham Olatubosun
if your issue resolved mark it as Accepted Answer so that it will be helpfull for others who facing this kind of issues
Abraham Olatubosun7y ago
Many thanks Rajanikant Hawaldar,the SQL statement used here is INSERT INTO TABLE, I am reading from the patient master table feed another table AB, as I populate table AB using sql insert statement in ASP.NET C#, I want to see record ID that was inserted via label control as they were inserted to table AB using C#. Example when you are installing visual studio you see the item been installed displaying as they are currently installing this is what I want to achieve. Thanks all
Rajanikant Hawaldar7y ago
Hi Abraham,
@@IDENTITY returns the last identity value generated for any table in the current session, across all scopes. You need to be careful here, since it's across scopes. You could get a value from a trigger, instead of your current statement.
SCOPE_IDENTITY() returns the last identity value generated for any table in the current session and the current scope. Generally what you want to use.
IDENT_CURRENT('tableName') returns the last identity value generated for a specific table in any session and any scope. This lets you specify which table you want the value from, in case the two above aren't quite what you need (very rare). Also, as @Guy Starbuck mentioned, "You could use this if you want to get the current IDENTITY value for a table that you have not inserted a record into."
The OUTPUT clause of the INSERT statement will let you access every row that was inserted via that statement. Since it's scoped to the specific statement, it's more straightforward than the other functions above. However, it's a little more verbose (you'll need to insert into a table variable/temp table and then query that) and it gives results even in an error scenario where the statement is rolled back. That said, if your query uses a parallel execution plan, this is the only guaranteed method for getting the identity (short of turning off parallelism). However, it is executed before triggers and cannot be used to return trigger-generated values.
https://stackoverflow.com/questions/42648/best-way-to-get-identity-of-inserted-row