1 <%@ Page Language="VB" ResponseEncoding="iso-8859-1" %>
\r
2 <%@ Register TagPrefix="Rico" Assembly="Rico" NameSpace="Rico" %>
\r
3 <%@ Register TagPrefix="My" TagName="dbLib" Src="dbConnect.ascx" %>
\r
4 <My:dbLib id='app' runat='server' />
\r
6 <script runat="server">
\r
8 Sub Page_Load(Sender As object, e As EventArgs)
\r
15 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
\r
18 <title>Rico LiveGrid-Example 2</title>
\r
20 <Rico:LoadClient checkQueryString='true' runat='server' />
\r
21 <link href="../demo.css" type="text/css" rel="stylesheet" />
\r
23 <style type="text/css">
\r
31 <div id='explanation'>
\r
33 <script type='text/javascript'>
\r
34 document.write(Rico.Lib+' '+Rico.LibVersion);
\r
37 This example uses AJAX to fetch order data, as required, from the server.
\r
38 Notice how the number of visible rows is set automatically based
\r
39 on the size of the window. Try the different grid styles that
\r
41 Click on a cell to see available actions.
\r
42 <a href='<%=Page.Request.ServerVariables("SCRIPT_NAME")%>?_action_ex2x=query&offset=0&page_size=10'>View the AJAX response (XML)</a>.
\r
45 <Rico:LiveGrid runat='server' id='ex2x' TableName='orders' DefaultSort='OrderID' menuEvent='click' frozenColumns='1' highlightElem='cursorRow'>
\r
46 <Rico:Column runat='server' ColName='OrderID' heading='Order#' width='60' />
\r
47 <Rico:Column runat='server' ColName='CustomerID' heading='Cust#' width='60' />
\r
48 <Rico:Column runat='server' ColName='ShipName' heading='Ship Name' width='150' />
\r
49 <Rico:Column runat='server' ColName='ShipCity' heading='Ship City' width='120' />
\r
50 <Rico:Column runat='server' ColName='ShipCountry' heading='Ship Country' width='90' />
\r
51 <Rico:Column runat='server' ColName='OrderDate' heading='Order Date' datatype='date' width='100' />
\r
52 <Rico:Column runat='server' ColName='ShippedDate' heading='Ship Date' datatype='date' width='100' />
\r