<%@ LANGUAGE="VBSCRIPT" %> Rico LiveGrid-Example 4 <% session.contents("customergrid")="select CustomerID,CompanyName,ContactName,Address,City,Region,PostalCode,Country,Phone,Fax from customers order by CustomerID" session.contents("ordergrid")="select CustomerID,OrderID,ShipName,ShipCity,ShipCountry,OrderDate,ShippedDate from orders order by OrderID" session.contents("detailgrid")="select OrderID,p.ProductName,QuantityPerUnit,od.UnitPrice,Quantity,od.UnitPrice*Quantity as Total,Discount,od.UnitPrice*Quantity*(1.0-Discount) as NetPrice from order_details od left join products p on od.ProductID=p.ProductID order by od.ProductID" %>
Double-click on a row to see all orders for that customer.

Drag the edge of a column heading to resize a column.

To filter: right-click (ctrl-click in Opera, Konqueror, or Safari) on the value that you would like to use as the basis for filtering, then select the desired filtering method from the pop-up menu.

Right-click anywhere in a column to see sort, hide, and show options.

Notice that filters and sorting in the customer grid persist after a refresh. The saveColumnInfo option specifies that these values should be saved in cookies.

Customers

Cust ID Company Contact Address City Region Postal Code Country Phone Fax

 

Customer# Order# Ship Name Ship City Ship Country Order Date Ship Date

 

Order # Description Unit Quantity Unit Price Qty Total Discount Net Price