Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
UI for denormalized timesheet entry
Message
From
13/09/2004 23:59:04
 
General information
Forum:
ASP.NET
Category:
Other
Miscellaneous
Thread ID:
00941744
Message ID:
00941783
Views:
23
Hi, Danny-

>
>Assuming you're using SQL as the data backend you may could do something like the following (also assuming you're using a data grid component) ...

It's a Fox back end, which I should have mentioned.

So, for displaying data, I'll select from my data, and then populate my denormalized datatable with the data I select in a straightfoward way. At least, that's been my thinking.

I guess the datagrid with gawdawful number of columns is my best route.

Processing in and out of the denormalized structure will be a bother, but that doesn't worry. I'm a little concerned with the quality of the user experience, though, since I've come to learn just how new to computers some of my audience is.

>I used the below table structure for my demo:

Thank you, though for this example. I'm just starting to use SQL Server for another client, and so have a lot to learn, and I know that this will be very helpful example. Thanks.

>Next, in order to get the task totals per row, you could use the code behind / ItemDataBound event of the grid... Summing each "Day" column to derive the value of the total column, per row.

Does this require a round trip to the server, though? I'd considered simply having a button to update the row and column totals so the user doesn't have to be bother with a round-trip every time they make an entry.

>Finally, for the "Daily Hour Total" footer I would reccomend a seperate routine to loop through the data object (DataSet, DataTable, Etc..) and append totals to an array with 32 elements (31 Days and 1 Total). Once you have looped through every record, use the totals in the array to populate the footer.

Yes, that's a good idea.

>I figure if nothing else, maybe a place to start : )

I appreciate the brainstorming help.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform