Last post May 07, 2010 11:18 AM by vt10000
May 07, 2010 11:18 AM|vt10000|LINK
Hi. I am trying to implement multi-column sorting using GridView control. I was wondering is there any way to extend the control to achieve sorting by multiple columns at once and have the ability to specify ASC/DESC on per column basis. I do not need
the user to click on each column header for this sorting, I have a list of 3 drop down controls listing all columns as well as radiobutton list with choices ASC/DESC where they can specify the sort order. I just need on submission to have the grid sort by
multiple columns with mixed bag sort order.
I know one way to do it is to modify the underlying SQL statement for the GridView to concatenate Order By clause where I can specify this sort, but I'd like to know if there is a way to dispence with this and have it done on the GridView level.