Sort datagrid with out refreshing the data

[ralphtrent]

Hi
I have a question. Can I sort the data in a datagrid with out having to go out to the database again. Also, I want to add paging. When I do the paging and sort a column the whole data set gets refreshed and my sorting is lost.

So what I would like happen is this
1. not have to go out to the database each time I sort a column.

2. when I sort the column, leave the sort even when i move pages.

I think that i am asking for is not to complicated but i can not figure it out.


Thanks

 

[Mike555]

See this link about storing your dataset in Session State when binding the dg...

http://msdn.microsoft.com/library/d...code/html/vbtskcodesortingdatagridcontrol.asp

Regards,
Mike

"Don’t get suckered in by the comments – they can be terribly misleading. Debug
only code. – Dave Storer."

 

[checkai]

look into DataViews...they can be sorted and searched i believe

 

[ralphtrent]

i have the sorting working, its just when i page the sorting is gone, I think it is because I keep refreshing my dataview when i go to the next page. Is there a way around that?

Thanks

 

[checkai]

you need to set your sorting value as a session variable...then everytime you refresh you dataview it will either remember what the session("sort") was or set the session("sort")...does that sound right?

 

[ralphtrent]

i see what you are saying, Checkai..

Thanks

 

[checkai]

Have you gotten this to work correctly.?