I keep getting this error: The SqlParameterCollection only accepts non-null SqlParameter type objects, not Boolean objects.

I have the following code that when i run it I keep getting this error:

The SqlParameterCollection only accepts non-null SqlParameter type objects, not Boolean objects.

on intidVenue

But everyplace I use or declare this intidVenue I declare it as a Integer.  Why do I keep getting InvalidCastCexeption Error and how do I fix it?

Thanks


    Dim intidVenue As Integer = clCentral.intidVenue
    Dim intidUser As Integer = clCentral.intidUser

    Public Function intUpdateVenueMember(ByVal idVenue As Integer, ByVal idUser As Integer, ByVal idUserLast As Integer) As Integer
        Try
            Dim cmdUpdateVenueMember As New SqlCommand("updateVenueMember", objConn)
            cmdUpdateVenueMember.CommandType = CommandType.StoredProcedure
            cmdUpdateVenueMember.Parameters.Add(New SqlParameter("@idVenue", SqlDbType.Int).Value = idVenue)
            cmdUpdateVenueMember.Parameters.Add(New SqlParameter("@idUser", SqlDbType.Int).Value = idUser)
            cmdUpdateVenueMember.Parameters.Add(New SqlParameter("@idUserLast", SqlDbType.Int).Value = idUserLast)
            objConn.Open()
            cmdUpdateVenueMember.ExecuteNonQuery()
            intUpdateVenueMember = 0
            objConn.Close()
        Catch ex As SqlClient.SqlException
            If objConn.State = ConnectionState.Open Then
                objConn.Close()
                intUpdateVenueMember = 0
            End If
            MessageBox.Show(ex.Message)
        End Try
    End Function

---- Stored procedure

create procedure updateVenueMember(
                              @idVenue int,
                              @idUser int,
                              @idUserLast int
                        )
as
set nocount on

      update tblVenue
      set idUser = @idUser,
            idUserLast = @idUserLast
      where      idVenue = @idVenue

GO
Start Free Trial