title: How to bind LINQ result to datagrid
body: <p>i bind linq result data to datagrid but nothing comes. here is my code</p>
  
  <pre><code>        List&lt;SearchResult&gt; list = new List&lt;SearchResult&gt;() {
          new SearchResult(){ID=1,Title="Geo Prism 1995 GEO* - ABS #16213899"},
          new SearchResult(){ID=2,Title="Excavator JCB - ECU P/N: 728/35700"},
          new SearchResult(){ID=3,Title="Geo Prism GEO 1995 - ABS #16213899"},
          new SearchResult(){ID=4,Title="JCB Excavator JCB- ECU P/N: 728/35700"},
          new SearchResult(){ID=5,Title="Geo Prism GEO,GEO 1995 - ABS #16213899 GEO"},
          new SearchResult(){ID=6,Title="dog"},
          };
  
          var to_search = new[] { "Geo", "JCB" }.Select(x =&gt; x.ToLower()).ToArray();
          var result = from searchResult in list
                       let title = searchResult.Title.ToLower()
                       let key_string = to_search.FirstOrDefault(ts =&gt; title.Contains(ts))
                       orderby key_string == null ? -1 : title.Split(new[] { key_string }, StringSplitOptions.None).Length descending
                       group searchResult by key_string into Group
                       orderby Group.Count() descending
                       select Group;
  
          dataGridView2.DataSource = result;
  </code></pre>
  
  <p>when i run the above code datagrid showing nothing but i was expecting datagrid should show <strong>ID and Title</strong></p>
  
  <p>then i add some more line like</p>
  
  <pre><code>List&lt;SearchResult&gt; listFinal = new List&lt;SearchResult&gt;();
  foreach (var group in result)
  {
       foreach (var item in group)
       {
          listFinal.Add(new SearchResult() { ID = item.ID, Title = item.Title });
       }
   }
   dataGridView2.DataSource = listFinal;
  </code></pre>
  
  <p>now datagrid is showing data. so my question is that....is there any short cut way to convert result to list as a result i can bind list directly to datagrid with iterate in loop and create a new list and fill it up before binding. looking for guidance. thanks</p>