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