How to Use DataViews to Filter and Sort ADO.Net DataTables

31-July-2020
This week, we learn how to filter and sort the data in our ADO.Net DataTables by using DataViews. Whether you have a small or large amount of data, this data engineering technique will be very valuable to you. While in most cases, an analyst can request a filtered or sorted list directly from a database, there are also many cases when this is not possible, and the engineer is left with a large amount of data in DataTables in memory. Often they need to filter and sort their tables on-the-fly, without access (or too limited access) to a database to do the work for them. Enter the DataView, a powerful tool made just for this purpose.



Need help with a data engineering project? Call me today!