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:
Comments
Post a Comment