can any one share me asp c# code to mention sql asp c# code

Question

Dear Sir ,

 can any one share me asp c# code to mention sql query.

CREATE TABLE [dbo].[Test]

(

[Id] INT NOT NULL PRIMARY KEY,

[ pr_name] VARCHAR(50) NULL,

[ pr_price] VARCHAR(50) NULL,

[UniqueID] VARCHAR(50) NULL

)

DECLARE @Test AS TABLE(Id INT,pr_name VARCHAR(10),pr_price INT)

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