title: LINQ TO DataSet: Multiple group by on a data table
body: <p>I am using Linq to dataset to query a datatable. If i want to perform a group by on "Column1" on data table, I use following query</p>
  
  <pre><code>var groupQuery = from table in MyTable.AsEnumerable()
  group table by table["Column1"] into groupedTable
  
  select new
  {
     x = groupedTable.Key,
     y = groupedTable.Count()
  }
  </code></pre>
  
  <p>Now I want to perform group by on two columns "Coulmn1" and "Column2". Can anybody tell me the syntax or provide me a link explaining multiple group by on a data table??</p>
  
  <p>Thanks</p>