Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP .Net Datagrid Control > DataGrid Not Sorting

Reply
Thread Tools

DataGrid Not Sorting

 
 
Michael Caruso
Guest
Posts: n/a
 
      10-06-2005
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.
 
Reply With Quote
 
 
 
 
Brock Allen
Guest
Posts: n/a
 
      10-06-2005
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.
>



 
Reply With Quote
 
 
 
 
Michael Caruso
Guest
Posts: n/a
 
      10-07-2005
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.
> >

>
>
>

 
Reply With Quote
 
Brock Allen
Guest
Posts: n/a
 
      10-07-2005
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.
>>>



 
Reply With Quote
 
Michael Caruso
Guest
Posts: n/a
 
      10-07-2005
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.
> >>>

>
>
>

 
Reply With Quote
 
Brock Allen
Guest
Posts: n/a
 
      10-07-2005
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.
>>>>>



 
Reply With Quote
 
Michael Caruso
Guest
Posts: n/a
 
      10-12-2005
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

"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.
> >>>>>

>
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting list vs sorting vector boltar2003@boltar.world C++ 2 07-06-2010 09:40 AM
fired event Sorting which wasn't handled - sorting and SelectedIndexChanged Jason ASP .Net Web Controls 0 10-04-2006 02:19 PM
[Datagrid,web form]: How the get the correct row values after sorting datagrid by header AlainCD ASP .Net Datagrid Control 0 01-12-2006 09:07 AM
DataGrid within scrollbar/Header must not scroll/Sorting on asc and desc VSK ASP .Net 1 10-21-2003 04:14 PM
sorting by multiple criterias (sub-sorting) Tom Kirchner Perl Misc 3 10-11-2003 05:16 PM



Advertisments
 



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57