Custom sorting object datasource bound gridview

Question

I want to sort my GridView bound to an object DataSource fetching business objects. I have already implemented custom paging & now want to implement sorting. Just read this article but there is lot of concatenation going on there with the SQL Query.

Any other elegant solution?

https://web.archive.org/web/20211020202742/https://aspnet.4guysfromrolla.com/articles/032206-1.aspx#

Kamran Khan · Accepted Answer · 2010-07-19 07:06:14Z

1

How about sorting using .DefaultView? Following is upon grd_Sorting event.

DataView dv = dt.DefaultView;//Your datatable, dt.
dv.RowFilter = "";//Set row filter to none.
if ((strSortBy != null) && (strSortAscending != null))
    dv.Sort = strSortBy/*Column name*/ + " " + strSortAscending /*ASC, for instance.*/;

grd.DataSource = dv;
grd.DataBind();

answered Jul 19, 2010 at 7:06

Kamran Khan

9,9842 gold badges33 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Zo Has Over a year ago

Hi my object data source returns List<T> with custom business objects. Would this solution work with that ? Also I am using custom paged data (like 10 objects per gridview page)

Kamran Khan Over a year ago

@Popo: In that case, I would implement an IComparable for my custom object. See switchonthecode.com/tutorials/…

Zo Has Over a year ago

Thanks for the reply. But, that would mean only sorting 10 records and not all records from the database (the query only fetches 10 rows per gridview page so sorting them isn't what Ia m looking for). I think its only possible on database level.

Zo Has · Accepted Answer · 2010-07-26 11:33:53Z

0

Solved it at query level with a dynamic where clause.

answered Jul 26, 2010 at 11:33

Zo Has

13.1k24 gold badges93 silver badges151 bronze badges

Collectives™ on Stack Overflow

Custom sorting object datasource bound gridview

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related