How to show stored procedure result textbox or lebel in C#

Question

Dear experts,

Please,help me.

 

Here is my code

 

 Create procedure [dbo].[NewCase]
@User varchar(50)
AS
Begin
   select count(*) from tblCASdetails as a
inner join tblMaping as b on a.BranchId=b.BranchID
full outer join tblCASClosed as d on a.CAS_No=d.CAS_No
inner join tblUploadFile as c on a.CAS_No=c.CAS_No where d.CAS_Status=''and d.Closed_By='' and b.Res_Person=@User
End