Methoun Ahmed

Methoun Ahmed

  • NA
  • 145
  • 99.3k

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

Sep 14 2018 4:18 AM
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 

Answers (1)