Home
SQLGridSelectedView
       Simple Grid - NorthWind Products Simple Grid - NorthWind Products
       Simple Grid with DropDown Filter Selection Simple Grid with DropDown Filter Selection
       Simple Grid with Text Search Simple Grid with Text Search
       Milti-Grid Page using Intermodule Communication Milti-Grid Page using Intermodule Communication
       Product - Editable Product - Editable
       Orders Editable with Template Orders Editable with Template
       User Selection by Field User Selection by Field
       In-Line Function MakeLink  In-Line Function MakeLink 
       Browser Breakdown Browser Breakdown
       Selection Links Selection Links
       Golf Scores from Excel Spreadsheet Golf Scores from Excel Spreadsheet
       Wait on Previous Filter Wait on Previous Filter
       Customers using UDF Split Customers using UDF Split
       Rollup Columns  Rollup Columns 
SQLChart
       Line - Orders Per Month Line - Orders Per Month
       Spline - Visitors and Views Spline - Visitors and Views
       Column - Vistors And Views Column - Vistors And Views
       Column 3D - Visitors and Views Column 3D - Visitors and Views
       Bar - Visitors and Views Bar - Visitors and Views
       Area - Vistors and Views Area - Vistors and Views
       Stacked Column - Visitors and Views Stacked Column - Visitors and Views
       Browser Breakdown Browser Breakdown
       Sales per month Sales per month
       Bot Views Bot Views
T-Minus
       Examples Examples
XMLdb
       User List User List
       Revised User List Revised User List
       NorthWind Employees NorthWind Employees
       NorthWind Customers Paging Example NorthWind Customers Paging Example
IFrame64
       Display URL Display URL
       With Parameters With Parameters
       With Parameters - Base64 Encoded With Parameters - Base64 Encoded
       With Parameters - Parameter Encrypted With Parameters - Parameter Encrypted
       With Parameters as Single Parameter With Parameters as Single Parameter
MenuLinks
       Horizontal Siblings Horizontal Siblings
       Vertical Siblings Vertical Siblings
       Parent Horizontal Parent Horizontal
       Parent Vertical Parent Vertical
       Vertical Children  Vertical Children 
       Templated Templated
ThermoChart
       Simple Thermometer
       Simple Thermometer - Square
       Simple Thermometer - No Scale
       Colorful Thermometer
       ColorFul Thermometer #2
       Guage Style
       Guage Style #2
       Fund Raising
       Fat Albert
       SQL Matrix - Percentage
SimpleQuery
       SimpleQuery - DesktopModules SimpleQuery - DesktopModules
       SimpleQuery - Products SimpleQuery - Products
       SimpleQuery - Products with Column Sort SimpleQuery - Products with Column Sort
       SimpleQuery - IMC SimpleQuery - IMC
 		SQLGridSelectedView » Simple Grid with DropDown Filter Selection
 
Simple Grid with DropDown Filter Selection  
 
 
 
This sample displays the following features:
  • Header display -- whay you are reading
  • Dropdown Filter Selection with Displayed is not the same as value used by select
  • Sortable Columns - initial sort on CustomerID
  • Record Count Displayed
  • Paging for 50 records per page
  • Export to CSV (Excel)
  • Export to PDF
  • Default CSS classed applied
