I have a process in which (in VB6) I use a multi-dimensional array of variant type in which one column holds a date, and several each hold strings and numbers. These are populated from a series of recordsets. I have to do some math on various columns to fill other columns within each row (and this cannot all be done within SQL or stored procedures).
I need to migrate this to .NET. Since .NET does not allow variants, should I create a string array and convert number fields to a number type to do my calculations or is it better to use some other collection-type class? Whatever I use, it must be multi-dimensional and indexed.
I need to migrate this to .NET. Since .NET does not allow variants, should I create a string array and convert number fields to a number type to do my calculations or is it better to use some other collection-type class? Whatever I use, it must be multi-dimensional and indexed.