{"id":239392,"date":"2022-09-15T10:10:54","date_gmt":"2022-09-15T17:10:54","guid":{"rendered":"https:\/\/devblogs.microsoft.com\/visualstudio\/?p=239392"},"modified":"2022-09-15T10:10:54","modified_gmt":"2022-09-15T17:10:54","slug":"datatable-visualizer-improvements","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/visualstudio\/datatable-visualizer-improvements\/","title":{"rendered":"DataTable Visualizer Improvements"},"content":{"rendered":"

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<\/a>.<\/p>\n

\"DataTable<\/p>\n

 <\/p>\n

Download Visual Studio 2022 Preview<\/a><\/div><\/p>\n

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.<\/p>\n

\"DataTable<\/p>\n

This debugger visualizer now enables you to find \/compare\/solve\/investigate data queries.<\/p>\n

\"DataTable<\/p>\n

Filtering<\/h4>\n

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<\/em>. The visualizer will return all the rows with a value matching the filter string.<\/p>\n

Sorting<\/h4>\n

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.<\/p>\n

Exporting<\/h4>\n

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.<\/p>\n

The CSV or Excel export also works with the sorted and filtered view, i.e., only filtered rows will get exported.<\/p>\n

Theming<\/h4>\n

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.<\/p>\n

So, the DataTable visualizer will now have theming support Visual Studio\u2019s dark, light and blue theme.<\/p>\n

 <\/p>\n

Please tell us what you think!<\/h3>\n

There are still plenty of improvements in future versions of this experience. Please Download the latest Visual Studio Preview <\/a>and provide your feedback. Also, please raise issues and provide feedback within the Visual Studio with \u201cReport a Problem\u201d or directly at the Developer Community site<\/a>.<\/p>\n

 <\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

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.   The DataTable Visualizer allows you to view the contents of a DataTable, DataSet, DataView, or DataViewManager object. You can access this visualizer […]<\/p>\n","protected":false},"author":26573,"featured_media":239393,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[155],"tags":[6793,9,526,6815],"class_list":["post-239392","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-visual-studio","tag-debugger","tag-debug","tag-productivity","tag-visual-studio-2022"],"acf":[],"blog_post_summary":"

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.   The DataTable Visualizer allows you to view the contents of a DataTable, DataSet, DataView, or DataViewManager object. You can access this visualizer […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-json\/wp\/v2\/posts\/239392","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-json\/wp\/v2\/users\/26573"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-json\/wp\/v2\/comments?post=239392"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-json\/wp\/v2\/posts\/239392\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-json\/wp\/v2\/media\/239393"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-json\/wp\/v2\/media?parent=239392"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-json\/wp\/v2\/categories?post=239392"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-json\/wp\/v2\/tags?post=239392"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}