Select Customer
OrderIDCustomerIDEmployeeIDOrderDateRequiredDateShippedDateFreightShipNameShipCityShipRegionShipCountry
10643ALFKI68/25/1997 12:00:00 AM9/22/1997 12:00:00 AM9/2/1997 12:00:00 AM29.4600Alfreds FutterkisteBerlin Germany
10692ALFKI410/3/1997 12:00:00 AM10/31/1997 12:00:00 AM10/13/1997 12:00:00 AM61.0200Alfred's FutterkisteBerlin Germany
10702ALFKI410/13/1997 12:00:00 AM11/24/1997 12:00:00 AM10/21/1997 12:00:00 AM23.9400Alfred's FutterkisteBerlin Germany
10835ALFKI11/15/1998 12:00:00 AM2/12/1998 12:00:00 AM1/21/1998 12:00:00 AM69.5300Alfred's FutterkisteBerlin Germany
10952ALFKI13/16/1998 12:00:00 AM4/27/1998 12:00:00 AM3/24/1998 12:00:00 AM40.4200Alfred's FutterkisteBerlin Germany
11011ALFKI34/9/1998 12:00:00 AM5/7/1998 12:00:00 AM4/13/1998 12:00:00 AM1.2100Alfred's FutterkisteBerlin Germany
10926ANATR43/4/1998 12:00:00 AM4/1/1998 12:00:00 AM3/11/1998 12:00:00 AM39.9200Ana Trujillo Emparedados y heladosMéxico D.F. Mexico
10759ANATR311/28/1997 12:00:00 AM12/26/1997 12:00:00 AM12/12/1997 12:00:00 AM11.9900Ana Trujillo Emparedados y heladosMéxico D.F. Mexico
10625ANATR38/8/1997 12:00:00 AM9/5/1997 12:00:00 AM8/14/1997 12:00:00 AM43.9000Ana Trujillo Emparedados y heladosMéxico D.F. Mexico
10308ANATR79/18/1996 12:00:00 AM10/16/1996 12:00:00 AM9/24/1996 12:00:00 AM1.6100Ana Trujillo Emparedados y heladosMéxico D.F. Mexico
10365ANTON311/27/1996 12:00:00 AM12/25/1996 12:00:00 AM12/2/1996 12:00:00 AM22.0000Antonio Moreno TaqueríaMéxico D.F. Mexico
10507ANTON74/15/1997 12:00:00 AM5/13/1997 12:00:00 AM4/22/1997 12:00:00 AM47.4500Antonio Moreno TaqueríaMéxico D.F. Mexico
10535ANTON45/13/1997 12:00:00 AM6/10/1997 12:00:00 AM5/21/1997 12:00:00 AM15.6400Antonio Moreno TaqueríaMéxico D.F. Mexico
10677ANTON19/22/1997 12:00:00 AM10/20/1997 12:00:00 AM9/26/1997 12:00:00 AM4.0300Antonio Moreno TaqueríaMéxico D.F. Mexico
10573ANTON76/19/1997 12:00:00 AM7/17/1997 12:00:00 AM6/20/1997 12:00:00 AM84.8400Antonio Moreno TaqueríaMéxico D.F. Mexico
10682ANTON39/25/1997 12:00:00 AM10/23/1997 12:00:00 AM10/1/1997 12:00:00 AM36.1300Antonio Moreno TaqueríaMéxico D.F. Mexico
10856ANTON31/28/1998 12:00:00 AM2/25/1998 12:00:00 AM2/10/1998 12:00:00 AM58.4300Antonio Moreno TaqueríaMéxico D.F. Mexico
10864AROUT42/2/1998 12:00:00 AM3/2/1998 12:00:00 AM2/9/1998 12:00:00 AM3.0400Around the HornColchesterEssexUK
10920AROUT43/3/1998 12:00:00 AM3/31/1998 12:00:00 AM3/9/1998 12:00:00 AM29.6100Around the HornColchesterEssexUK
10953AROUT93/16/1998 12:00:00 AM3/30/1998 12:00:00 AM3/25/1998 12:00:00 AM23.7200Around the HornColchesterEssexUK
11016AROUT94/10/1998 12:00:00 AM5/8/1998 12:00:00 AM4/13/1998 12:00:00 AM33.8000Around the HornColchesterEssexUK
10707AROUT410/16/1997 12:00:00 AM10/30/1997 12:00:00 AM10/23/1997 12:00:00 AM21.7400Around the HornColchesterEssexUK
10741AROUT411/14/1997 12:00:00 AM11/28/1997 12:00:00 AM11/18/1997 12:00:00 AM10.9600Around the HornColchesterEssexUK
10743AROUT111/17/1997 12:00:00 AM12/15/1997 12:00:00 AM11/21/1997 12:00:00 AM23.7200Around the HornColchesterEssexUK
10768AROUT312/8/1997 12:00:00 AM1/5/1998 12:00:00 AM12/15/1997 12:00:00 AM146.3200Around the HornColchesterEssexUK
10793AROUT312/24/1997 12:00:00 AM1/21/1998 12:00:00 AM1/8/1998 12:00:00 AM4.5200Around the HornColchesterEssexUK
10558AROUT16/4/1997 12:00:00 AM7/2/1997 12:00:00 AM6/10/1997 12:00:00 AM72.9700Around the HornColchesterEssexUK
10453AROUT12/21/1997 12:00:00 AM3/21/1997 12:00:00 AM2/26/1997 12:00:00 AM25.3600Around the HornColchesterEssexUK
10355AROUT611/15/1996 12:00:00 AM12/13/1996 12:00:00 AM11/20/1996 12:00:00 AM41.9500Around the HornColchesterEssexUK
10383AROUT812/16/1996 12:00:00 AM1/13/1997 12:00:00 AM12/18/1996 12:00:00 AM34.2400Around the HornColchesterEssexUK
10384BERGS312/16/1996 12:00:00 AM1/13/1997 12:00:00 AM12/20/1996 12:00:00 AM168.6400Berglunds snabbköpLuleå Sweden
10278BERGS88/12/1996 12:00:00 AM9/9/1996 12:00:00 AM8/16/1996 12:00:00 AM92.6900Berglunds snabbköpLuleå Sweden
10280BERGS28/14/1996 12:00:00 AM9/11/1996 12:00:00 AM9/12/1996 12:00:00 AM8.9800Berglunds snabbköpLuleå Sweden
10444BERGS32/12/1997 12:00:00 AM3/12/1997 12:00:00 AM2/21/1997 12:00:00 AM3.5000Berglunds snabbköpLuleå Sweden
10445BERGS32/13/1997 12:00:00 AM3/13/1997 12:00:00 AM2/20/1997 12:00:00 AM9.3000Berglunds snabbköpLuleå Sweden
10524BERGS15/1/1997 12:00:00 AM5/29/1997 12:00:00 AM5/7/1997 12:00:00 AM244.7900Berglunds snabbköpLuleå Sweden
10572BERGS36/18/1997 12:00:00 AM7/16/1997 12:00:00 AM6/25/1997 12:00:00 AM116.4300Berglunds snabbköpLuleå Sweden
10672BERGS99/17/1997 12:00:00 AM10/1/1997 12:00:00 AM9/26/1997 12:00:00 AM95.7500Berglunds snabbköpLuleå Sweden
10654BERGS59/2/1997 12:00:00 AM9/30/1997 12:00:00 AM9/11/1997 12:00:00 AM55.2600Berglunds snabbköpLuleå Sweden
10626BERGS18/11/1997 12:00:00 AM9/8/1997 12:00:00 AM8/20/1997 12:00:00 AM138.6900Berglunds snabbköpLuleå Sweden
10778BERGS312/16/1997 12:00:00 AM1/13/1998 12:00:00 AM12/24/1997 12:00:00 AM6.7900Berglunds snabbköpLuleå Sweden
10733BERGS111/7/1997 12:00:00 AM12/5/1997 12:00:00 AM11/10/1997 12:00:00 AM110.1100Berglunds snabbköpLuleå Sweden
10689BERGS110/1/1997 12:00:00 AM10/29/1997 12:00:00 AM10/7/1997 12:00:00 AM13.4200Berglunds snabbköpLuleå Sweden
10924BERGS33/4/1998 12:00:00 AM4/1/1998 12:00:00 AM4/8/1998 12:00:00 AM151.5200Berglunds snabbköpLuleå Sweden
10866BERGS52/3/1998 12:00:00 AM3/3/1998 12:00:00 AM2/12/1998 12:00:00 AM109.1100Berglunds snabbköpLuleå Sweden
10857BERGS81/28/1998 12:00:00 AM2/25/1998 12:00:00 AM2/6/1998 12:00:00 AM188.8500Berglunds snabbköpLuleå Sweden
10837BERGS91/16/1998 12:00:00 AM2/13/1998 12:00:00 AM1/23/1998 12:00:00 AM13.3200Berglunds snabbköpLuleå Sweden
10875BERGS42/6/1998 12:00:00 AM3/6/1998 12:00:00 AM3/3/1998 12:00:00 AM32.3700Berglunds snabbköpLuleå Sweden
10853BLAUS91/27/1998 12:00:00 AM2/24/1998 12:00:00 AM2/3/1998 12:00:00 AM53.8300Blauer See DelikatessenMannheim Germany
10956BLAUS63/17/1998 12:00:00 AM4/28/1998 12:00:00 AM3/20/1998 12:00:00 AM44.6500Blauer See DelikatessenMannheim Germany
830 Total RecordsAs of 04:12:12Page 1 of 17
Expot to Excel as CSV | Export to PDF

 
 
 
 
 
 
 
 
  Copyright 2009 by TressleWorks