<%@ Page Language="VB" ResponseEncoding="iso-8859-1" validateRequest="false" %> <%@ Register TagPrefix="Rico" Assembly="Rico" NameSpace="Rico" %> <%@ Register TagPrefix="My" TagName="dbLib" Src="dbConnect.ascx" %> Rico LiveGrid-Example 2 (editable)
Base Library:
The data on this grid can be edited using pop-up forms. Just click on a grid cell and then select Edit, Delete, or Add from the pop-up menu. Updates are disabled on the database, so you will get an error message if you try to save.

Each request for data is processed separately. No session variables are used. The disadvantage is that the query must be completely rebuilt every time - and just building the query requires an additional query to the database to get table metadata (primary keys, etc). This overhead is not required when session variables are used.

Orders Table (without sessions)