Generate UniqueId from two Columns using C# and VB.Net in ASP.Net

Refer below query.

SQL

DECLARE @Test AS TABLE(Id INT,pr_name VARCHAR(10),pr_price INT)
INSERT INTO @Test VALUES(1, 'Apple', 100)
INSERT INTO @Test VALUES(2, 'Mango', 200)
INSERT INTO @Test VALUES(3, 'Banana', 300)

SELECT *,SUBSTRING(pr_name,1,3)+RIGHT('000'+CONVERT(VARCHAR(3), Id),3) UniqueID FROM @Test

Output

Id    pr_name    pr_price    UniqueID

1    Apple         100         App001

2    Mango        200         Man002

3    Banana       300         Ban003