Solved

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

Posted on 2007-04-11
5
794 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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

861 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