| Groups | Blog | Home |
asp.net datagrid control : DataGrid Not Sorting
My web datagrid isn't sorting at all. I have it wired up to a handler, and I
know the handler is working (being called), but no sorting. The page just posts back with the same data. I hhave verified that the SortExpression values are the column names. I used the VS IDE to create a datasource ( a DataSet), defined a table and columns, then used the datagrid Propery Builder to tie eveything together. The table gets populated with data correctly, I just can't get it to sort.
If you're using a DataGrid then you have to do the sorting yourself in the
Sort event and rebind the DataGrid. It doesn't sort by itself, unfortunately. -Brock DevelopMentor http://staff.develop.com/ballen [quoted text, click to view] > My web datagrid isn't sorting at all. I have it wired up to a > handler, and I know the handler is working (being called), but no > sorting. The page just posts back with the same data. I hhave > verified that the SortExpression values are the column names. I used > the VS IDE to create a datasource ( a DataSet), defined a table and > columns, then used the datagrid Propery Builder to tie eveything > together. The table gets populated with data correctly, I just can't > get it to sort. > > Any help would be greatly appreciated. >
Yep, I'm doing that. The OnSortCommand handler retrieves a dataset from a
session variable (created when the page loaded), creates a dataview, then sorts on the SortExpression from the column clicked, assigns the DataSource and then rebinds the grid. Only it doesn't work. It acts like DataView.Sort doesn't work. I tried setting the intial sort expression to a different column when the page loads, that doesn't work either. [quoted text, click to view] "Brock Allen" wrote:
> If you're using a DataGrid then you have to do the sorting yourself in the > Sort event and rebind the DataGrid. It doesn't sort by itself, unfortunately. > > -Brock > DevelopMentor > http://staff.develop.com/ballen > > > My web datagrid isn't sorting at all. I have it wired up to a > > handler, and I know the handler is working (being called), but no > > sorting. The page just posts back with the same data. I hhave > > verified that the SortExpression values are the column names. I used > > the VS IDE to create a datasource ( a DataSet), defined a table and > > columns, then used the datagrid Propery Builder to tie eveything > > together. The table gets populated with data correctly, I just can't > > get it to sort. > > > > Any help would be greatly appreciated. > > > >
Hmm, not sure then. Sounds like you're doing all the right things. I'd suggest
making a new project with one page with the one grid and try to see if you can make it work outside of everything else -- more of a sanity check. If you can get that working then it's not the code you have for the grid, it's likley code elsewhere in the page that's thwarting the sort. -Brock DevelopMentor http://staff.develop.com/ballen [quoted text, click to view] > Yep, I'm doing that. The OnSortCommand handler retrieves a dataset > from a session variable (created when the page loaded), creates a > dataview, then sorts on the SortExpression from the column clicked, > assigns the DataSource and then rebinds the grid. Only it doesn't > work. It acts like DataView.Sort doesn't work. I tried setting the > intial sort expression to a different column when the page loads, that > doesn't work either. > > "Brock Allen" wrote: > >> If you're using a DataGrid then you have to do the sorting yourself >> in the Sort event and rebind the DataGrid. It doesn't sort by itself, >> unfortunately. >> >> -Brock >> DevelopMentor >> http://staff.develop.com/ballen >>> My web datagrid isn't sorting at all. I have it wired up to a >>> handler, and I know the handler is working (being called), but no >>> sorting. The page just posts back with the same data. I hhave >>> verified that the SortExpression values are the column names. I >>> used the VS IDE to create a datasource ( a DataSet), defined a table >>> and columns, then used the datagrid Propery Builder to tie eveything >>> together. The table gets populated with data correctly, I just >>> can't get it to sort. >>> >>> Any help would be greatly appreciated. >>>
I'd considered doing that, but what I do if it does work? What kinds of
things would prevent the sort from working? I've never tried using the sort feature on a datagrid before so this is new territory. I've used dataviews before, and implemented sorting, but I've never used the datagrid component before like this. Could there be something in the way the DataSource is defined in the page that affects the sorting? [quoted text, click to view] "Brock Allen" wrote:
> Hmm, not sure then. Sounds like you're doing all the right things. I'd suggest > making a new project with one page with the one grid and try to see if you > can make it work outside of everything else -- more of a sanity check. If > you can get that working then it's not the code you have for the grid, it's > likley code elsewhere in the page that's thwarting the sort. > > -Brock > DevelopMentor > http://staff.develop.com/ballen > > > Yep, I'm doing that. The OnSortCommand handler retrieves a dataset > > from a session variable (created when the page loaded), creates a > > dataview, then sorts on the SortExpression from the column clicked, > > assigns the DataSource and then rebinds the grid. Only it doesn't > > work. It acts like DataView.Sort doesn't work. I tried setting the > > intial sort expression to a different column when the page loads, that > > doesn't work either. > > > > "Brock Allen" wrote: > > > >> If you're using a DataGrid then you have to do the sorting yourself > >> in the Sort event and rebind the DataGrid. It doesn't sort by itself, > >> unfortunately. > >> > >> -Brock > >> DevelopMentor > >> http://staff.develop.com/ballen > >>> My web datagrid isn't sorting at all. I have it wired up to a > >>> handler, and I know the handler is working (being called), but no > >>> sorting. The page just posts back with the same data. I hhave > >>> verified that the SortExpression values are the column names. I > >>> used the VS IDE to create a datasource ( a DataSet), defined a table > >>> and columns, then used the datagrid Propery Builder to tie eveything > >>> together. The table gets populated with data correctly, I just > >>> can't get it to sort. > >>> > >>> Any help would be greatly appreciated. > >>> > >
Well, try it in the standalong page and if you can't get that to work send
me an email and I can give you a working sample. -Brock DevelopMentor http://staff.develop.com/ballen [quoted text, click to view] > I'd considered doing that, but what I do if it does work? What kinds > of things would prevent the sort from working? I've never tried using > the sort feature on a datagrid before so this is new territory. I've > used dataviews before, and implemented sorting, but I've never used > the datagrid component before like this. Could there be something in > the way the DataSource is defined in the page that affects the > sorting? > > "Brock Allen" wrote: > >> Hmm, not sure then. Sounds like you're doing all the right things. >> I'd suggest making a new project with one page with the one grid and >> try to see if you can make it work outside of everything else -- more >> of a sanity check. If you can get that working then it's not the code >> you have for the grid, it's likley code elsewhere in the page that's >> thwarting the sort. >> >> -Brock >> DevelopMentor >> http://staff.develop.com/ballen >>> Yep, I'm doing that. The OnSortCommand handler retrieves a dataset >>> from a session variable (created when the page loaded), creates a >>> dataview, then sorts on the SortExpression from the column clicked, >>> assigns the DataSource and then rebinds the grid. Only it doesn't >>> work. It acts like DataView.Sort doesn't work. I tried setting the >>> intial sort expression to a different column when the page loads, >>> that doesn't work either. >>> >>> "Brock Allen" wrote: >>> >>>> If you're using a DataGrid then you have to do the sorting yourself >>>> in the Sort event and rebind the DataGrid. It doesn't sort by >>>> itself, unfortunately. >>>> >>>> -Brock >>>> DevelopMentor >>>> http://staff.develop.com/ballen >>>>> My web datagrid isn't sorting at all. I have it wired up to a >>>>> handler, and I know the handler is working (being called), but no >>>>> sorting. The page just posts back with the same data. I hhave >>>>> verified that the SortExpression values are the column names. I >>>>> used the VS IDE to create a datasource ( a DataSet), defined a >>>>> table and columns, then used the datagrid Propery Builder to tie >>>>> eveything together. The table gets populated with data >>>>> correctly, I just can't get it to sort. >>>>> >>>>> Any help would be greatly appreciated. >>>>>
Well, I finally got the Sort to work. I built a test page in my project
using a sample I found in MSDN. That worked, so I compared the two and the only difference was my problem page was using a DataSet stored in a session variable and the example was using a DataTable. I changed my code around to use a DataTable instead and, voila! It sorted. Now my only question is, how do I get the column links to use my default style for navigation? I set the Class value (in the HeaderStyle property) to use the style in my Style Sheet but it appears to be ignoring it. I just get the default browser styles for <a> tags. Thx, Michael [quoted text, click to view] "Brock Allen" wrote:
> Well, try it in the standalong page and if you can't get that to work send > me an email and I can give you a working sample. > > -Brock > DevelopMentor > http://staff.develop.com/ballen > > > I'd considered doing that, but what I do if it does work? What kinds > > of things would prevent the sort from working? I've never tried using > > the sort feature on a datagrid before so this is new territory. I've > > used dataviews before, and implemented sorting, but I've never used > > the datagrid component before like this. Could there be something in > > the way the DataSource is defined in the page that affects the > > sorting? > > > > "Brock Allen" wrote: > > > >> Hmm, not sure then. Sounds like you're doing all the right things. > >> I'd suggest making a new project with one page with the one grid and > >> try to see if you can make it work outside of everything else -- more > >> of a sanity check. If you can get that working then it's not the code > >> you have for the grid, it's likley code elsewhere in the page that's > >> thwarting the sort. > >> > >> -Brock > >> DevelopMentor > >> http://staff.develop.com/ballen > >>> Yep, I'm doing that. The OnSortCommand handler retrieves a dataset > >>> from a session variable (created when the page loaded), creates a > >>> dataview, then sorts on the SortExpression from the column clicked, > >>> assigns the DataSource and then rebinds the grid. Only it doesn't > >>> work. It acts like DataView.Sort doesn't work. I tried setting the > >>> intial sort expression to a different column when the page loads, > >>> that doesn't work either. > >>> > >>> "Brock Allen" wrote: > >>> > >>>> If you're using a DataGrid then you have to do the sorting yourself > >>>> in the Sort event and rebind the DataGrid. It doesn't sort by > >>>> itself, unfortunately. > >>>> > >>>> -Brock > >>>> DevelopMentor > >>>> http://staff.develop.com/ballen > >>>>> My web datagrid isn't sorting at all. I have it wired up to a > >>>>> handler, and I know the handler is working (being called), but no > >>>>> sorting. The page just posts back with the same data. I hhave > >>>>> verified that the SortExpression values are the column names. I > >>>>> used the VS IDE to create a datasource ( a DataSet), defined a > >>>>> table and columns, then used the datagrid Propery Builder to tie > >>>>> eveything together. The table gets populated with data > >>>>> correctly, I just can't get it to sort. > >>>>> > >>>>> Any help would be greatly appreciated. > >>>>> > >
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
December 2007
January 2008
February 2008
March 2008
April 2008
May 2008
June 2008
| home · blog · groups | Questions? Comments? Contact the dn |