SQL Web Grid Editor 2.0

SQL Web Grid Editor 2.0 offers you an application which can be used as a cross-browser grid component. This application is designed to display, edit and sort tabular data from database. Made in JavaScript, the grid content can be imported from Xml/Ajax/Json data source. Methods for converting database to Xml are giving for PHP/MySQL and .Net/SQL-Server users. Grid design controlled by Cascading Style Sheet (CSS).

The component enables flexible data sorting (boolean, string, integer, date, etc) and filtering (ex: by region, street, name, etc). Set columns to read-only columns, multiline headers, merge two or more database table into one grid display, three filters and sorts keys, display/hide/resize columns. Events, properties and methods handlers let you add necessary interactivity between SQL-database and the grid. Illimited table join (relationship between parent grid and child grid). Live tracking/withdraw of row change. Insert/Delete row. Support UTF-8 character.

Set columns format to any rendering format you want (ex: accounting, date, etc). Data entry respect the columns format (ex: you can only type number into an integer column). The grid already supports a wide variety of cell formats such as string, string strict (a-z/A-Z only), int, date, float, picture, hyperlink, select (listbox), checkbox (boolean). Paging ready. Extendable architecture enables any data type input to be add. Support keyboard navigation and Excel style table edition. The developer has access to documentation explaining step-by-step how the grid works. Save from 50 to 90% development time.

Major Features:

1. The easiest way to render SQL database table in browser;
2. All java script, xml and css base (no plug-in, no server/client install);
3. No extra code to write with another library or online example (plug & play style);
4. Easy to combine with any other Java Script libraries;
5. Work with all SQL Database and in all server side language (PHP, .Net, Java, etc)
6. Combine two (or more) database table in the same grid;
7. Build for Ajax, Json or Hidden Frame transport;
8. Support MDI Windows;
9. Illimited column content formating style;
10. Illimited table join (relationship between parent grid and child grid);
11. 8 grid propreties, 28 grid methods and 12 grid events
12. Paging ready;
13. Built-in picture and hyper Link column style;
14. Give your users the ability to apply complex filter and sorting;
15. Easy client/server communication;
16. Math formulas for cells;
17. Easy styling with css;
18. Live tracking/withdraw of row change;
19. Retype the original cell value to withdraw row change (saving icon will be disable);
20. Keep original content for easy auditing;
21. Insert/Delete row(s);
22. Columns resizeable;
23. Select two (or more) rows in the same grid with the keyboard shift/control key;
24. Move the current row/cell selection in the grid with the keyboard arrow key;
25. Allow single or multiple row(s) change before saving on the server side;
26. Support anglo-saxon (English, German), latin (French, Spanish, Italian, Portuguese) and baltic/cyrillic (Russian, Latvian, Ukrainian) character;
27. Support arabic right to left data entry;
28. Ease of translation for different languages;
29. Support of W3C DTD HTML 4.01 and XHTML 1.0;
30. Comments embedded in the .js, .css and .xml to get you started quickly;
31. Work on all server & all platform.

Requirements: HTTP Web Server

WareSeeker Editor