title: vb.net - multiplying values from datatable
body: <p>I'm working in vb.net and in my program i have two datatables. What i want is to multiply quantity for some IZ in the second datatable with the quantity for the same IZ from first datatable. I want to do that for every IZ.</p>
  
  <p>For example for IZ12554 it would be like 1*460=460 and 0,0025*460=1,15; for IZ10836 it would be 3*2000=6000; 1*2000=2000; 1*2000=2000 etc, and write those results in datatable 3.</p>
  
  <p><code>DATATABLE 1
  </code>
  <code>Capacity    IZ   Quantity  ID    Document
  </code>
  <code>-------------------------------------------
  </code>
  <code>DM00006   IZ12554   460    20   PDN00084625
  </code>
  <code>DM00007   IZ10836   2000    1   PDN00084983
  </code>
  <code>DM00010   IZ12641   25200   1   PDN00084997
  </code> 
  <code>DM00011   IZ03941   940     1   PDN00084639
  </code> 
  <code>DM00087   IZ15137   50     12   PDN00084904
  </code>
  <code>....
  </code>
  <code>....
  </code></p>
  
  <p><code>DATATABLE 2
  </code>
  <code>IZ         MA     Quantity    Unit
  </code>
  <code>----------------------------------
  </code>
  <code>IZ12554  MA06196     1        KOS
  </code>
  <code>IZ12554  MA05545     0,0025   KOS
  </code>
  <code>IZ10836  MA06199     3        KOS
  </code>
  <code>IZ10836  MA06197     1        KOS
  </code>
  <code>IZ10836  MA00892     1        kos
  </code>
  <code>IZ12641  MA06199     1        KOS
  </code>
  <code>IZ12641  MA32200     0,04     m
  </code>
  <code>IZ03941  MA07639     0,0025   KOS
  </code>
  <code>IZ03941  MA00896     0,295    M
  </code>
  <code>IZ03941  MA06200     1        KOS
  </code>
  <code>IZ03941  MA00892     1        kos
  </code>
  <code>IZ15137  MA06200     1        KOS
  </code>
  <code>IZ15137  MA00557     0,0025   KOS
  </code>
  <code>IZ15137  MA00897     0,295    M
  </code>
  <code>...
  </code>
  <code>...
  </code>
  <code>
  </code>
  <code>DATATABLE 3 - RESULTS
  </code>
  <code>IZ         MA     Quantity    Unit
  </code>
  <code>----------------------------------
  </code>
  <code>IZ12554  MA06196     460      KOS
  </code>
  <code>IZ12554  MA05545     1,15     KOS
  </code>
  <code>IZ10836  MA06199     6000     KOS
  </code>
  <code>IZ10836  MA06197     2000     KOS
  </code>
  <code>IZ10836  MA00892     2000     kos
  </code>
  <code>IZ12641  MA06199     25200    KOS
  </code>
  <code>IZ12641  MA32200     1000,8   m
  </code>
  <code>IZ03941  MA07639     2,35     KOS
  </code>
  <code>IZ03941  MA00896     277,3    M
  </code>
  <code>IZ03941  MA06200     940      KOS
  </code>
  <code>IZ03941  MA00892     940      kos
  </code>
  <code>IZ15137  MA06200     50       KOS
  </code>
  <code>IZ15137  MA00557     0,125    KOS
  </code>
  <code>IZ15137  MA00897     14,75    M
  </code>
  <code>...
  </code>
  <code>...
  </code></p>
  
  <p>I searched for answer, but still don't know how to work with datatables, i'm a complete beginner at programming...</p>
  
  <p>Thanks in advance!</p>