Xojo DataGrid

Version

1.16

Release date

2025-03-27

Platform

Xojo Desktop

Framework

2.0

O.S.

Online guide

Open guide

Video guide

Watch

Download

Free Version

Single License

199 €

Multi License

299 €

Enterprise

449 €

Buy Now

Introduction to the DataGrid component for Xojo

The DataGrid component for Xojo Desktop development platform is a support tool for view and manage data in a grid.

Licenses

The differences between the licenses are:
- the Single License can be used by 1 developer only, and has 1 year of free updates.
- the Multi License can be used by 10 developers, and has 3 years of free updates.
- the Enterprise License can be used by unlimited developers, and has 5 years of free updates.

Feature tour

Features

This component is NOT a subclass of ListBox, but has been completely rewritten to have fast and stable data loading.

This component is NOT a ContainerControl that contains other components for simulate the grid, but is a SINGLE component that rewrites the entire grid editable.

You will have ONLY ONE component to drag into your project.

The DataSource is type Database, therefore compatible with: SQLite, MySQL, PostgreSQL, MS SQL, ODBC, and all Xojo Database subclasses.

You can query the database and the component will display the data in a few cents of a second. If the database is not local but remote, the speed will also depend on the connection.

You can set the data types for each column, such as: Text, Number, Currency, CheckBox, List, Date, Link, ProgressBar, Color, etc

You can change the width and alignment of the columns.

You can sort the data by clicking on a column (ASC/DESC). By holding down the CTRL key (or COMMAND for macOS) you can add columns to the sort as first, second, third column, etc.

You can edit the content of the cells with a double click and the data will be updated directly on the database.

You can delete rows in the database, or just in grid view (leaving the data intact in the database).

You can choose which columns are editable and which are not.

You can move columns or hide them.

You have a settings screen to manage the grid after startup.

You can save the settings of the columns and the grid, and restore them.

There is an event that allows you to decide if the modified cell value is valid or not.

There is an event that allows you to redesign the cell to your liking. This allows you to customize it as you wish, without limits.

You can select rows, multiple rows at the same time.

You can drag row (or rows) to another control with Drag and Drop.

You can choose all the colors of the grid, from the background to the borders, from the header to the cells, from the selection to the cell focus.

You can change the font of the cells, font name, size, bold, underline, etc.