Check returned records

[soluga]

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 ??

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

[jmcilhinney]

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.

[soluga]

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

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