dear fellas,
what does make it possible for me to received this error?
An SqlParameter with ParameterName 'RETURN_VALUE' is not contained by this SqlParameterCollection.
Code
Public Function GetNews(ByVal NewsID As Integer) As Boolean
Try
If ClsDBConn.InitConn Then
If ClsDBConn.GetDBConn.State = Data.ConnectionState.Open Then
Dim sqlCmd As SqlCommand = New SqlCommand("Get_NewsDetails", ClsDBConn.GetDBConn)
sqlCmd.CommandType = Data.CommandType.StoredProcedure
Dim sqlParameter As SqlParameter
sqlParameter = sqlCmd.Parameters.Add("@News_ID", Data.SqlDbType.VarChar, 20)
sqlParameter.Value = NewsID
sqlParameter = sqlCmd.Parameters.Add("@News_Title", Data.SqlDbType.VarChar, 2000)
sqlParameter.Direction = Data.ParameterDirection.Output
sqlParameter = sqlCmd.Parameters.Add("@News_Message", Data.SqlDbType.VarChar, 5000)
sqlParameter.Direction = Data.ParameterDirection.Output
sqlParameter = sqlCmd.Parameters.Add("@News_Attach", Data.SqlDbType.VarChar, 1000)
sqlParameter.Direction = Data.ParameterDirection.Output
sqlCmd.ExecuteNonQuery()
If sqlCmd.Parameters("RETURN_VALUE").Value = 0 Then
NewsTitle = sqlCmd.Parameters("@News_Title").Value
NewsMessage = sqlCmd.Parameters("@News_Message").Value
NewsFile = sqlCmd.Parameters("@News_Attach").Value
Return True
Else
Return False
End If
Else
NewsStatus = "No connection established"
Return False
End If
Else
NewsStatus = "No connection initiallised"
Return False
End If
Catch ex As Exception
NewsStatus = ex.ToString
Return False
End Try
End Function
Stored Procedure
USE [TMMSV1]
GO
/****** Object: StoredProcedure [dbo].[Get_NewsDetails] Script Date: 18/6/2014 10:04:08 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[Get_NewsDetails]
-- Add the parameters for the stored procedure here
@News_ID VARCHAR(100),
@News_Title VARCHAR(5000) OUTPUT,
@News_Message VARCHAR(5000) OUTPUT,
@News_Attach VARCHAR(5000) OUTPUT
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
SELECT @News_Title = news_Title, @News_Message = news_Message, @News_Attach = news_Attachment
FROM News_MessageBoard
WHERE news_ID = @News_ID
END