title: How can i use cross Tab Query in c# linq?
body: <pre><code>var TatalFeeCollectionDetail = new List&lt;lcclsTotalFeeCollectionDetail&gt;();
  TatalFeeCollectionDetail = (from t in .......
                              group t by new { t.MonthName,t.FeeParticularName }                                        
                                  into grp                                           
                                  select new lcclsTotalFeeCollectionDetail                                           
                                  {
                                      Month = grp.Key.MonthName,
                                      Particular = grp.First().FeeParticularLedgerName,
                                      Amount = grp.Sum(t =&gt; t.Amount),
                                  }).ToList();
  dgvTotalFeeCollectionDetail.DataSource = TatalFeeCollectionDetail;
  </code></pre>
  
  <p>My result is this .............</p>
  
  <pre><code>    Month   particular Amount   
      April       b      1    
      April       c      2    
      April       d      1    
      April       e      2
      April       f      1
  </code></pre>
  
  <p>I want to convert it like this can any1 help me...........I search for it but can,t understood what to do....</p>
  
  <pre><code>Month   b   c   d   e   f   Total Amount
  April   1   2   1   2   1       7
  </code></pre>
  
  <p>Thanxxxxxxx in advance</p>