How to get output from the sql server procedure(which is in print statement) using C#
Hi All,
I am new to the C#
I am using sql server 2005 version 2.0
visual studio 2005
I got an issue
I will explain the isssue with example:
ALTER PROCEDURE [dbo].[example]
-- Add the parameters for the stored procedure here
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
print 'steve is good'
print 'john is bad'
END
GO
Exec [dbo].[example]
i am calling the above stored procedure in C#
I need get the output in
which is in the print statment of stored procedure
that is
steve is good
john is bad
is that pssible to do
if possible can anyone please help me out.
thank you
regards
chandu