Po Box 1004
Wynnum, QLD
Australia 4178
p: +61 7 3907 0449
m: +61 416 286 210
f: +61 7 3907 0449
e: help@chillipepper.com.au
w: http://www.chillipepper.com.au

Grid View Example

The below example is of a grid view that allows advanced grouping, filtering, ordering and searching of large databases with exceptional perfomance due to on demand data sets.

The example demonstrated below is using the Microsoft Adventure Works database, displaying customer and customer sales order data. As you can see there are nearly 2000 pages of results, yet the performance of the grid view is not comprimised.

For more information about this example, and how some of the functionality outlined here might be applied to your business please contact us.
Drag a column header here to group by that column
#
Contact ID
Title
First Name
Last Name
Email Address
Phone
  
[Expand] 1Mr.GustavoAchonggustavo0@adventure-works.com398-555-0132
[Expand] 2Ms.CatherineAbelcatherine0@adventure-works.com747-555-0171
[Expand] 3Ms.KimAbercrombiekim2@adventure-works.com334-555-0137
[Expand] 4Sr.HumbertoAcevedohumberto0@adventure-works.com599-555-0127
[Expand] 5Sra.PilarAckermanpilar1@adventure-works.com1 (11) 500 555-0132
[Expand] 6Ms.FrancesAdamsfrances0@adventure-works.com991-555-0183
[Expand] 7Ms.MargaretSmithmargaret0@adventure-works.com959-555-0151
[Expand] 8Ms.CarlaAdamscarla0@adventure-works.com107-555-0138
[Expand] 9Mr.JayAdamsjay1@adventure-works.com158-555-0142
[Expand] 10Mr.RonaldAdinaronald0@adventure-works.com453-555-0165
Page 1 of 1998 (19972 items)
Prev
[1]
2
3
4
5
6
7
…
1996
1997
1998
Next




Data Grouping

The grouping options of this data grid are extremely simple to use. Simply drag the field to the grouping bar and the data grid will be grouped by that field. In this example, and the examples following on from this, we have used the "Last Name" field.

IMAGE ONLY
Data Grouping

^Top



Viewing Grouped Data

Once you are viewing grouped data you simply click the expansion link to view the data in that result.

IMAGE ONLY
Viewing Grouped Data

^Top



Viewing Grouped Node Details

When you are viewing grouped data you can also expand the grouped data node to view the details of that node.

IMAGE ONLY
Viewing Grouped Node Details

^Top



Column Ordering

You can configure the order of columns in any way you wish by dragging that column to the location you wish it to be displayed. In this example we have moved the Email Address to be the first field to be displayed in the grid view.

IMAGE ONLY
Column Ordering

^Top



Searching

You can complete searches by any of the columns in the data set. Simply type the search string in the text area provided, wait a few seconds and the results will be displayed for you.

IMAGE ONLY
Searching

^Top