git.infodrom.org Git - infodrom/rico3/blob - examples/dotnet/gridFromTable.aspx

   1 <%@ Page Language="VB" ResponseEncoding="iso-8859-1" validateRequest="false" %>\r
   2 <%@ Register TagPrefix="Rico" Assembly="Rico" NameSpace="Rico" %>\r
   3 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">\r
   4 <html>\r
   5 <head>\r
   6 <meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">\r
   7 <title>Rico LiveGrid sourced from HTML table</title>\r
   8 \r
   9 <Rico:LoadClient checkQueryString='true' runat='server' />\r
  10 <link href="../demo.css" type="text/css" rel="stylesheet" />\r
  11 \r
  12 </head>\r
  13 \r
  14 <body>\r
  15 <div id='explanation'>\r
  16 Base Library:\r
  17 <script type='text/javascript'>\r
  18 document.write(Rico.Lib+' '+Rico.LibVersion);\r
  19 </script>\r
  20 <hr>\r
  21 This example demonstrates how Rico can convert an existing HTML table into\r
  22 a much more usable LiveGrid. With the .net server control, you just specify the column names and an HtmlSourceId.\r
  23 LiveGrid provides scrolling, column resizing, filtering, and sorting capabilities.\r
  24 When the data is static (as it is in this example), then filtering and sorting take place on the client.\r
  25 When the data source is a SQL database, then filtering and sorting are done by the database.\r
  26 Click on a cell to see the available actions.\r
  27 </div>\r
  28 \r
  29 <Rico:LiveGrid runat='server' id='derby' menuEvent='click' frozenColumns='1' highlightElem='cursorRow' HtmlSourceId='derby_data'>\r
  30   <Rico:Column runat='server' heading='Year'   width='70' />\r
  31   <Rico:Column runat='server' heading='Horse'  width='120' />\r
  32   <Rico:Column runat='server' heading='Jockey' width='120' />\r
  33 </Rico:LiveGrid>\r
  34 \r
  35 <table id="derby_data" style="display:none;">\r
  36 <tbody>\r
  37 <tr> <td>1875</td> <td>Aristides</td> <td>O. Lewis</td> </tr> \r
  38 <tr> <td>1876</td> <td>Vagrant</td> <td>B. Swim</td> </tr> \r
  39 <tr> <td>1877</td> <td>Baden-Baden</td> <td>W. Walker</td> </tr> \r
  40 <tr> <td>1878</td> <td>Day Star</td> <td>J. Carter</td> </tr> \r
  41 <tr> <td>1879</td> <td>Lord Murphy</td> <td>C. Shauer</td> </tr> \r
  42 <tr> <td>1880</td> <td>Fonso</td> <td>G. Lewis</td> </tr> \r
  43 <tr> <td>1881</td> <td>Hindoo</td> <td>J. McLaughlin</td> </tr> \r
  44 <tr> <td>1882</td> <td>Apollo</td> <td>B. Hurd</td> </tr> \r
  45 <tr> <td>1883</td> <td>Leonatus</td> <td>W. Donohue</td> </tr> \r
  46 <tr> <td>1884</td> <td>Buchanan</td> <td>I. Murphy</td> </tr> \r
  47 <tr> <td>1885</td> <td>Joe Cotton</td> <td>E. Henderson</td> </tr> \r
  48 <tr> <td>1886</td> <td>Ben Ali</td> <td>P. Duffy</td> </tr> \r
  49 <tr> <td>1887</td> <td>Montrose</td> <td>I. Lewis</td> </tr> \r
  50 <tr> <td>1888</td> <td>Macbeth II</td> <td>G. Covington</td> </tr> \r
  51 <tr> <td>1889</td> <td>Spokane</td> <td>T. Kiley</td> </tr> \r
  52 <tr> <td>1890</td> <td>Riley</td> <td>I. Murphy</td> </tr> \r
  53 <tr> <td>1891</td> <td>Kingman</td> <td>I. Murphy</td> </tr> \r
  54 <tr> <td>1892</td> <td>Azra</td> <td>A. Clayton</td> </tr> \r
  55 <tr> <td>1893</td> <td>Lookout</td> <td>E. Kunze</td> </tr> \r
  56 <tr> <td>1894</td> <td>Chant</td> <td>F. Goodale</td> </tr> \r
  57 <tr> <td>1895</td> <td>Halma</td> <td>J. Perkins</td> </tr> \r
  58 <tr> <td>1896</td> <td>Ben Brush</td> <td>W. Simms</td> </tr> \r
  59 <tr> <td>1897</td> <td>Typhoon II</td> <td>F. Garner</td> </tr> \r
  60 <tr> <td>1898</td> <td>Plaudit</td> <td>W. Simms</td> </tr> \r
  61 <tr> <td>1899</td> <td>Manuel</td> <td>F. Taral</td> </tr> \r
  62 <tr> <td>1900</td> <td>Lieut. Gibson</td> <td>J. Boland</td> </tr> \r
  63 <tr> <td>1901</td> <td>His Eminence</td> <td>J. Winkfield</td> </tr> \r
  64 <tr> <td>1902</td> <td>Alan-a-Dale</td> <td>J. Winkfield</td> </tr> \r
  65 <tr> <td>1903</td> <td>Judge Himes</td> <td>H. Booker</td> </tr> \r
  66 <tr> <td>1904</td> <td>Elwood</td> <td>F. Prior</td> </tr> \r
  67 <tr> <td>1905</td> <td>Agile</td> <td>J. Martin</td> </tr> \r
  68 <tr> <td>1906</td> <td>Sir Huon</td> <td>R. Troxler</td> </tr> \r
  69 <tr> <td>1907</td> <td>Pink Star</td> <td>A. Minder</td> </tr> \r
  70 <tr> <td>1908</td> <td>Stone Street</td> <td>A. Pickens</td> </tr> \r
  71 <tr> <td>1909</td> <td>Wintergreen</td> <td>V. Powers</td> </tr> \r
  72 <tr> <td>1910</td> <td>Donau</td> <td>F. Herbert</td> </tr> \r
  73 <tr> <td>1911</td> <td>Meridian</td> <td>G. Archibald</td> </tr> \r
  74 <tr> <td>1912</td> <td>Worth</td> <td>C.H. Shilling</td> </tr> \r
  75 <tr> <td>1913</td> <td>Donerail</td> <td>R. Goose</td> </tr> \r
  76 <tr> <td>1914</td> <td>Old Rosebud</td> <td>J. McCabe</td> </tr> \r
  77 <tr> <td>1915</td> <td>Regret</td> <td>J. Nolter</td> </tr> \r
  78 <tr> <td>1916</td> <td>George Smith</td> <td>J. Loftus</td> </tr> \r
  79 <tr> <td>1917</td> <td>Omar Khayyam</td> <td>C. Borel</td> </tr> \r
  80 <tr> <td>1918</td> <td>Exterminator</td> <td>W. Knapp</td> </tr> \r
  81 <tr> <td>1919</td> <td>Sir Barton</td> <td>J. Loftus</td> </tr> \r
  82 <tr> <td>1920</td> <td>Paul Jones</td> <td>T. Rice</td> </tr> \r
  83 <tr> <td>1921</td> <td>Behave Yourself</td> <td>C. Thompson</td> </tr> \r
  84 <tr> <td>1922</td> <td>Morvich</td> <td>A. Johnson</td> </tr> \r
  85 <tr> <td>1923</td> <td>Zev</td> <td>E. Sande</td> </tr> \r
  86 <tr> <td>1924</td> <td>Black Gold</td> <td>J.D. Mooney</td> </tr> \r
  87 <tr> <td>1925</td> <td>Flying Ebony</td> <td>E. Sande</td> </tr> \r
  88 <tr> <td>1926</td> <td>Bubbling Over</td> <td>A. Johnson</td> </tr> \r
  89 <tr> <td>1927</td> <td>Whiskery</td> <td>L. McAtee</td> </tr> \r
  90 <tr> <td>1928</td> <td>Reigh Count</td> <td>C. Lang</td> </tr> \r
  91 <tr> <td>1929</td> <td>Clyde Van Dusen</td> <td>L. McAtee</td> </tr> \r
  92 <tr> <td>1930</td> <td>Gallant Fox</td> <td>E. Sande</td> </tr> \r
  93 <tr> <td>1931</td> <td>Twenty Grand</td> <td>C. Kurtsinger</td> </tr> \r
  94 <tr> <td>1932</td> <td>Burgoo King</td> <td>E. James</td> </tr> \r
  95 <tr> <td>1933</td> <td>Brokers Tip</td> <td>D. Meade</td> </tr> \r
  96 <tr> <td>1934</td> <td>Cavalcade</td> <td>M. Garner</td> </tr> \r
  97 <tr> <td>1935</td> <td>Omaha</td> <td>W. Saunders</td> </tr> \r
  98 <tr> <td>1936</td> <td>Bold Venture</td> <td>I. Hanford</td> </tr> \r
  99 <tr> <td>1937</td> <td>War Admiral</td> <td>C. Kurtsinger</td> </tr> \r
 100 <tr> <td>1938</td> <td>Lawrin</td> <td>E. Arcaro</td> </tr> \r
 101 <tr> <td>1939</td> <td>Johnstown</td> <td>J. Scout</td> </tr> \r
 102 <tr> <td>1940</td> <td>Gallahadion</td> <td>C. Bierman</td> </tr> \r
 103 <tr> <td>1941</td> <td>Whirlaway</td> <td>E. Arcaro</td> </tr> \r
 104 <tr> <td>1942</td> <td>Shut Out</td> <td>W.D. Wright</td> </tr> \r
 105 <tr> <td>1943</td> <td>Count Fleet</td> <td>J. Longden</td> </tr> \r
 106 <tr> <td>1944</td> <td>Pensive</td> <td>C. McCreary</td> </tr> \r
 107 <tr> <td>1945</td> <td>Hoop Jr.</td> <td>E. Arcaro</td> </tr> \r
 108 <tr> <td>1946</td> <td>Assault</td> <td>W. Mehrtens</td> </tr> \r
 109 <tr> <td>1947</td> <td>Jet Pilot</td> <td>E. Guerin</td> </tr> \r
 110 <tr> <td>1948</td> <td>Citation</td> <td>E. Arcaro</td> </tr> \r
 111 <tr> <td>1949</td> <td>Ponder</td> <td>S. Brooks</td> </tr> \r
 112 <tr> <td>1950</td> <td>Middleground</td> <td>W. Boland</td> </tr> \r
 113 <tr> <td>1951</td> <td>Count Turf</td> <td>C. McCreary</td> </tr> \r
 114 <tr> <td>1952</td> <td>Hill Gail</td> <td>E. Arcaro</td> </tr> \r
 115 <tr> <td>1953</td> <td>Dark Star</td> <td>H. Moreno</td> </tr> \r
 116 <tr> <td>1954</td> <td>Determine</td> <td>R. York</td> </tr> \r
 117 <tr> <td>1955</td> <td>Swaps</td> <td>W. Shoemaker</td> </tr> \r
 118 <tr> <td>1956</td> <td>Needles</td> <td>D. Erb</td> </tr> \r
 119 <tr> <td>1957</td> <td>Iron Liege</td> <td>W. Hartack</td> </tr> \r
 120 <tr> <td>1958</td> <td>Tim Tam</td> <td>I. Valenzuela</td> </tr> \r
 121 <tr> <td>1959</td> <td>Tomy Lee</td> <td>W. Shoemaker</td> </tr> \r
 122 <tr> <td>1960</td> <td>Venetian Way</td> <td>W. Hartack</td> </tr> \r
 123 <tr> <td>1961</td> <td>Carry Back</td> <td>J. Sellers</td> </tr> \r
 124 <tr> <td>1962</td> <td>Decidedly</td> <td>W. Hartack</td> </tr> \r
 125 <tr> <td>1963</td> <td>Chateaugay</td> <td>B. Baeza</td> </tr> \r
 126 <tr> <td>1964</td> <td>Northern Dancer</td> <td>W. Hartack</td> </tr> \r
 127 <tr> <td>1965</td> <td>Lucky Debonair</td> <td>W. Shoemaker</td> </tr> \r
 128 <tr> <td>1966</td> <td>Kauai King</td> <td>D. Brumfield</td> </tr> \r
 129 <tr> <td>1967</td> <td>Proud Clarion</td> <td>R. Ussery</td> </tr> \r
 130 <tr> <td>1968*</td> <td>Dancer&rsquo;s Image</td> <td>I. Valenzuela</td> </tr> \r
 131 <tr> <td>1969</td> <td>Majestic Prince</td> <td>W. Hartack</td> </tr> \r
 132 <tr> <td>1970</td> <td>Dust Commander</td> <td>M. Manganello</td> </tr> \r
 133 <tr> <td>1971</td> <td>Canonero II</td> <td>G. Avila</td> </tr> \r
 134 <tr> <td>1972</td> <td>Riva Ridge</td> <td>R. Turcotte</td> </tr> \r
 135 <tr> <td>1973**</td> <td>Secretariat</td> <td>R. Turcotte</td> </tr> \r
 136 <tr> <td>1974</td> <td>Cannonade</td> <td>A. Cordero, Jr.</td> </tr> \r
 137 <tr> <td>1975</td> <td>Foolish Pleasure</td> <td>J. Vasquez</td> </tr> \r
 138 <tr> <td>1976</td> <td>Bold Forbes</td> <td>A. Cordero, Jr.</td> </tr> \r
 139 <tr> <td>1977</td> <td>Seattle Slew</td> <td>J. Cruguet</td> </tr> \r
 140 <tr> <td>1978</td> <td>Affirmed</td> <td>S. Cauthen</td> </tr> \r
 141 <tr> <td>1979</td> <td>Spectacular Bid</td> <td>R. Franklin</td> </tr> \r
 142 <tr> <td>1980</td> <td>Genuine Risk</td> <td>J. Vasquez</td> </tr> \r
 143 <tr> <td>1981</td> <td>Pleasant Colony</td> <td>J. Velasquez</td> </tr> \r
 144 <tr> <td>1982</td> <td>Gato del Sol</td> <td>E. Delahoussaye</td> </tr> \r
 145 <tr> <td>1983</td> <td>Sunny&rsquo;s Halo</td> <td>E. Delahoussaye</td> </tr> \r
 146 <tr> <td>1984</td> <td>Swale</td> <td>L. Pincay</td> </tr> \r
 147 <tr> <td>1985</td> <td>Spend a Buck</td> <td>A. Cordero, Jr.</td> </tr> \r
 148 <tr> <td>1986</td> <td>Ferdinand</td> <td>W. Shoemaker</td> </tr> \r
 149 <tr> <td>1987</td> <td>Alysheba</td> <td>C. McCarron</td> </tr> \r
 150 <tr> <td>1988</td> <td>Winning Colors</td> <td>G. Stevens</td> </tr> \r
 151 <tr> <td>1989</td> <td>Sunday Silence</td> <td>P. Valenzuela</td> </tr> \r
 152 <tr> <td>1990</td> <td>Unbridled</td> <td>C. Perret</td> </tr> \r
 153 <tr> <td>1991</td> <td>Strike the Gold</td> <td>C. Antley</td> </tr> \r
 154 <tr> <td>1992</td> <td>Lil E. Tee</td> <td>P. Day</td> </tr> \r
 155 <tr> <td>1993</td> <td>Sea Hero</td> <td>J. Bailey</td> </tr> \r
 156 <tr> <td>1994</td> <td>Go For Gin</td> <td>C. McCarron</td> </tr> \r
 157 <tr> <td>1995</td> <td>Thunder Gulch</td> <td>G. Stevens</td> </tr> \r
 158 <tr> <td>1996</td> <td>Grindstone</td> <td>J. Bailey</td> </tr> \r
 159 <tr> <td>1997</td> <td>Silver Charm</td> <td>G. Stevens</td> </tr> \r
 160 <tr> <td>1998</td> <td>Real Quiet</td> <td>K. Desormeaux</td> </tr> \r
 161 <tr> <td>1999</td> <td>Charismatic</td> <td>C. Antley</td> </tr> \r
 162 <tr> <td>2000</td> <td>Fusaichi Pegasus</td> <td>K. Desormeaux</td> </tr> \r
 163 <tr> <td>2001</td> <td>Monarchos</td> <td>J. Chavez</td> </tr> \r
 164 <tr> <td>2002</td> <td>War Emblem</td> <td>V. Espinoza</td> </tr> \r
 165 <tr> <td>2003</td> <td>Funny Cide</td> <td>J. Santos</td> </tr> \r
 166 <tr> <td>2004</td> <td>Smarty Jones</td> <td>S. Elliott</td> </tr> \r
 167 <tr> <td>2005</td> <td>Giacomo</td> <td>M. Smith</td> </tr> \r
 168 <tr> <td>2006</td> <td>Barbaro</td> <td>E. Prado</td> </tr> \r
 169 <tr> <td>2007</td> <td>Street Sense</td> <td>C. Borel</td> </tr> \r
 170 <tr> <td>2008</td> <td>Big Brown</td> <td>K. Desormeaux</td> </tr> \r
 171 <tr> <td>2009</td> <td>Mine That Bird</td> <td>C. Borel</td> </tr> \r
 172 </tbody> \r
 173 </table>   \r
 174 \r
 175 <p style='font-size: x-small;'>*Dancer&rsquo;s Image disqualified but later reinstated.\r
 176 <br> **Fastest time&mdash;1 min 59 2/5 s. No other horse has raced the Derby in less than 2 min.</p> \r
 177 \r
 178 </body>\r
 179 </html>\r