Solved

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

Posted on 2007-04-11
5
796 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Turn Insights into Action

Communication across every corner of your business is essential to increase the velocity of your application delivery and support pipeline. Automate, standardize, and contextualize your communication processes with xMatters.

Question has a verified solution.

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

Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

691 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