OBOUT - ASP.NET Grid - Multiple Rows

Quick Links

Purchase

ASP.NET Grid - Summary Row

ORDER ID

SHIP NAME

SHIPPED DATE

SHIP COUNTRY


10248	Vins et alcools Chevalier	07/16/1996 7/16/1996 12:00:00 AM	Brazil
10249	Toms Spezialitäten	07/10/1996 7/10/1996 12:00:00 AM	Germany
10250	Hanari Carnes	07/12/1996 7/12/1996 12:00:00 AM	Austria
10251	Victuailles en stock	07/15/1996 7/15/1996 12:00:00 AM	France
10252	Suprêmes délices	07/11/1996 7/11/1996 12:00:00 AM	Belgium
10253	Hanari Carnes	07/16/1996 7/16/1996 12:00:00 AM	Brazil
10254	Chop-suey Chinese	07/23/1996 7/23/1996 12:00:00 AM	Switzerland
10255	Richter Supermarkt	07/15/1996 7/15/1996 12:00:00 AM	Switzerland
10256	Wellington Importadora	07/17/1996 7/17/1996 12:00:00 AM	Brazil
10257	HILARION-Abastos	07/22/1996 7/22/1996 12:00:00 AM	Venezuela
10258	Ernst Handel	07/23/1996 7/23/1996 12:00:00 AM	Austria
10259	Centro comercial Moctezuma	07/25/1996 7/25/1996 12:00:00 AM	Mexico
10260	Ottilies Käseladen	07/29/1996 7/29/1996 12:00:00 AM	Germany
10261	Que Delícia	07/30/1996 7/30/1996 12:00:00 AM	Brazil
10262	Rattlesnake Canyon Grocery	07/25/1996 7/25/1996 12:00:00 AM	USA
10263	Ernst Handel	07/31/1996 7/31/1996 12:00:00 AM	Austria
10264	Folk och fä HB	08/23/1996 8/23/1996 12:00:00 AM	Sweden
10265	Blondel père et fils	08/12/1996 8/12/1996 12:00:00 AM	France
10266	Wartian Herkku	07/31/1996 7/31/1996 12:00:00 AM	Finland
10267	Frankenversand	08/06/1996 8/6/1996 12:00:00 AM	Germany
10268	GROSELLA-Restaurante	08/02/1996 8/2/1996 12:00:00 AM	Venezuela
10269	White Clover Markets	08/09/1996 8/9/1996 12:00:00 AM	USA
10270	Wartian Herkku	08/02/1996 8/2/1996 12:00:00 AM	Finland
10271	Split Rail Beer & Ale	08/30/1996 8/30/1996 12:00:00 AM	USA
10272	Rattlesnake Canyon Grocery	08/06/1996 8/6/1996 12:00:00 AM	USA
10273	QUICK-Stop	08/12/1996 8/12/1996 12:00:00 AM	Germany
10274	Vins et alcools Chevalier	08/16/1996 8/16/1996 12:00:00 AM	France
10275	Magazzini Alimentari Riuniti	08/09/1996 8/9/1996 12:00:00 AM	Italy
10276	Tortuga Restaurante	08/14/1996 8/14/1996 12:00:00 AM	Mexico
10277	Morgenstern Gesundkost	08/13/1996 8/13/1996 12:00:00 AM	Germany
10278	Berglunds snabbköp	08/16/1996 8/16/1996 12:00:00 AM	Sweden
10279	Lehmanns Marktstand	08/16/1996 8/16/1996 12:00:00 AM	Germany
10280	Berglunds snabbköp	09/12/1996 9/12/1996 12:00:00 AM	Sweden
10281	Romero y tomillo	08/21/1996 8/21/1996 12:00:00 AM	Spain
10282	Romero y tomillo	08/21/1996 8/21/1996 12:00:00 AM	Spain
10283	LILA-Supermercado	08/23/1996 8/23/1996 12:00:00 AM	Venezuela
10284	Lehmanns Marktstand	08/27/1996 8/27/1996 12:00:00 AM	Germany
10285	QUICK-Stop	08/26/1996 8/26/1996 12:00:00 AM	Germany
10286	QUICK-Stop	08/30/1996 8/30/1996 12:00:00 AM	Germany
10287	Ricardo Adocicados	08/28/1996 8/28/1996 12:00:00 AM	Brazil
10288	Reggiani Caseifici	09/03/1996 9/3/1996 12:00:00 AM	Italy
10289	B's Beverages	08/28/1996 8/28/1996 12:00:00 AM	UK
10290	Comércio Mineiro	09/03/1996 9/3/1996 12:00:00 AM	Brazil
10291	Que Delícia	09/04/1996 9/4/1996 12:00:00 AM	Brazil
10292	Tradiçao Hipermercados	09/02/1996 9/2/1996 12:00:00 AM	Brazil
10293	Tortuga Restaurante	09/11/1996 9/11/1996 12:00:00 AM	Mexico
10294	Rattlesnake Canyon Grocery	09/05/1996 9/5/1996 12:00:00 AM	USA
10295	Vins et alcools Chevalier	09/10/1996 9/10/1996 12:00:00 AM	France
10296	LILA-Supermercado	09/11/1996 9/11/1996 12:00:00 AM	Venezuela
10297	Blondel père et fils	09/10/1996 9/10/1996 12:00:00 AM	France
10298	Hungry Owl All-Night Grocers	09/11/1996 9/11/1996 12:00:00 AM	Ireland
10299	Ricardo Adocicados	09/13/1996 9/13/1996 12:00:00 AM	Brazil
10300	Magazzini Alimentari Riuniti	09/18/1996 9/18/1996 12:00:00 AM	Italy
10301	Die Wandernde Kuh	09/17/1996 9/17/1996 12:00:00 AM	Germany
10302	Suprêmes délices	10/09/1996 10/9/1996 12:00:00 AM	Belgium
10303	Godos Cocina Típica	09/18/1996 9/18/1996 12:00:00 AM	Spain
10304	Tortuga Restaurante	09/17/1996 9/17/1996 12:00:00 AM	Mexico
10305	Old World Delicatessen	10/09/1996 10/9/1996 12:00:00 AM	USA
10306	Romero y tomillo	09/23/1996 9/23/1996 12:00:00 AM	Spain
10307	Lonesome Pine Restaurant	09/25/1996 9/25/1996 12:00:00 AM	USA
10308	Ana Trujillo Emparedados y helados	09/24/1996 9/24/1996 12:00:00 AM	Mexico
10309	Hungry Owl All-Night Grocers	10/23/1996 10/23/1996 12:00:00 AM	Ireland
10310	The Big Cheese	09/27/1996 9/27/1996 12:00:00 AM	USA
10311	Du monde entier	09/26/1996 9/26/1996 12:00:00 AM	France
10312	Die Wandernde Kuh	10/03/1996 10/3/1996 12:00:00 AM	Germany
10313	QUICK-Stop	10/04/1996 10/4/1996 12:00:00 AM	Germany
10314	Rattlesnake Canyon Grocery	10/04/1996 10/4/1996 12:00:00 AM	USA
10315	Island Trading	10/03/1996 10/3/1996 12:00:00 AM	UK
10316	Rattlesnake Canyon Grocery	10/08/1996 10/8/1996 12:00:00 AM	USA
10317	Lonesome Pine Restaurant	10/10/1996 10/10/1996 12:00:00 AM	USA
10318	Island Trading	10/04/1996 10/4/1996 12:00:00 AM	UK
10319	Tortuga Restaurante	10/11/1996 10/11/1996 12:00:00 AM	Mexico
10320	Wartian Herkku	10/18/1996 10/18/1996 12:00:00 AM	Finland
10321	Island Trading	10/11/1996 10/11/1996 12:00:00 AM	UK
10322	Pericles Comidas clásicas	10/23/1996 10/23/1996 12:00:00 AM	Mexico
10323	Königlich Essen	10/14/1996 10/14/1996 12:00:00 AM	Germany
10324	Save-a-lot Markets	10/10/1996 10/10/1996 12:00:00 AM	USA
10325	Königlich Essen	10/14/1996 10/14/1996 12:00:00 AM	Germany
10326	Bólido Comidas preparadas	10/14/1996 10/14/1996 12:00:00 AM	Spain
10327	Folk och fä HB	10/14/1996 10/14/1996 12:00:00 AM	Sweden
10328	Furia Bacalhau e Frutos do Mar	10/17/1996 10/17/1996 12:00:00 AM	Portugal
10329	Split Rail Beer & Ale	10/23/1996 10/23/1996 12:00:00 AM	USA
10330	LILA-Supermercado	10/28/1996 10/28/1996 12:00:00 AM	Venezuela
10331	Bon app'	10/21/1996 10/21/1996 12:00:00 AM	France
10332	Mère Paillarde	10/21/1996 10/21/1996 12:00:00 AM	Canada
10333	Wartian Herkku	10/25/1996 10/25/1996 12:00:00 AM	Finland
10334	Victuailles en stock	10/28/1996 10/28/1996 12:00:00 AM	France
10335	Hungry Owl All-Night Grocers	10/24/1996 10/24/1996 12:00:00 AM	Ireland
10336	Princesa Isabel Vinhos	10/25/1996 10/25/1996 12:00:00 AM	Portugal
10337	Frankenversand	10/29/1996 10/29/1996 12:00:00 AM	Germany
10338	Old World Delicatessen	10/29/1996 10/29/1996 12:00:00 AM	USA
10339	Mère Paillarde	11/04/1996 11/4/1996 12:00:00 AM	Canada
10340	Bon app'	11/08/1996 11/8/1996 12:00:00 AM	France
10341	Simons bistro	11/05/1996 11/5/1996 12:00:00 AM	Denmark
10342	Frankenversand	11/04/1996 11/4/1996 12:00:00 AM	Germany
10343	Lehmanns Marktstand	11/06/1996 11/6/1996 12:00:00 AM	Germany
10344	White Clover Markets	11/05/1996 11/5/1996 12:00:00 AM	USA
10345	QUICK-Stop	11/11/1996 11/11/1996 12:00:00 AM	Germany
10346	Rattlesnake Canyon Grocery	11/08/1996 11/8/1996 12:00:00 AM	USA
10347	Familia Arquibaldo	11/08/1996 11/8/1996 12:00:00 AM	Brazil
10348	Die Wandernde Kuh	11/15/1996 11/15/1996 12:00:00 AM	Germany
10349	Split Rail Beer & Ale	11/15/1996 11/15/1996 12:00:00 AM	USA
10350	La maison d'Asie	12/03/1996 12/3/1996 12:00:00 AM	France
10351	Ernst Handel	11/20/1996 11/20/1996 12:00:00 AM	Austria
10352	Furia Bacalhau e Frutos do Mar	11/18/1996 11/18/1996 12:00:00 AM	Portugal
10353	Piccolo und mehr	11/25/1996 11/25/1996 12:00:00 AM	Austria
10354	Pericles Comidas clásicas	11/20/1996 11/20/1996 12:00:00 AM	Mexico
10355	Around the Horn	11/20/1996 11/20/1996 12:00:00 AM	UK
10356	Die Wandernde Kuh	11/27/1996 11/27/1996 12:00:00 AM	Germany
10357	LILA-Supermercado	12/02/1996 12/2/1996 12:00:00 AM	Venezuela
10358	La maison d'Asie	11/27/1996 11/27/1996 12:00:00 AM	France
10359	Seven Seas Imports	11/26/1996 11/26/1996 12:00:00 AM	UK
10360	Blondel père et fils	12/02/1996 12/2/1996 12:00:00 AM	France
10361	QUICK-Stop	12/03/1996 12/3/1996 12:00:00 AM	Germany
10362	Bon app'	11/28/1996 11/28/1996 12:00:00 AM	France
10363	Drachenblut Delikatessen	12/04/1996 12/4/1996 12:00:00 AM	Germany
10364	Eastern Connection	12/04/1996 12/4/1996 12:00:00 AM	UK
10365	Antonio Moreno Taquería	12/02/1996 12/2/1996 12:00:00 AM	Mexico
10366	Galería del gastronómo	12/30/1996 12/30/1996 12:00:00 AM	Spain
10367	Vaffeljernet	12/02/1996 12/2/1996 12:00:00 AM	Denmark
10368	Ernst Handel	12/02/1996 12/2/1996 12:00:00 AM	Austria
10369	Split Rail Beer & Ale	12/09/1996 12/9/1996 12:00:00 AM	USA
10370	Chop-suey Chinese	12/27/1996 12/27/1996 12:00:00 AM	Switzerland
10371	La maison d'Asie	12/24/1996 12/24/1996 12:00:00 AM	France
10372	Queen Cozinha	12/09/1996 12/9/1996 12:00:00 AM	Brazil
10373	Hungry Owl All-Night Grocers	12/11/1996 12/11/1996 12:00:00 AM	Ireland
10374	Wolski Zajazd	12/09/1996 12/9/1996 12:00:00 AM	Poland
10375	Hungry Coyote Import Store	12/09/1996 12/9/1996 12:00:00 AM	USA
10376	Mère Paillarde	12/13/1996 12/13/1996 12:00:00 AM	Canada
10377	Seven Seas Imports	12/13/1996 12/13/1996 12:00:00 AM	UK
10378	Folk och fä HB	12/19/1996 12/19/1996 12:00:00 AM	Sweden
10379	Que Delícia	12/13/1996 12/13/1996 12:00:00 AM	Brazil
10380	Hungry Owl All-Night Grocers	01/16/1997 1/16/1997 12:00:00 AM	Ireland
10381	LILA-Supermercado	12/13/1996 12/13/1996 12:00:00 AM	Venezuela
10382	Ernst Handel	12/16/1996 12/16/1996 12:00:00 AM	Austria
10383	Around the Horn	12/18/1996 12/18/1996 12:00:00 AM	UK
10384	Berglunds snabbköp	12/20/1996 12/20/1996 12:00:00 AM	Sweden
10385	Split Rail Beer & Ale	12/23/1996 12/23/1996 12:00:00 AM	USA
10386	Familia Arquibaldo	12/25/1996 12/25/1996 12:00:00 AM	Brazil
10387	Santé Gourmet	12/20/1996 12/20/1996 12:00:00 AM	Norway
10388	Seven Seas Imports	12/20/1996 12/20/1996 12:00:00 AM	UK
10389	Bottom-Dollar Markets	12/24/1996 12/24/1996 12:00:00 AM	Canada
10390	Ernst Handel	12/26/1996 12/26/1996 12:00:00 AM	Austria
10391	Drachenblut Delikatessen	12/31/1996 12/31/1996 12:00:00 AM	Germany
10392	Piccolo und mehr	01/01/1997 1/1/1997 12:00:00 AM	Austria
10393	Save-a-lot Markets	01/03/1997 1/3/1997 12:00:00 AM	USA
10394	Hungry Coyote Import Store	01/03/1997 1/3/1997 12:00:00 AM	USA
10395	HILARION-Abastos	01/03/1997 1/3/1997 12:00:00 AM	Venezuela
10396	Frankenversand	01/06/1997 1/6/1997 12:00:00 AM	Germany
10397	Princesa Isabel Vinhos	01/02/1997 1/2/1997 12:00:00 AM	Portugal

Most Orders: Ernst Handel
Fewest Orders: Toms Spezialitäten

Day with Most Orders: 12/02/1996
Day with Fewest Orders: 07/10/1996
Month with Most Orders: December
Month with Fewest Orders: January
Year with Most Orders: 1996
Year with Fewest Orders: 1997

Most Orders: Germany
Fewest Orders: Poland

You can easily display aggregates in the footer of the Grid using the RowDataBound event and the ShowColumnsFooter property. You can have as much data in the footer row as you wish. As you can see in this example, you can make it look as if the Grid has multiple footer rows.

"This is one of the best thought out controls. Thank you for your efforts! "

Steven Hahn