• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 802
  • Last Modified:

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

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
irfantak
Asked:
irfantak
  • 3
  • 2
1 Solution
 
Jens FiedererCommented:
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
 
irfantakAuthor Commented:
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
 
irfantakAuthor Commented:
Hey, your solution was so simple but I have made good progress. Will be back! Thanks!
0
 
irfantakAuthor Commented:
Yes, it works. Thanks! Now I have to figure out data for 'Weekly' and 'Monthly' charts...But that is for another time.
0
 
Jens FiedererCommented:
If the concept is the same, but the constant is different your life will be easy!
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now