Hi Guys,

 I meet a problem. I need pass null value to a funtion in business logical layer.

Public Function JobSearch(ByVal sSkill As String, ByVal iCountryID As Nullable(Of Integer), ByVal iStateId As Nullable(Of Integer)) As JobPostingsDataTable
        Return Adapter.GetDataSearchForJobs(sSkill, iCountryID, iStateId)
End Function

sSkill, iCountryID, iStateID are variants in a stored procedure.

@sSkill varchar(255)

@iCountryID int=null

@iStateID int=null

Please help me, if someone knows how to do it. Thanks a lot.

redmaple:

Hi Guys,

 I meet a problem. I need pass null value to a funtion in business logical layer.

well, instead of using nullable I would sugges you to use simple Int. then pass nothing in parameter from calling code. and at the time of attaching param check either specific value is nothing or not. check the following.

if iStateId <> nothing
'attach parameter

end if  

this will work becuase you already code your sp for optional parameters.

cheers 

The solution is simple! As they are Ids, the values begin at 1. Just pass a 0 and include the following in your stored procedure:

if @iCountryId < 1 SET @ICountryId = null

 if @iStateId < 1 SET @iStateId = null