This is an editable grid that I've been developing in pure PureBasic.
It is data-aware in that it sources its data from a database via a data provider. Currently there is only a SQLite data provider but other data providers can be developed for ODBC, MySQL etc.
It includes features such as:
- Master-Detail grids
- Fixed columns
- Popup editors such as for long text, date/time, and for populating foreign keys from other tables.
- A very basic hand written inline text editor, this was necessary as trying to overlap gadgets, yikes!
It can be used as a base for developing other inline editors.
- Column sorting (currently only one column at a time)
- Basic filtering
- Handles larger datasets by requesting records from the data provider as necessary, it does not request all records at once.
Some screenshots:
1. This shows two grids in master-detail.
2. This shows the calendar popup editor for a date field.
3. This shows the large text popup editor.
4. This shows column sorting with an indicator in the top right of the column header.
5. This shows the list of values popup editor for populating foreign keys. Two fields from the foreign key are used, firstly the primary key which is applied to the database and a more descriptive field such as name or description is shown to the user.
6. This shows another example with filtering applied. It also shows fixed columns (enabled, first name, last name) and a checkbox field.
7. This shows the insert record for creating new records.
Data-aware Grid
- NicTheQuick
- Addict
- Posts: 1224
- Joined: Sun Jun 22, 2003 7:43 pm
- Location: Germany, Saarbrücken
- Contact:
Re: Data-aware Grid
You didn't add any link to the code or to test it out. Also does it work on Linux too?
The english grammar is freeware, you can use it freely - But it's not Open Source, i.e. you can not change it or publish it in altered way.
Re: Data-aware Grid
I haven't posted the code or a test sample as it is still work in progress. It should work on Linux with a bit testing and tweaking as I'm not using any platform specific code.
- captain_skank
- Enthusiast
- Posts: 636
- Joined: Fri Oct 06, 2006 3:57 pm
- Location: England
Re: Data-aware Grid
Looks good.
A few q's if i may :
1. is it DPI aware ?
2. is it a module ?
3. does it have variable row heights ?
Cheers
A few q's if i may :
1. is it DPI aware ?
2. is it a module ?
3. does it have variable row heights ?
Cheers
Re: Data-aware Grid
Thanks for the good questions!
1. I haven't tested DPI aware yet.
2. Yes, it is modular, it is made up of a several modules. The grid can be extended using a "plugin" which is a module that listens to grid events.
3. Unfortunately no variable row heights at the moment. I did consider this but it was adding complexity to the grid functionality that I couldn't yet figure out. This should be a future improvement.
Cheers!
1. I haven't tested DPI aware yet.
2. Yes, it is modular, it is made up of a several modules. The grid can be extended using a "plugin" which is a module that listens to grid events.
3. Unfortunately no variable row heights at the moment. I did consider this but it was adding complexity to the grid functionality that I couldn't yet figure out. This should be a future improvement.
Cheers!
Re: Data-aware Grid
No release?