Check returned records

I have a function that adds to my collection, but I dont want to add it to my collection if more than one result is returned, how can I check how many records are being returned in the dataset ??

VB Code:

If e.Column.Key = "productRangeCode" Then
                If _rangeCode.Length > 0 Then
                    Dim _component As New Component
                    _component.Load(_rangeCode) ' This calls my load function in my class
'I need to check here how many are returned before adding to my collection ??????
                        product.Formulation.Add(_component)
                        GridExFormula.Refetch()
                                    End If

Thanks

I have no idea what any of that code is doing so because you haven't given any indication of what any of the objects or methods are. A bit of context might be nice. My guess would be that instead of testing that Length is greater than zero you should test that it's equal to one.

sorry, was bit vague wasnt it.
anyway I figuered it out...

VB Code:

_recordsCount = _component.Load(_rangeCode, _colourCode, _versionNumber).Tables(0).Rows.Count