Hai
I am creating a stored procedure with return value to display values returned from stored procedure to UI
Sample code
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE InsertRecords
-- Add the parameters for the stored procedure here
@id varchar(100),
@psw varchar(100),
@MsgtoUser varchar(100) output
AS
begin try
BEGIN Transaction
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT off;
insert into my_table(id,psw)values(@id,@psw)
-- Insert statements for procedure here
Commit Transaction
set @MsgtoUser= @tc_usernameToDb+'registered sucessfully'
return @MsgtoUser
end try
begin catch
set @MsgtoUser='From catch block'
return @MsgtoUser
Rollback Transaction
end catch
using (objsqlcmd = new SqlCommand(InsertRecords, objsqlcon))
{
try
{
objsqlcmd.CommandType = CommandType.StoredProcedure;
objsqlcmd.Parameters.AddWithValue("@id", 123);
objsqlcmd.Parameters.AddWithValue("@psw", Psw@123);
objsqlcmd.Parameters.Add("@MsgtoUser", SqlDbType.Char, 500);
objsqlcmd.Parameters["@MsgtoUser"].Direction = ParameterDirection.Output;
objsqlcmd.ExecuteNonQuery();
message = (string)objsqlcmd.Parameters["@MsgtoUser"].Value;
}
Is this code is fine or kindly share your thoughts to proceed.
Regards