<%@ LANGUAGE="VBSCRIPT" %> Rico LiveGrid-Example 2 <% Session.Timeout=60 dim id id=trim(request.querystring("id")) sqltext="select OrderID,CustomerID,ShipName,ShipCity,ShipCountry,OrderDate,ShippedDate from orders order by OrderID" if len(id)=5 then sqltext=sqltext & " where CustomerID='" & id & "'" session.contents("ex2")=sqltext %>
<% GridSettingsForm %> This example uses AJAX to fetch order data as required. It also demonstrates how the number of rows can be set automatically based on the size of the window.

 

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