Sqlserver2005: How to get the error message thrown from Storedproc to C#

[ssknov]

hi

i had created as SP to delete the record using where condtn.if the record doesnt exists the SP will throw an error as "No such record found" and return 0 .

But my c# code gets -1 rows affected from the sql.its ok.
My problm is how to get the "No such record found" from sql to c#.

ALTER PROCEDURE SP_deleteUserMaster
@LoginId nvarchar(30)
AS
begin
set nocount on
declare @ncnt int
select @ncnt=(select count(*)from UserMaster where LoginId=@LoginId)
if (@ncnt>0)
 
begin
DELETE FROM UserMaster WHERE LoginId=@LoginId
end
else
raiserror('No record found',10,1)
end
RETURN
 

thank u

[moggaa]

hi

it's easy to found it

when you try your stord procedure in your Query Analyzer you know your erorr
but when you run it your code but


Try
'your stored procedure here
Catch ex As Exception
Response.Write(ex.Message.ToString)
End Try

but this code Vb not C# but it's not different

then you will know the error message

if any problem send me [e-mail]

Subject error from the scripts site

Eng. Maged