Introduction & Documentation
HTML Examples (Accordion, Spreadsheet, etc)

These examples do not rely on any plug-in.

PHP Examples

The PHP-based XML data provider (ricoXMLquery.php, dbClass2.php, ricoXmlResponse.php) has been tested with the following databases: MySQL 4 & 5, Oracle XE, SQL Server 2005, MS Access.

LiveGrid-Static Buffer
Uses Rico.Buffer.Base - takes advantage of LiveGrid scrolling, but no AJAX
LiveGrid-Database Connection
Uses Rico.Buffer.AjaxSQL on the client and Rico's PHP plug-in on the server to pass query results from the database to the client via AJAX
LiveGrid Forms-Database Connection
Popup forms allow data to be edited and posted back to the original script. Populated using Rico.Buffer.AjaxSQL
LiveGrid-XML Data Source
Uses Rico.Buffer.AjaxXML to load data via AJAX at grid startup
SimpleGrid
No buffer - all data is in the DOM
Popup Controls
ASP Examples

The ASP-based XML data provider (ricoXMLquery.asp, dbClass2.vbs, ricoXmlResponse.vbs) has been tested with the following databases: SQL Server 2000/2005, Oracle XE, DB2 Express-C, MySQL 4 & 5, MS Access. The code is based on the ADO library, so it should work with most ADO compatible databases.

LiveGrid-Static Buffer
Uses Rico.Buffer.Base - takes advantage of LiveGrid scrolling, but no AJAX
LiveGrid-Database Connection
Uses Rico.Buffer.AjaxSQL on the client and Rico's ASP plug-in on the server to pass query results from the database to the client via AJAX
LiveGrid Forms-Database Connection
Popup forms allow data to be edited and posted back to the original script. Populated using Rico.Buffer.AjaxSQL
LiveGrid-XML Data Source
Uses Rico.Buffer.AjaxXML to load data via AJAX at grid startup
SimpleGrid
No buffer - all data is in the DOM
Popup Controls
.net Examples

The .net-based XML data provider (ricoXMLquery.aspx, ricoXmlResponse.ascx) has been tested with the following databases: SQL Server 2005, Oracle XE, DB2 Express-C, MySQL 4 & 5, MS Access. The code is based on the ADO.net library, so it should work with any database that has an ADO.net data provider. An alternate plug-in is available at: SharpPieces.

LiveGrid-Static Buffer
Uses Rico.Buffer.Base - takes advantage of LiveGrid scrolling, but no AJAX
LiveGrid-Database Connection
Uses Rico.Buffer.AjaxSQL on the client and Rico's .net plug-in on the server to pass query results from the database to the client via AJAX
LiveGrid Forms-Database Connection
Popup forms allow data to be edited and posted back to the original script. Populated using Rico.Buffer.AjaxSQL
LiveGrid-XML Data Source
Uses Rico.Buffer.AjaxXML to load data via AJAX at grid startup
SimpleGrid
No buffer - all data is in the DOM
Popup Controls
Perl Examples

The Perl-based XML data provider (ricoXMLquery.pl) is based on the dbi library and has been tested with the following databases: SQL Server 2000/2005, Oracle XE, MySQL 4 & 5, MS Access. Perl's lack of direct support for session variables has made it difficult to port code from the other Rico plug-ins. We are looking for contributors who would like to take up this challenge and more fully integrate this plug-in with Rico.

LiveGrid-Static Buffer
Uses Rico.Buffer.Base
LiveGrid-Database Connection
Uses Rico.Buffer.AjaxSQL