filtering a created dataset

hi everyone

i have been working on a three tier application composed of a DAL a BLL and an XML presentation layer however i seem to have come to an impass and i was wondering if any of you helpful people out there can assist me.

I have created a XML_ view class that calls a function in the BLL wish in turn drills down into the DAL and returns a dataset. this is the code i use in the XML view and the BLL

XML class

PublicClass claimwatch_xml

Inherits BaseclaimBLL

Dim sitecodeAsString

'this class defines the fieldname aliases for the claim watch data extract

Dim baseclaimlogicAsNew BaseclaimBLL

Dim baseclaimdata = baseclaimlogic.filterbaseclaim(sitecode)

EndClass

BLL

PublicClass BaseclaimBLL

Private _baseclaimadapterAs BaseClaimTableAdapter =Nothing

ProtectedReadOnlyProperty adapter()As BaseClaimTableAdapter

Get

If _baseclaimadapterIsNothingThen

_baseclaimadapter =New BaseClaimTableAdapter

EndIf

Return _baseclaimadapter

EndGet

EndProperty

PublicFunction Fillbaseclaimbysitecode(ByVal sitecodeAsString)As active_web_dataset.BaseClaimDataTable

Return adapter.GetDatasitecode_extract(sitecode)

EndFunction

PublicFunction filterbaseclaim(ByVal sitecodeAsString)

'function filters baseclaim dataset based on certain criteria

Dim baseclaimAs active_web_dataset.BaseClaimDataTable = adapter.GetDatasitecode_extract(sitecode)

If baseclaim.Count = 0Then

ReturnFalse

EndIf

'put in filtering code here

Return baseclaim

EndFunction

normally to filter the data comming up from the DaL i would simply create a query in the DAL and wrap it in a function in the BLL however the client wants only generic slect queries in the DAL and i need to filter the resultant dataset in the BLL before passing it up to the XML_view class.

typical filtering i need to do is for example where one row in baseclaim is not null or is greater than the other

any ideas please ?

regards

lee

[4256 byte] By [ProfLeeHubbard] at [2008-1-10]