C#

ALTER PROCEDURE SP_UserValid
	@ID    INT,
	@Valid BIT OUTPUT
AS
	SET NOCOUNT ON;
	SET @Valid = (SELECT [Valid] FROM tUsers WHERE ID = @ID)

SqlConnection connection = new SqlConnection(_ConnectionString);
SqlCommand cmd           = new SqlCommand();
cmd.Connection           = connection;
cmd.CommandType          = CommandType.StoredProcedure;
cmd.CommandText          = "SP_UserValid";
cmd.Parameters.Add(new SqlParameter("@ID", userID));
cmd.Parameters.Add(new SqlParameter("@Valid", bValid));
cmd.Parameters["@Valid"].SqlDbType = SqlDbType.Bit;
cmd.Parameters["@Valid"].Direction = ParameterDirection.InputOutput;

connection.Open();
cmd.ExecuteNonQuery();

// How do I get the "Valid" as a Boolean value?

cmd.Connection.Close()