Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on May 12th, 2012  |  syntax: None  |  size: 0.59 KB  |  hits: 17  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Add additional data to Linq to SQL result
  2. var results =
  3.             dataAccess.Statistics.
  4.             Where(s => s.DateStamp >= minDate && s.DateStamp <= DateTime.UtcNow && s.UserId == userId).
  5.             GroupBy(s => s.Url).
  6.             Where(g => g.Count() > 1).
  7.             OrderBy(g => g.Count()).
  8.             Select(g => new { Url = dataAccess.getDomain(g.Key) });
  9.  
  10.  
  11.  
  12.         ddlDomain.DataSource = results;
  13.         ddlDomain.DataBind();
  14.        
  15. ddlDomain.Items.Add(new ListItem() { Text = "All Url" });
  16. ddlDomain.AppendDataBoundItems = true;
  17. ddlDomain.DataSource = results;
  18. ddlDomain.DataBind();