title: Storing and transforming rows of data in vb.net - array, list, collection or something else?
body: <p>I would like to ask you for advice. I need to extract data from one source (a transportation modelling application that supports vb.net), do some operations on that data and then insert transformed data to the source. 
  The source data is a set of rows with two key columns which are integers and third column which is float:</p>
  
  <pre><code>StartInterval EndInterval   Weight 
         0          3000      0.504
       3000         8000      0.320
       8000         13500     0.048
      ...............................
      ...............................
  </code></pre>
  
  <p>The number of rows in the source set is known and constant. After saving, this rowset should be transformed using some simple mathematic operations. After that it should be further transformed and expanded so that the number of rows as well as the values of Intervals will grow. At last the rowset will be used to fill again the vb.net object of the application. </p>
  
  <p>Please give me an advice which vb.net objects should I use to reach my goal. I should be able to easily iterate through that object and it should have dynamic size. I don't want to use any Excel sheet as a temporary container of that data, because I would like to use vb code in an internal script of application I'm using. </p>
  
  <p>Can anybody help me ? If it is necessary I can provide more info about my case. </p>