Click here to Skip to main content
15,867,686 members
Articles / Web Development / ASP.NET
Article

Simple DataGrid grouping

Rate me:
Please Sign up or sign in to vote.
3.16/5 (34 votes)
14 Dec 20031 min read 219.2K   3.4K   46   38
The given class provides a simple way of grouping DataGrid rows as it is done in MS FlexGrid ActiveX control.

Sample Image - Preview.jpg

Introduction

Everybody knows that a DataGrid is a very useful control that is available in ASP.NET. It has many built-in features, such as sorting, paging, etc. However, one useful thing is lacking – the ability to merge cells like it is implemented in MS FlexGrid ActiveX control. In one of my projects, I came across this need and decided to implement it.

Designing a web control is claimed to be an easy thing, but my choice was to develop a reusable class. How to do it?

The Code Itself

There is a well-known ability in .NET framework – binding events to user-defined procedures. In VB.NET, it is achieved by using AddHandler routine. Upon my class initialization, GroupGridItem is bound to the ItemDataBound event of the DataGrid control.

So, every time ItemDataBound event is raised, the control passes to GroupGridItem method of the class. It is here that all the stuff takes place. The algorithm is pretty simple: for each bound item, it searches previously bound ones and if the content of the respective cells match, it hides current cell and increases the previous visible cell RowSpan value by one.

The use of the class is simple – just pass the DataGrid to format and the column indices you'd like to see grouped.

This is only a first version of the class, so it supports only Bound columns. Your comments will be really appreciated.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here


Written By
Web Developer
Belarus Belarus
I work for Logic Software (http://www.logicsoftware.net) as a lead .NET developer/architect.

Comments and Discussions

 
GeneralMy vote of 5 Pin
Manoj Kumar Choubey7-Feb-12 19:29
professionalManoj Kumar Choubey7-Feb-12 19:29 
GeneralMerging row in Template column [modified] Pin
sarika tyagi7-Sep-08 16:45
sarika tyagi7-Sep-08 16:45 
QuestionHi Can i get the same code in C# for databound column. Plz help Pin
harsha123457-Jul-08 3:42
harsha123457-Jul-08 3:42 
GeneralHelp me peleas Pin
juan e tobias9-Jun-08 12:51
juan e tobias9-Jun-08 12:51 
GeneralMerging fails with AutoGenerated columns Pin
Francois Grobler6-Dec-06 22:52
Francois Grobler6-Dec-06 22:52 
GeneralIsGroupedCol Pin
amit singla6-Dec-06 22:08
amit singla6-Dec-06 22:08 
GeneralRe: IsGroupedCol Pin
Francois Grobler6-Dec-06 22:50
Francois Grobler6-Dec-06 22:50 
QuestionIsGroupedCol still missing Pin
r.desjardins19-May-06 5:31
r.desjardins19-May-06 5:31 
AnswerRe: IsGroupedCol still missing Pin
Francois Grobler6-Dec-06 22:47
Francois Grobler6-Dec-06 22:47 
Questionmissing IsGroupedCol function Pin
Smiles7423-Mar-06 5:50
Smiles7423-Mar-06 5:50 
QuestionHow could I use the class from my aspx? Pin
lprado31-Jan-06 4:50
lprado31-Jan-06 4:50 
GeneralWhy noone is interested in enhancing WinDatagrid Pin
FaiNg22-Nov-05 20:45
FaiNg22-Nov-05 20:45 
QuestionWindows data grid Pin
Mukund Pujari5-Sep-05 2:23
Mukund Pujari5-Sep-05 2:23 
AnswerRe: Windows data grid Pin
arilou5-Sep-05 2:29
arilou5-Sep-05 2:29 
QuestionTrace not declared - any resolution? Pin
CliffGilbert3-Aug-05 22:59
CliffGilbert3-Aug-05 22:59 
AnswerRe: Trace not declared - any resolution? Pin
arilou3-Aug-05 23:11
arilou3-Aug-05 23:11 
GeneralRe: Trace not declared - any resolution? Pin
CliffGilbert3-Aug-05 23:29
CliffGilbert3-Aug-05 23:29 
Generalexcellent Pin
pragaw26-May-05 4:07
pragaw26-May-05 4:07 
GeneralThanks Pin
Albai Adrian26-Apr-05 3:04
Albai Adrian26-Apr-05 3:04 
GeneralError in Trace Pin
yolimap15-Feb-05 10:38
yolimap15-Feb-05 10:38 
GeneralError in Trace Pin
yolimap15-Feb-05 10:35
yolimap15-Feb-05 10:35 
GeneralMissing IsGroupedCol Function Pin
Mahendra N11-Jan-05 22:27
Mahendra N11-Jan-05 22:27 
GeneralRe: Missing IsGroupedCol Function Pin
Ricardo Ostos14-Feb-05 12:42
Ricardo Ostos14-Feb-05 12:42 
GeneralRe: Missing IsGroupedCol Function Pin
yolimap15-Feb-05 10:59
yolimap15-Feb-05 10:59 
GeneralRe: Missing IsGroupedCol Function Pin
Ricardo Ostos15-Feb-05 12:00
Ricardo Ostos15-Feb-05 12:00 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.