Sorting a Data Table

by

This was the shortest way I could find to sort a DataTable without having to create any new variables. 

DataTable.DefaultView.Sort = "ColumnName ASC"
DataTable = DataTable.DefaultView.ToTable

Where:

ASC – Ascending

DESC – Descending

ColumnName – The column you want to sort by

DataTable – The table you want to sort

More Related Contents:

  1. For Each Loop in Visual Basic: IndexOutOfRangeException [closed]
  2. What do Option Strict and Option Explicit do?
  3. Clean up Excel Interop Objects with IDisposable
  4. “There is already an open DataReader…” Reuse or Dispose DB Connections?
  5. Using related data stored in a 2 dimensional array
  6. How do you parse an HTML in vb.net
  7. The proper way to dispose Excel com object using VB.NET?
  8. “Items collection must be empty before using ItemsSource.”
  9. Searching values via a datagridview
  10. Getting the path of the current assembly
  11. How can I make a single event handler handle ALL Button.Click events?
  12. How do I create an event handler for a programmatically created object in VB.NET?
  13. How do I shuffle and deal cards one at a time to players?
  14. BitmapImage in WPF does lock file
  15. Does End Using close an open SQL Connection
  16. Analyze colors of an Image
  17. Deserialize using JSON.net
  18. Cause this VB6-like smell, which VB.NET allows, to error instead: WinFormType.InstanceProp=Value [DISABLE My.Forms]
  19. Equivalent of MoveNext in VB.NET
  20. Pass Command Line to first instance of a Single Instance App
  21. Start a Task in the Form Shown event
  22. Shuffling an array of strings in vb.net
  23. VB.NET: impossible to use Extension method on System.Object instance
  24. How to find the main() entry point in a VB.Net winforms app?
  25. How do I find out which control has focus in .NET Windows Forms?
  26. How do I fill an empty textbox with default text?
  27. Why doesn’t doubleclick event fire after mouseDown event on same element fires?
  28. vb.net Pass Textbox Between forms.
  29. String manipulation with & or + in VB.NET
  30. ‘Shadows’ vs. ‘Overrides’ in VB.NET

Leave a Comment