custom sorting in gridview

[AVL]

Hi
I want to implment cusotm sorting in gridview...
Ive a dropdown box on my page where ive all the fields(columsn) to be sorted..
whenever hte user selects the value in the dropdown , the gridview should be
sorted...

As of now, whenever user selects a value in the dropdown , Im rebinding
the grid with sorting applied....
but this is hittng the page performance...

so Im thinking to get the datasource associated with the girdview and then
sort the data...
Ive used gridview,DataSource property to retrieve the datatable associated
with it..
but its always returning null.

can some one help me out with this issue.
why is the DataSource property returnign null though the data is present...
How the .net has implemented the default sorting without reloading..??.

 

[Lisa Ashley Rafter]

Hi
I want to implment cusotm sorting in gridview...
Ive a dropdown box on my page where ive all the fields(columsn) to be sorted..
whenever hte user selects the value in the dropdown , the gridview should be
sorted...

As of now, whenever user selects a value in the dropdown , Im rebinding
the grid with sorting applied....
but this is hittng the page performance...

so Im thinking to get the datasource associated with the girdview and then
sort the data...
Ive used gridview,DataSource property to retrieve the datatable associated
with it..
but its always returning null.

can some one help me out with this issue.
why is the DataSource property returnign null though the data is present....
How the .net has implemented the default sorting without reloading..??.

The custom sorting kinda stinks. I ended up having to handle it on my
own by handling the datagrid.sortcommand event and basically rerunning
my query with the correct "order by" clause. It's clunky but it
works. I found that .net wasn't always correctly re-ordering things
(for example if you had unique transaction id's like A1, A2, A3, etc,
it wasn't ordering then correctly. It would order like A1, A10, A2,
A3, etc. )
Not sure what version of .net you're on but this is what I needed to
do in 1.1.
BTW how are you getting the datatable out of the datasource? Can you
post some code?