Feature TourFeature Tour

Result Set Management

Previous Next

The grid component is a very central component in DbVisualizer and it provides a lot of convenient context-dependent features that are highlighted below.

 
Here are two columns, "Type (DB)" and "Size" sorted in ascending order. To sort one column, just click the column header. One click will sort the column in ascending order. Click again and it will be sorted in the reverse order, and a third click will reset to the original ordering. To sort the grid based on more than one column, keep the Ctrl key (Command on Mac OS X) pressed while clicking the column headers. <br> The screenshot also shows filtering of the "Name" column. All matches in the grid are highlighted with yellow color.
Grid with multi-column sorting and filtering
The right click menu lists all actions that may be performed on the grid and its data. Note that some actions are context sensitive and may be disabled.
Grid right-click menu choices
The "Browse Row in Window" action shows the selected row in a separate window. The data is presented in a form with the leftmost column in the original grid being presented at the top. <br> The form window is also a grid with the same capabilities as the grid component.
Row Form Window
Sometimes it is convenient to select some data and show various statistics such as telling max, min, avg, sum, etc. The right-click menu choice "Aggregate Data for Selection" is used for this.
Aggregation Data for Selection
 
The export functionality is used to export the content of any grid to a file. The output can be written in CSV, HTML, SQL, XML, MS Excel format. Data formats can be specified and test data can be generated with the builtin data generators. The export functionality can also be used in the SQL Commander, which is very useful when exporting large result sets directly to file without first presenting them in DbVisualizer.
The Export feature
Feature DbVisualizer
Pro		 DbVisualizer
Free
» Auto resize columns, manual column resizing
» Double click column divider to sort column
» Re-arrange columns by drag and drop
» Multi colum sort by clicking column header
» Copy column name
» Copy selection
» Quick filter with range options
» Quick filter highlights matched cells
» Aggregation Data for Selection
» Find cell data and column name
» Export grid data CSV, HTML, XLS, XLSX, XML, SQL, TEXT, JSON CSV, HTML