Solved

display rolling 12 month data in gridview

Posted on 2010-08-16
3
383 Views
Last Modified: 2012-08-13
I am trying to replace an Excel spreadsheet and need to display rolling 12 month data with a gridview.  Here is some sample data.

tblProject                        
fldProjID,fldRegistration,fldStartDate,fldEndDate,fldHours
1,111ABC,25/07/2010,02/08/2010,16000
2,222ABC,09/08/2010,10/09/2010,24000
3,333ABC,02/09/2010,20/09/2010,24000
4,444ABC,20/10/2010,05/11/2010,32000

tblHours                        
fldHoursID,fldProjID,fldDate,fldHours      
1,1,01/07/2010,12000      
2,1,01/08/2010,4000      
3,2,01/08/2010,15750      
4,2,01/09/2010,8250      
5,3,01/09/2010,24000      
6,4,01/10/2010,22000      
7,4,01/11/2010,10000

I have attached a screenshot of how I would like the gridview to appear.  I have given two views and you can see how the months have rolled.

How do I get a gridview to show data in this manner?
screenshot.png
0
Comment
Question by:iepaul
  • 2
3 Comments
 
LVL 14

Accepted Solution

by:
robasta earned 500 total points
ID: 33444741
you can use datatables. Load your data (from the 2 database tables) into 2 datatables. Process each of the Registrations (tblProject records) to generate a 3rd datatable which you will then display to the user.
0
 

Author Comment

by:iepaul
ID: 33444777
Will I be able to edit the data when displayed like this?
0
 
LVL 14

Expert Comment

by:robasta
ID: 33444881
Yes. With this approach, you would need to manually handle edits. I.E. when there is an edit, process it to map the data to the correct table.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question