DataTable Visualizer Improvements

Harshada Hole

Your favorite DataTable visualizer has now got a makeover with all new improvements coming in 17.4 Preview 2. The DataTable visualizers will now support sorting, filtering, exporting, and theming like IEnumerable visualizer.

DataTable Visualizer

 

The DataTable Visualizer allows you to view the contents of a DataTable, DataSet, DataView, or DataViewManager object. You can access this visualizer by clicking on the magnifying glass icon next to the Value for one of those objects in a debugger variables window or a DataTip.

DataTable Visualizer Autos Window

This debugger visualizer now enables you to find /compare/solve/investigate data queries.

DataTable Visualizer Improvements

Filtering

The DataTable visualizer can filter data based on the desired filter string. The filtering is not case-sensitive and supports Keyboard special characters (such as *, @, #, $, % etc.). Type the desired string in the filter box on the top of the DataTable visualizer and hit Enter. The visualizer will return all the rows with a value matching the filter string.

Sorting

The data in the DataTable visualizer can be sorted in ascending or descending order using the title bar exactly as you can in Excel/CSV files.

Exporting

You can export the data from the DataTable visualizer in Excel (xlsxl) or CSV format by using the dropdown in the top right corner. You can also select desired rows and copy/paste them.

The CSV or Excel export also works with the sorted and filtered view, i.e., only filtered rows will get exported.

Theming

Window theming was one of the top requested items from our customer feedback. Hence, after IEnumerable visualizer window, we are also improving the theming support for other visualizers and windows in the debugger.

So, the DataTable visualizer will now have theming support Visual Studio’s dark, light and blue theme.

 

Please tell us what you think!

There are still plenty of improvements in future versions of this experience. Please Download the latest Visual Studio Preview and provide your feedback. Also, please raise issues and provide feedback within the Visual Studio with “Report a Problem” or directly at the Developer Community site.