VB6 - Populate User Defined Type Array from Stored Procedure then Find Item in Array -

i coming more of .net background , need make changes old vb6 application.

the .net equivalent of i'm trying in vb6 is, define (model) class 3 properties

public class myclass {   public string ref { get; set; }   public string oldnumber { get; set; }   public string newnumber { get; set; } } 

in .net call stored procedure return set of results (there few thousand records) , assign them to, example, instance of list<myclass>.

i then, whenever need to, attempt find item within list, 'ref' property 'blah', , use item/its other properties (oldnumber , newnumber).

however, in vb6, don't know how same process best achieved. can please help?

if using ado can cache results querying static cursor client-side recordset , disconnecting it.

you can use sort, find, filter, etc. , move through rows needed. can improve searches building local index within recordset after opening , disconnecting using field object's optimize dynamic property. see:

optimize property-dynamic (ado)