group data in gridview

[John]

On my gridview I need to group the sales by year.
2000 - 2001 - 2002, etc is there a way to do this with using the gridview?

example:
sales for: 2000
data
blank row
sales for: 2001
data
blank row

now the data that is being pulled back to populate the grid is the year

 

[John Timney \(MVP\)]

Cant you order the values in your select statement assuming your using a
select
http://www.w3schools.com/sql/sql_orderby.asp

 

[John]

I'm calling a stored procedure. I've done something similiar to this using
the datagrid in asp.net 1.1 but wasn't sure if that sameway would work or
not on the gridview in 2.0

 

[Jan Hyde]

On my gridview I need to group the sales by year.
2000 - 2001 - 2002, etc is there a way to do this with using the gridview?

example:
sales for: 2000
data
blank row
sales for: 2001
data
blank row

now the data that is being pulled back to populate the grid is the year

I haven't looked at how it works but I came across this
which may be of interest

http://aspadvice.com/blogs/joteke/archive/2006/02/11/15130.aspx

Jan Hyde (VB MVP)

 

[John]

thanks, I looked at the page briefly and by the image thats what i need

thanks

On my gridview I need to group the sales by year.
2000 - 2001 - 2002, etc is there a way to do this with using the gridview?

example:
sales for: 2000
data
blank row
sales for: 2001
data
blank row

now the data that is being pulled back to populate the grid is the year

I haven't looked at how it works but I came across this
which may be of interest

http://aspadvice.com/blogs/joteke/archive/2006/02/11/15130.aspx

Jan Hyde (VB MVP)

--
He that lives in hope danceth without music.

George Herbert
[Outlandish Proverbs, 1006]

 

[ziyad6]

Now the data grouping in gridview is made simple than ever before...

Try this free grouping gridview control with zero coding effort !

http://znetcontrols.blogspot.com/2008/08/extended-gridview-for-aspnet-20-with.html

HTH