469,128 Members | 1,486 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,128 developers. It's quick & easy.

Data Grid Sort Problem

Hi all,

I hope someone can help with this relatively simple problem.
I am building a timesheet application using ASP.NET C# with Visual
Studio 2003.As it is only a protoype application, my database has been
made in MSDE.

I've searched all over the web for the answer to this, but can't quite
work it
out. Basically, I am showing all Timesheet Entries in a DataGrid, by
applying a DataView to a DataSet. This works fine, and now I need to
sort the entries. I want my sort order to be done by ResourceID, Day.
The problem is that my Database has the days of the week stored as a
string (i.e. each entry will be for one of of the following
'Mon','Tues','Weds', 'Thurs', 'Fri', 'Sat', 'Sun')

The problem when sorting is that if I sort by 'Day', because it's a
string it will do it alphabetically. Obviously this is wrong, I want
it to sort it in the order of the days of the week as shown above. How
would I go about achieving this? I thought about assigning values to
each day when adding to the database (this is done by a drop-down list
so Monday could =1, Tuesday =2, Weds = 3 etc). However when I then pull
the data into the DataGrid, it will be stored as numbers, not Days.

Does anyone have any suggestions as to how I could solve this? To
re-iterate, I have a column called 'Day' which will contains one of the
7 days of the week, and I wish to sort rows in 'Day' logical order.

Thanks in advance

Al

Apr 9 '06 #1
1 1264
Do you also have a date associated with the day, if so use this to sort on,
else you could add an additional column to the bound DataTable which stored
an integer representing the day, hide this in the datagrid, but use it to
sort on.

--
( OHM ) - One Handed Man
AKA Terry Burns - http://TrainingOn.net

"thebison" <al************@btinternet.com> wrote in
message news:11*********************@j33g2000cwa.googlegro ups.com...
Hi all,

I hope someone can help with this relatively simple problem.
I am building a timesheet application using ASP.NET C# with Visual
Studio 2003.As it is only a protoype application, my database has been
made in MSDE.

I've searched all over the web for the answer to this, but can't quite
work it
out. Basically, I am showing all Timesheet Entries in a DataGrid, by
applying a DataView to a DataSet. This works fine, and now I need to
sort the entries. I want my sort order to be done by ResourceID, Day.
The problem is that my Database has the days of the week stored as a
string (i.e. each entry will be for one of of the following
'Mon','Tues','Weds', 'Thurs', 'Fri', 'Sat', 'Sun')

The problem when sorting is that if I sort by 'Day', because it's a
string it will do it alphabetically. Obviously this is wrong, I want
it to sort it in the order of the days of the week as shown above. How
would I go about achieving this? I thought about assigning values to
each day when adding to the database (this is done by a drop-down list
so Monday could =1, Tuesday =2, Weds = 3 etc). However when I then pull
the data into the DataGrid, it will be stored as numbers, not Days.

Does anyone have any suggestions as to how I could solve this? To
re-iterate, I have a column called 'Day' which will contains one of the
7 days of the week, and I wish to sort rows in 'Day' logical order.

Thanks in advance

Al

Apr 10 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Amy Snyder | last post: by
5 posts views Thread by pmud | last post: by
12 posts views Thread by pmud | last post: by
1 post views Thread by Da-Breegster | last post: by
1 post views Thread by Matthew Louden | last post: by
reply views Thread by Amy Snyder | last post: by
1 post views Thread by Linda | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.