Knowledge Base
Categories:
- General
- Security
- Working with AJAX features
- Modes and operations
- Passing parameters
- Using JavaScript on client side
- Working with fields and data
- Triggers
- CheckBoxes
- Links
- Images & Files
- Multi-row operations
- Rows highlighting
- Showing/Hiding Datagrid
- Searching & Filtering
- Languages
- Exporting
- Caching
- Foreign Keys
- Pagination
- Layouts, Styles and CSS
- Integration with Other Programs
- List of Limitations & Known Issues
General:
- HOW TO use inheritance with DataGrid?
- HOW TO work with large tables or hard queries?
- HOW TO add scrolling on datagrid?
- HOW TO downgrade DataGrid from PHP5 to PHP4?
- HOW TO replace some deprecated functions in PHP >= 5.3.0?
- HOW TO define 2 or more DataGrids on one page?
- HOW TO run examples from the script archive?
- HOW TO define connection string to different database types?
- HOW TO put DataGrid output into the string variable? * - popular
- HOW TO implement pagination for db2/400 and IBM db2?
- HOW TO make a lot of work with auto-generated columns? * - popular
- HOW TO refresh the data in DataGrid automatically?
- HOW TO create auto-updating primary key for MSSQL 2005?
- HOW TO implement using of namespaces?
- IMPORTANT Syntax Changes in new versions 7.x.x * - popular
- IMPORTANT Syntax Changes in new versions 8.x.x * - popular
Security:
Working with AJAX features:
Modes and operations:
- HOW TO define SELECT SQL for View mode?
- HOW TO get ID of the last inserted record?
- HOW TO make Add/Edit Mode to be a default mode?
- HOW TO set access rights on Add/Edit/View modes for different users?
- HOW TO make your own operation before adding/updating etc.?
- HOW TO make my own operation after adding/updating/deleting a record? * - popular
- HOW TO define inline editing, tips etc.
Passing parameters:
- HOW TO pass 2 or more parameters in URL(query string)?
- HOW TO get the datagrid class keeps my own $_GET variables?
Using JavaScript on client side:
- HOW TO make my own JavaScript validation on form submission event? * - popular
- HOW TO use "on_js_event" on client side?
- HOW TO show/hide fields, depending on events of another field?
Working with fields and data:
- HOW TO create a listbox with muliple selection?
- HOW TO define fields with selection (enum, dropdown box etc)?
- HOW TO show dropdownlist for "enum" type with <optgroup>?
- HOW TO define different fields for Add and Edit modes? * - popular
- HOW TO display data in cells that are different from DB? * - popular
- HOW TO make dependent dropdown lists (or any other fields)? * - popular
- HOW TO dependent dropdownlists strategies * - popular
- HOW TO block/unblock fields in Edit Mode?
- HOW TO use hidden fields in Add/Edit Modes?
- HOW TO set encryption for "password" fields?
- HOW TO define "unique" and "unique_condition" attributes?
- HOW TO add my own additional (virtual) fields in Add/Edit modes?
- HOW TO dynamically create fields in Add/Edit modes?
- HOW TO add my own additional fields in View mode?
- HOW TO clone (duplicate) records? * - popular
- HOW TO set formating in datetime fields? * - popular
- HOW TO change uploading directory for "textarea" fields?
- HOW TO display tooltips in View Mode?
- HOW TO compare data before and after update for changes?
- HOW TO define a mask for Add/Edit Mode fields?
- HOW TO know the selected Row ID in View/Edit Mode?
- HOW TO create a Google Map field?
- HOW TO create new (my own) field type?
- HOW TO define aggregate (summarize) functions?
- HOW TO access fields in Add/Edit Modes using JavaScript?
- HOW TO define field with a fixed decimal point in Add/Edit modes?
Triggers:
- HOW TO change "readonly" property of field "on fly"
- HOW TO change the field's data "on fly"?
- HOW TO change the field type "on fly"?
- HOW TO change the rows color "on fly"?
CheckBoxes:
- HOW TO create "On"/"Off" link/checkbox in VIEW mode?
- HOW TO define "checkbox" fields in Add/Edit Modes?
Links:
- HOW TO create the "link" field?
- HOW TO make a field as a link on edit mode (5 methods)?
- HOW TO create links to different modes?
- HOW TO create customized action link - Add/Edit/Details/Delete?
- HOW TO create my own JavaScript function and pass parameters?
- HOW TO add JavaScript confirmation to link fields?
Images & Files:
- HOW TO set unique value for uploaded image?
- HOW TO display image, saved in database field?
- HOW TO create image as a link in View Mode?
- HOW TO to display image from remote server in View Mode?
- HOW TO resize uploaded image?
- HOW TO set write access to image folders on IIS?
- HOW TO allow saving and downloading of BLOB files?
- HOW TO to show BLOB?
Multi-Row Operations:
Rows Highlighting:
Showing/Hiding Datagrid:
- HOW TO hide datagrid before the search and show it after?
- HOW TO carry out operation, but don't show DataGrid?
Searching & Filtering:
- HOW TO define filtering fields?
- HOW TO perform search by range (date fields and other)?
- HOW TO make customized filtering?
- HOW TO split filtering fields in a few columns?
- HOW TO define autocomplete (AJAX autosuggest) feature in filtering?
- HOW TO set default values for filtering fields?
- HOW TO create dependent dropdown lists for filtering fields? * - popular
- HOW TO create complicated filter fields?
- HOW TO add my own JavaScript validation for search fields?
- HOW TO dynamically build dropdown list for filtering fields?
- HOW TO add new comparison operator for filtering fields?
- HOW TO make filtering automatically when you change something in filtering fields?
- HOW TO make filtering fields automatically added to default selection in Add/Edit Mode?
Languages:
Exporting:
- HOW TO turn 'On' exporting feature and setup export paths?
- HOW TO show diacritic chars in export file?
- HOW TO to solve problems with exporting?
Caching:
Foreign Keys:
- HOW TO define foreign keys and work with them?
- HOW TO work with composite foreign keys?
- HOW TO release one-to-many or many-to-many connections? * - popular
- HOW TO retrieve only DISTINCT values for foreign keys?
Pagination:
Layouts, Styles and CSS:
- HOW TO add a new CSS style or change the existing one?
- HOW TO create and use customized layouts?
- HOW TO make rounded corners for datagrid elements?
Integration with Other Programs:
- HOW TO integrate DataGrid within Joomla?
- HOW TO integrate DataGrid within WordPress?
- HOW TO implement DataGrid with Smarty easily?
- HOW TO replace openWYSIWYG editor with other editors?