---

Please note: This page was retired in July 2006.

You can find current information from the links below

Publisher

• Nitobi (3)

Categories

• Grids (124)
• User Interface (277)

If you need to buy a license for this specific version, please contact us for availability and pricing.

Other information on this page is shown for historical reference only and may have changed considerably since.

---

Manipulate data in real-time through instantly-appearing combo boxes, text boxes, date fields, checkboxes and more - all without page reloads. EBA: Grid/Combo Bundle includes the EBA: Grid Control and EBA: Web ComboBox. EBA Grid Control is a JavaScript and DHTML based data-entry and data-browsing grid control designed to render data asynchronously from a remote database in a familiar Microsoft Excel style interface. Web ComboBox is a robust Section 508-compliant solution designed for enterprise and public Web applications. Its feature-set is extensive and includes six unique search modes, but is intended to be simple enough to integrate quickly with minimal effort. Includes support for ASP.NET, Classic ASP, JSP, and PHP 4+.

EBA Grid Control Overview

The EBA Grid Control is a JavaScript and DHTML based data-entry and data-browsing control designed to render data asynchronously from a remote database in a familiar Microsoft Excel style interface. J2EE (JSP) and ASP versions are included.

The lightweight nature of the Grid distinguishes it from similar products. It downloads quickly, requires no preinstalled software or action from the user to install, and features a robust and full-featured user interface.

V2 is the spreadsheet and data-entry solution for financial applications, point of sale systems, and database management tools. The control is delivered seamlessly with the web page as a JavaScript attachment. This means your application will not require prior installation of any software, and will be Windows Service Pack 2 compatible.

Supporting Rapid Application Development (RAD) in J2EE, and ASP

The EBA Grid was designed to harness the extraordinary hidden power of the IE 5.5+ browser series while balancing the need for flexibility, and ease of integration. The Grid offers an intuitive client and server-side API combined with extensive support resources, allowing developers to create business solutions quickly. Developers are assisted by a powerful feature-set, including:

• Intuitive Excel or Windows Explorer-like interface. Edit records as you would in an Excel spreadsheet. Perform calculations (via the JavaScript API), and use advanced data input controls like comboboxes, drop-down lists, checkboxes, hyperlinks, and image buttons
• In-place editing. Cells are directly editable as in Excel
• Background data communication. Load and save data asychronously without reloading the page or interrupting work-flow. Page through large datasets or enable automatic background saving of changes
• Bind to popular databases. An open-ended server-side API enables connectivity to virtually any database type, including Oracle, MySQL, DB2, MS SQL, Access, and Comma Separated Value files. The grid can also be used a completely unbound mode
• Configurable client-side validation. A complete client-side JavaScript API provides powerful validation capabilities. Take advantage of our extensive knowledgebase, demonstrating step-by-step how to use this in frequent-use scenarios
• Calculated fields. Perform real-time tax or summation calculations, or implement unique business logic through simple event-based JavaScript calls
• Column Sorting. Real-time type-aware sorting of the local dataset at the column level
• Resizable Columns. Reshape your grid in real-time by manipulating column size with the mouse
• Copy and Paste (Excel Compatible). Select blocks of cells and copy between the Grid and Excel or itself. This functionality is totally bidirectional
• Lightweight and all-JavaScript. A small core file size and all JavaScript delivery means your application will deliver quickly to all of your users without security warnings or long download times

Feature Highlights:

• Column Freezing. Freeze n columns to the left while preserving the scrolling ability on other columns. Useful for viewing complex recordsets
• Asynchronous Paging. Quickly scroll through large datasets without reloading the page
• Databound Comboboxes. Specialized input type with type-ahead autocomplete. Eg: Bind a cell to a remote database containing a list of clients which is loaded on demand from the server. Type the first few letters of the client's name and the combobox will attempt to guess which you are typing
• AutoSave. Save all changes to the Grid asynchronously in real time as the user types without interruping workflow or reloading the page
• Predefined Visual Styles. Brand your grid using one of our 5 predefined visual styles, including Office XP, Windows XP, Clean, Horizontal Columns, and Basic. Customize these styles to fit your application, or make your own
• Formatted data entry. Use data masking for number and date cells. Present 1/1/2005 as "January 1, 2005" or 123456789 as "123,456,789.00"
• Multiple cell types including:
  • Text - Standard text
  • Number - Standard number types with input masking
  • Dates - Including specialized validation and input masking
  • Boolean - Check boxes with custom true/false values
  • Combo Boxes - Custom DHTML combo boxes that bind to separate data sources. Draw from a list of client names in real time without reloading the page
  • List Boxes - Standard HTML list boxes

The result is faster editing of large datasets. The grids unique architecture builds on powerful functionality provided by the Internet Explorer 5+ browser. Users are able to bind to all types of data sources including Oracle, MySQL, MS SQL, ODBC and other database types with business logic and connection code defined by the developer. The compressed XML datagram schema enables faster paging of the server for almost seamless client-side control of your web-form.

EBA: Web ComboBox Overview

Building on recent user-interface innovations found in Google, Gmail, and Mozilla applications, V3 provides six unique data search and entry modes. Extensive cross-browser compatibility is achieved by leveraging EBA's new x-browser XML and DHTML engine. Take advantage of some of V3's extensive search capabilities, and know that your application will render and behave properly for the end-user.

EBA: Web ComboBox V3 Highlights:

• Section 508 compliant
• Cross-browser compatibile and PC/Mac Compatible
• Scalable and robust
• Choice of six different search modes. The ultimate solution for web input completion
• Suitable for public web spaces

A combobox, also known as a dropdownlist or lookup control, is an autocompleting textbox bound to a recordset. In it's simplest form, it resembles the HTML listbox control with an editable field. Web Combobox, however, allows the developer to do so much more.

EBA have implemented over 60 key usability recommendations and feature requests from the popular V2 combobox. These range from changes to databinding to a re-designed rendering engine, and include security fixes, compatibility enhancements, and six completely unique searching modes not seen in other controls:

Filter - The dropdown element is bound tightly to the remote dataset. It only appears as the user types and returns a concise list of suggestions. Features used include type-ahead and autosizing listbox. LiveSearch.

SmartList - This mode allows the user to build a list of items in a text area. It uses the Intelligent Autocomplete (Fuzzy Search) feature to assist selection from a dataset, and when the user selects a value, it is automatically added to a list of items in the text area (seperated by a comma or some other character). This is similar to the feature provided by Gmail when choosing a recipient for a new message. You can select multiple eMail addresses and they are all deposited in the textarea.

Compact - When non-intrusiveness is important, use Compact mode to provide only type-ahead functionality with only a textbox (no listbox will appear). Subtle but powerful.

Classic - This is the standard web-based combobox behaviour - powerful and ubiquitous. The local dataset refreshes as the user types (as in other modes) but users can page the dataset (increase the local dataset size by keying to the bottom of the list or clicking the 'page' button). Keyboard navigation provides complete control over paging.

Unbound - Bind the combo to a static dataset like an HTML listbox would be. In unbound you can still make use of autocomplete and type ahead functionality.

Intelligent Autocomplete - AKA "Fuzzy Search". When a user begins typing, suggestions are brought up that contain that string anywhere (not just at the beginning). The appearance of the searched-for substring is bolded. Records can be brought up in order of "importance" (achieved through SQL). This is similar to the functionality provided by Gmail when choosing recipients for a new eMail message. The end user can type a name and the listbox will display the most likely targets.