how to show Raise Error of Stored procedure in asp.net web site using c#

See more:

C#

ASP.NET

SQL-Server-2008R2

Hi guys,

I have asp.net website using c#

n backend sql server 2008 r2.

where i'm writing stored procedure for insertion.

in my stored procedure.

i have written this code:

IF EXISTS
(
        SELECT * from tbl_jobposted where Posted_Date = @PostedDate and UnitID = @UnitID
)

BEGIN
    RAISERROR  20000 'This Job Already Posted ! '
    RETURN(1)
END

i want to show this message, what i got from the stored procedure, to the user on the screen.

how can i fetch that error n display it on the page.

plz help me.

Thanks