Sort Datatable in c#

In C#, a datatable can be sorted in several different ways. Following are some of the most commonly used methods for sorting a datatable:

Using the DataTable.DefaultView.Sort Property

One of the simplest ways to sort a DataTable is to use the DefaultView.Sort property of the table. This method sorts the table based on a specified column or columns and returns a sorted view of the table. The DefaultView property provides a read-only DataView of the table, which can be sorted using the Sort property. Following is an example of how to sort a DataTable using the DefaultView.Sort property:

DataTable dt = new DataTable(); // Code to populate the DataTable goes here dt.DefaultView.Sort = "ColumnName ASC"; dt = dt.DefaultView.ToTable();

In the above example, the "ColumnName" column of the DataTable is sorted in ascending order.

Using DataView.Sort

The DataView.Sort method is used to sort a datatable by creating a new DataView object and specifying the column to sort on and the sort order.

DataTable dt = new DataTable(); // Populate the datatable with data here... DataView dv = new DataView(dt); dv.Sort = "Column1 ASC, Column2 DESC"; // Sort by Column1 in ascending order, then by Column2 in descending order DataTable sortedDt = dv.ToTable();

In the above example, create a new DataView object from the original datatable and set the Sort property to "Column1 ASC, Column2 DESC". This sorts the datatable by Column1 in ascending order and then by Column2 in descending order. Finally, call the ToTable method on the DataView object to get a new sorted datatable.

Using DataTable.Select

The Select method of the datatable can also be used to sort data. This method returns an array of rows that match the specified filter criteria. You can use this array of rows to create a new datatable with the rows sorted in the desired order.

DataTable dt = new DataTable(); // Populate the datatable with data here... DataRow[] rows = dt.Select("", "Column1 ASC, Column2 DESC"); // Sort by Column1 in ascending order, then by Column2 in descending order DataTable sortedDt = dt.Clone(); foreach (DataRow row in rows) { sortedDt.ImportRow(row); }

In the above example, use the Select method of the datatable to get an array of rows sorted by Column1 in ascending order and then by Column2 in descending order. Then create a new datatable with the same structure as the original datatable using the Clone method, and loop through the sorted rows to add them to the new datatable using the ImportRow method.

Using LINQ

You can also use LINQ to sort a datatable.

DataTable dt = new DataTable(); // Populate the datatable with data here... var sortedRows = dt.AsEnumerable().OrderBy(r => r.Field<int>("Column1")).ThenByDescending(r => r.Field<string>("Column2")); DataTable sortedDt = sortedRows.CopyToDataTable();

In the above example, use the AsEnumerable method to get an enumerable collection of rows from the datatable, and then use the OrderBy and ThenByDescending methods to sort the rows by Column1 in ascending order and then by Column2 in descending order. Finally, call the CopyToDataTable method on the sorted rows to get a new datatable.

These example are just a few of the methods that can be used to sort a datatable in C#. The appropriate method to use will depend on the specific requirements of your application.

C# Datatable


C# Datatable sort

In C#, a DataTable is an in-memory representation of a relational database table. It is part of the System.Data namespace and can be used to store and manipulate data in a tabular format. A DataTable consists of a collection of DataColumn objects, which define the schema of the table, and a collection of DataRow objects, which contain the actual data. Each column in a DataTable can be of a different data type, such as string, integer, or datetime.






Related Topics
  1. Advantages of C#
  2. C# vs. Java: What Are Its Main Differences
  3. Advantages of C# over Python
  4. First C# Program | Hello World
  1. Difference between Console.Write and Console.WriteLine in C#
  2. How do I create a MessageBox in C#?
  3. C# Comments
  4. How to reverse a string in C#
  5. Palindrome in C# with Examples
  6. Fibonacci Series Program in C# with Examples
  7. C# Program to Print Number Triangle
  8. Get Integer Input from User in C# Console Application
  9. C# StringBuilder | Learn To Use C# StringBuilder Class
  10. C# HashMap (Dictionary)
  11. Ternary Operator (? :) in C# with Examples
  12. Struct Vs Class in C# | Differencees and Advantages
  13. Async And Await In C#
  14. IEnumerable in C# | Examples
  15. ref Vs out in C#
  16. How to remove item from list in C#?
  17. How to Add Items to a C# List
  18. C# StreamWriter Examples
  19. StreamReader in C# |Examples
  20. C# Map Example
  21. Static Method In C# | Examples
  22. How to convert an Enum to a String in C#
  23. How to convert a string to an enum in C#
  24. How to filter a list in C#?