title: Source Binding in WPF like Asp.Net
body: <p>I have a transaction table to store all the transaction happened on a single day. I wrote query as</p>
  
  <pre><code>select CurrencyCode,TransactionCode,TransactionAmount,COUNT(TransactionCode) as 
  [No. Of Trans] from TransactionDetails where CAST(CurrentTime as date)=CAST(GETDATE()as date)
  group by TransactionCode, CurrencyCode,TransactionAmount order by CurrencyCode
  </code></pre>
  
  <p>I got the out put like this</p>
  
  <pre><code>CurrencyCode      TransactionCode      TransactionAmount   No.OfTrans
    ARS                 SCN                   12                 1
    AWG                 BNT                   12                 1
    BAM                 BNT                   12                 1
    BND                 BNT                   7                  1
    BWP                 BTC                   45                 1
    EUR                 BCN                   6.6                1
    EUR                 BNT                   90                 1
    EUR                 BNT                   200                1
    JPY                 BNT                   10000              2
    VND                 BNT                   600                1
    VND                 BNT                   800                1
    VND                 BNT                   10000000           1
  </code></pre>
  
  <p>But as per my requirements I want to show like this on a page for reporting purpose</p>
  
  <pre><code>                       ARS
  BNT        0            0
  BCN        0            0
  SCN        1            12
  BTC        0            0
  STC        0            0
  SNT        0            0
                       -------
  Total Balance  ---&gt;    70000
  ++++++++++++++++++++++++++++++++++++
                         VND
  BNT        3           10001400
  BCN        0            0
  SCN        0            0
  BTC        0            0
  STC        0            0
  SNT        0            0
                       -------
  Total Balance  ---&gt;    17090
  ++++++++++++++++++++++++++++++++++++
  </code></pre>
  
  <p>Is there any way that I can do source binding like asp.net. Design a pattern in grid and apply looping as per my Currency code. So that I can achieve like my requirements.</p>