code_junkie

.NET/C# - Sort DataTable, then manually process the rows

Nov 13th, 2011
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.44 KB | None | 0 0
  1. foreach (DataRow dr in dtTags.Rows)
  2. {
  3. LinkButton lbTag = new LinkButton();
  4. lbTag.CssClass = "UserTagNoHover";
  5. lbTag.ID = "hlUserTag" + dr["UserTagRID"].ToString();
  6. lbTag.Text = dr["Name"].ToString();
  7. //lbTag.Click += new System.EventHandler(this.Tag_OnClick);
  8. lbTag.CommandName = "User_Click";
  9. lbTag.CommandArgument = "hlUserTag" + dr["UserTagRID"].ToString();
  10. lbTag.ToolTip = "Total uses: " + dr["TotalCount"].ToString();
  11.  
  12. Boolean bAlreadyExists = false;
  13. foreach (LinkButton lbTest in pnlTags.Controls)
  14. {
  15. if (lbTest.ID == lbTag.ID)
  16. {
  17. bAlreadyExists = true;
  18. }
  19. }
  20. if (bAlreadyExists == false)
  21. {
  22. pnlTags.Controls.Add(lbTag);
  23. }
  24. }
  25.  
  26. DataTable table = ...
  27. DataView view = table.DefaultView;
  28. view.Sort = ...
  29. view.RowFilter = ...
  30.  
  31. var rows = from row in dataTable.AsEnumerable()
  32. orderby row.Field<int>("Age") // or whatever
  33. select new
  34. {
  35. UserTagID = row.Field<string>("UserTagID"),
  36. TotalCount = row.Field<int>("TotalCount")
  37. // etc
  38. };
Add Comment
Please, Sign In to add comment