Last post Mar 06, 2008 01:01 AM by NoBullMan
Nov 08, 2007 05:24 PM|NoBullMan|LINK
a couple of questions:
Even though the stored procedure for getting list of projects and categories orders them project name and category name (actually, category id, but I changed it to category name), the drop downs don't list them as ordered. How can I fix this?
In the time entry page, how can I display the total hours at the bottom?
Nov 11, 2007 10:32 PM|chetan.sarode|LINK
You have to modify the SP by Order clause
For displying total hour at the bottom you have to do manually code
Nov 13, 2007 01:49 PM|NoBullMan|LINK
Thanks for the reply.
The sp does, supposedly, order by name but it does not show up as ordered. That's what was confusing to me. I managed to order the projects by name but the categories still show up as unordered.
Also, I know that the total has to be done manually, I just need some pointers as how to go about doing it.
Nov 21, 2007 10:22 PM|chetan.sarode|LINK
Use Group By clause
Nov 27, 2007 11:29 AM|NoBullMan|LINK
Thanks Chetan, it solved the ordering problem. Any idea on how to add a totals row to the bottom of the time sheet grid?
Nov 28, 2007 10:31 PM|chetan.sarode|LINK
If my answer solved your problem the Mark it as answer
So it will help for other people
For adding total rows you can use GridView.Rows.Count It will return total No. of rows
Nov 30, 2007 08:58 AM|NoBullMan|LINK
Your reply solved the first part but the second part is still unanswered; that's why I haven't marked it yet.
By "Total" I meant a row at the bottom of the gridview that would display the totals of values in the columns, not the total number of rows. So, if a column is displaying hours worked, at the bottom I need to be able to display the total number of hours
worked. Same for other columns.
Nov 30, 2007 05:25 PM|NoBullMan|LINK
I had to enable footer row in the gridview that displays the time sheet and handle the showing of total, in the footer row, through RowDataBound event.
Thnaks for the help.
Dec 02, 2007 10:29 PM|chetan.sarode|LINK
Here is your solution
Dec 03, 2007 10:27 PM|chetan.sarode|LINK
I have provided you a link.
Tell me if this useful to you
Dec 04, 2007 08:27 PM|NoBullMan|LINK
Thanks for the info Chetan. I already solved it (i mentioned it in the reply previously) but thanks for the info again. I am sure it will come in handy.
However, the link you provided showed as Page Not Found. I found another link, hopefully this is what you meant.
(Already marked your answer as "the answer")
Dec 04, 2007 10:33 PM|chetan.sarode|LINK
Mar 03, 2008 02:18 PM|ewallig|LINK
Trying to do something similar with time - can you show your code on how came to the total amount of time?
Mar 06, 2008 01:01 AM|NoBullMan|LINK
Hope this helps.