Solved

ASP .NET C# Show Only Hourly DateTime values from an Array of 24 hour values.

Posted on 2007-04-11
5
791 Views
Last Modified: 2010-07-27
Someone tried to answer this question yesterday but that solution did not work. I am reposting it. Looks like no one has a solution to my question (even in other forums outside of EExchange). So here we go again. The output of the response.write can be seen in:
http://www.cameradisplay.com/CondorStats/tempdisplaytime.htm

These are 360 different time values, spanning 24 hours, separated from each other by 4 minutes. How can I just show these values in separated by Hourly spans while the intermediate values simply get replaced by blank space (the chart's X-Axis cannot accomodate all 360 values).

 DateTime startTime = Convert.ToDateTime(dayArray[0]);
                DateTime endTime = Convert.ToDateTime(dayArray[dayArray.Length - 2]);
                TimeSpan timeSpan = (endTime - startTime);
                //Response.Write(startTime.ToString() + " " + endTime.ToString() + " " + timeSpan.ToString());
                for (int i = 0; i < dayArray.Length - 2; i++)//loop to one less because of extra comma/space at end
                {
                    DateTime currentTime = Convert.ToDateTime(dayArray[i]);
                    Response.Write(currentTime.ToString() + "<br>");

                }
0
Comment
Question by:irfantak
  • 3
  • 2
5 Comments
 
LVL 23

Accepted Solution

by:
Jens Fiederer earned 500 total points
ID: 18892965
Since they are separated by 4 minutes, you should (I am not quite clear on what you want) either
only do a Response.Write every 15 values (for example, if
(i % 15) == 0
) or do either a Response.Write with the time string or a Response.Write of a blank space depending on whether
(i % 15) == 0
(or some such value).
0
 

Author Comment

by:irfantak
ID: 18893088
Thanks.
Here is what I am trying to do: Replicate the following chart and the code above builds the X-Axis of the chart: http://central.condor.clemson.edu/public/condor-stats/Hour.html

Basically, there are 360 data values which cannot fit on X-axis and so I only need to show values which are 1+ hours apart on X-axis.
But the X-axis does need to have some filler/empty data so that the x-axis can build (corresponding to y-axis values) except that the display data on x-axis will be a few date/time values.

Makes sense?
Thanks.
0
 

Author Comment

by:irfantak
ID: 18893194
Hey, your solution was so simple but I have made good progress. Will be back! Thanks!
0
 

Author Comment

by:irfantak
ID: 18893220
Yes, it works. Thanks! Now I have to figure out data for 'Weekly' and 'Monthly' charts...But that is for another time.
0
 
LVL 23

Expert Comment

by:Jens Fiederer
ID: 18893398
If the concept is the same, but the constant is different your life will be easy!
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

707 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now