DefconDotNet

Untitled

Jan 27th, 2012
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.90 KB | None | 0 0
  1.                 var steps = _db.tblConversions.GroupBy(c => c.CvStep).OrderBy(c=>c.Key).Select(s => s.Key).ToList();
  2.                 foreach (var step in steps)
  3.                 {
  4.                     var keywords =
  5.                         _db.ExecuteQuery<string>(
  6.                             "SELECT DISTINCT SkwKeyword FROM tblSearchKeywords WHERE  SkwIpAddress in (" +
  7.                             " SELECT DISTINCT CvIP FROM tblConversions " +
  8.                             " WHERE SkwIpAddress     IN (SELECT DISTINCT CvIP FROM tblConversions WHERE CvStep = {0}) " +
  9.                             "  AND  SkwIpAddress NOT IN (SELECT DISTINCT CvIP FROM tblConversions WHERE CvStep > {0}))",
  10.                             step);
  11.  
  12.                     sb.AppendFormat("<tr><td>Stap&nbsp;{0}</td><td style=\"text-align:left;\">{1}</td></tr>", step,
  13.                         String.Join(" | ",keywords));
  14.                 }
Advertisement
Add Comment
Please, Sign In to add comment