Loading rico1 and rico3 files
[infodrom/rico3] / examples / dotnet / ex2json.aspx
diff --git a/examples/dotnet/ex2json.aspx b/examples/dotnet/ex2json.aspx
new file mode 100644 (file)
index 0000000..9bd4f83
--- /dev/null
@@ -0,0 +1,67 @@
+<%@ Page Language="VB" ResponseEncoding="iso-8859-1" Debug="true" %>\r
+<%@ Register TagPrefix="Rico" TagName="LiveGrid" Src="../../plugins/dotnet/LiveGrid.ascx" %>\r
+<%@ Register TagPrefix="Rico" TagName="Column" Src="../../plugins/dotnet/GridColumn.ascx" %>\r
+<%@ Register TagPrefix="My" TagName="LoadRicoClient" Src="LoadRicoClient.ascx" %>\r
+<%@ Register TagPrefix="My" TagName="dbLib" Src="dbConnect.ascx" %>\r
+<My:dbLib id='app' runat='server' />\r
+\r
+\r
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">\r
+<html>\r
+<head>\r
+<title>Rico LiveGrid-Example 2</title>\r
+\r
+<My:LoadRicoClient id='initlibs' runat='server' />\r
+<link href="../demo.css" type="text/css" rel="stylesheet" />\r
+\r
+<style type="text/css">\r
+div.ricoLG_cell {\r
+  white-space:nowrap;\r
+}\r
+</style>\r
+</head>\r
+<body>\r
+\r
+<table id='explanation' border='0' cellpadding='0' cellspacing='5' style='clear:both'><tr valign='top'><td>\r
+Base Library: \r
+<script type='text/javascript'>\r
+document.write(Rico.Lib+' '+Rico.LibVersion);\r
+</script>\r
+<hr>\r
+This example uses AJAX to fetch order data, as required, from the server. \r
+Notice how the number of visible rows is set automatically based\r
+on the size of the window. Try the different grid styles that\r
+are available. \r
+Click on a cell to see available actions.\r
+<a href='ricoQuery.aspx?id=ex2j&offset=0&page_size=10&_fmt=json'>View the AJAX response (JSON)</a>\r
+(requires JSONview or similar extension in FF).\r
+</td>\r
+<td>\r
+<script type="text/javascript"><!--\r
+google_ad_client = "pub-7218597156507462";\r
+/* 125x125, created 5/11/09 */\r
+google_ad_slot = "9298106441";\r
+google_ad_width = 125;\r
+google_ad_height = 125;\r
+//-->\r
+</script>\r
+<script type="text/javascript"\r
+src="http://pagead2.googlesyndication.com/pagead/show_ads.js">\r
+</script>\r
+</td>\r
+</tr></table>\r
+\r
+<Rico:LiveGrid runat='server' id='ex2j' fmt="json" TableName='orders' DefaultSort='OrderID' menuEvent='click' frozenColumns='1' highlightElem='cursorRow'>\r
+<GridColumns>\r
+  <Rico:Column runat='server' ColName='OrderID' heading='Order#' width='60' />\r
+  <Rico:Column runat='server' ColName='CustomerID' heading='Cust#' width='60' />\r
+  <Rico:Column runat='server' ColName='ShipName' heading='Ship Name' width='150' />\r
+  <Rico:Column runat='server' ColName='ShipCity' heading='Ship City' width='120' />\r
+  <Rico:Column runat='server' ColName='ShipCountry' heading='Ship Country' width='90' />\r
+  <Rico:Column runat='server' ColName='OrderDate' heading='Order Date' datatype='date' width='100' />\r
+  <Rico:Column runat='server' ColName='ShippedDate' heading='Ship Date' datatype='date' width='100' />\r
+</GridColumns>\r
+</Rico:LiveGrid>\r
+\r
+</body>\r
+</html>\r