ZqDatagrid – Queryless datagrid Download


ZqDatagrid - Queryless datagrid Download

Absolutely administration datagrid that synchronizes info along with your database tables, with no need so that you can write any SQL line.
Straightforward to make use of however nonetheless offering flexibility if you happen to want (over 20 parameters).
MySQL natively, and Oracle, PostGres and SQL server by way of ODBC.
Full-text search characteristic.
You employ formatters to configure columns. Like “WYSIWYG”, “calendar”, “checkbox”, “enter”, “file”, and many others.
In order for you you should utilize customized formatters too, pointing to your personal capabilities.
eight CSS themes and PSD information included so you possibly can create your personal ones.
The motion buttons (up, down, delete, and many others) could be configured to seem on left or proper of grid information.
Particular picture add type, so you possibly can simply handle picture immediately on the datagrid.
A number of PHP and JS callbacks so you possibly can lengthen the datagrid conduct to your personal wants.

Please contact me for help on bruno.falcao (at) dwell.com! Will reply ALL emails for positive.

New Options (model 1.3, 01 November 2012):

  • Improved DISPLAY and INPUT formatters!
  • Localization!
  • Some bug corrections detected by customers (thanks!)

New Options (model 1.2):

  • WYSIWYG column editor (formatter) !
  • Main code efficiency optimizations
  • Improved error question management over CRUD operations

New Options (model 1.1):

  • Pagination characteristic!
  • Code efficiency optimizations
  • Most strains restrict choice
  • Motion hyperlinks (insert, replace, refresh) could be hidden


  • A completely datagrid editor / viewer, the place you don’t have to work on SQL queries to synchronize your information to and from the server
  • Works natively with MySQL, and by way of ODBC with Oracle, PostGreSQL and SQL Server
  • Has a full textual content search characteristic
  • Has pagination characteristic
  • Straightforward technique to configure every column, through the use of easy formatters as an alternative of HTML code
  • Numerous formatters: enter, textarea, radios, checkboxes, picture thumbnails, calendars, and many others
  • Particular formatters, like select-table the place you’ll create a dropdown checklist immediately from a desk information
  • Easy technique to add pictures and to attach them to every line
  • Lightbox sort picture preview
  • Multi-language help
  • No have to have auto-identity columns to work
  • Non-compulsory log mode, the place all queries are recorded on a log desk
  • International “the place” clause the place all information is at all times filtered by that clause
  • Straightforward technique to filter info through the use of and setting a FK key
  • Numerous server-side and client-side occasions (beforeInsert, afterInsert, beforeUpdate, and many others)
  • eight CSS Themes so that you can use (and PSD information so you possibly can create your personal ones)!
  • Buttons “minus”, “add”, “up” and “down” could be positioned on proper or left of grid information.


1.3 (November 01, 2012)
* autoRefresh parameter
* Bugs on pagination solved
* "orderBy" parameter now accepts "desc or asc" 
* $ZQ_FK_TABLE : It is now doable to outline FK tables with column names totally different from "id" and "description" 
* Improved "show" formatter: Now has "show|fk|desk" will present the respective description worth and never the "id" worth!
* sleep(1) on replace technique eliminated.
* Improved "enter" formatter now accepts Twitter bootstrap span format: When you've got a "spanX" ingredient it's going to place it on the category
* Full label localization!
1.2 (June 16, 2012)
* New WYSIWYG formatter!
* Improved error management over CRUD question operations
* Main code optimizations on efficiency points
1.1 (June 03, 2012)
* Minor bug corrections and optimizations
* New options:
  - Pagination characteristic
  - Max strains restrict choice
  - Now you can cover the motion proper high part hyperlinks
1.0 (Might 22, 2012)
* First launch deployed to CodeCanyon

The one approach to enhance our work is to get suggestions. Please, fee it and remark (for good or dangerous!). Thanks!!


Be the first to comment

Leave a Reply

Your email address will not be published.


This site uses Akismet to reduce spam. Learn how your comment data is processed.