Forms Data Controls :: Start And End Points Overlap On Axis?
Jan 28, 2011
I have a chart with Y1, Y2 and X.X is date time.Issue is first and last point of the line chart is plotted on the Y1 and Y2 axis. They do not leave any space.I would like to leave some space before and after each series (some distance from Y1 and Y2).So instead of this,
I am currently using the new asp.net chart control.In this control i am not setting the maximum, minimum and the interval value because they are dynamic.ow once the graph is populated from database, the asp.net is only generating 4-5 points on the y -axis, i want it to show at least 10 values.But i am not sure how to increase the number of points on Y & X Axis.
I want to display time on Y axis and days on x axis.
I want to dispaly 12:00 AM,11:00 AM...11:59 PM. on Y axis.I want function to create sequence like that and on X axis display week like 6-sep,7-sep,..11-sep.
In the control Chart, I add few points, selected from the database:
var Diagram_1 = Razrez_D1.Series ["D1"]; sqlDA.SelectCommand.CommandType = CommandType.StoredProcedure; sqlDA.SelectCommand.CommandText = "Razrez_D1"; sqlDA.SelectCommand.Parameters ["@ date1"]. Value = Session ["date1"]. ToString (); sqlDA.SelectCommand.Parameters ["@ date2"]. Value = Session ["date2"]. ToString (); sqlDA.Fill (dataSet1, "Razrez_D1"); sqlDA.SelectCommand.CommandType = CommandType.Text; for (int i = 0; i <dataSet1.Razrez_D1.Rows.Count; i + +) ( string name_s = dataSet1.Razrez_D1 [i]. Name.ToString (); name_s = name_s.Substring (name_s.IndexOf ('â„–')). Trim (); Diagram_1.Points.AddXY (name_s, dataSet1.Razrez_D1 [i]. Count); Diagram_1.Points [i]. BorderColor = System.Drawing.Color.Black;; Diagram_1.Points [i]. BorderWidth = 1; if (Convert.ToInt32 (dataSet1.Razrez_D1 [i]. count)> 5) ( Diagram_1.Points [i]. Color = System.Drawing.Color.Red; ) else if (Convert.ToInt32 (dataSet1.Razrez_D1 [i]. count)> = 4 & & Convert.ToInt32 (dataSet1.Razrez_D1 [i]. count) <= 5) ( Diagram_1.Points [i]. Color = System.Drawing.Color.Yellow; ) else if (Convert.ToInt32 (dataSet1.Razrez_D1 [i]. count) <4) ( Diagram_1.Points [i]. Color = System.Drawing.Color.Green; ) )
The problem is that the points on the X axis are signed that way: first is not signed, second is signed, third is not signed etc How can I sigh all points?
My application work in this ways. I got a database collect data from 20 sensors. Database holds Temperature and DateTime data/Records from sensors. So i would like to make it whenever i view the chart, it will plot a line chart one by one according to the temperature and timestamp(DateTime). Which mean my X axis is a colleborate time on that particular date.I already design a in the way that the line chart will plot base on both dropdownlist, Sensor ID and Date. So it will work like whenever i select a Date or ID it will read the records from database table temperature.
so I have 3 series that are created from Cross Table Data Bind. Unfortunately some of the points are missing. Is there an algorithm I can use to cycle through the datapoints for each series and insert empty points to the correct spots so that my data is displayed correctly?
I am working with a chart control and on the Y axis i have numbers that fall between millions and billions.
The numbers on the axis themselves are not formatted and as such can be difficult to read. I wanted to know if there was a way for me to format the value that appears on the axis itself to be coma seperated?
here's what the Y axis looks like
600000000
300000000
100000000
numbers are just hard to read. How do i format them with coma's or even add a label saying (Millions) and then displaying only 100, 300, 600 etc
I have 2 series in the same chartarea. Both contain values by year (x axis). The problem is if one series does not have data for a given year, the chart will display the first value in a series on the first tick mark whether it matches the xaxis label or not.
Example:
[Code]....
Notice the 2009 value for series1 appears in the first column and the Xaxis now has 2 2009 tick marks. How do I get the values to appear on the correct X axis marks?
I am making a chart on a asp.net page (visual studio 2010). I am "summing" time. As long as the sum is not more than 24hours, all goes well. But if the sum is bigger than 24hours, then I get a "Not a legal Oleaut date" error.
This is my code (simplified) :
Chart1.DataBindCrossTable(_dataset._table.AsEnumerable(), "factor", "week", "time", ""); Chart1.Series[0].YValueType = ChartValueType.Time; duurhhmm is a DateTime field. "factor" and "week" are my groupings for the x-axis.
first question : what to do about the "not a legal oleaut date" ?
second question : on the axis I see 00:00,06:00, 12:00,18:00 and then again 00:00,06:00, etc... But I would like to have 24:00, 30:00.
I´ve got a chart control (column type) and must show many elements at y axis, but when system generates the chart draw, it´s shows only odd elements: For example: My chart must show a colunm containing systems (x) and error incidences (y):
I have a fairly basic line graph which is bound to a SQLDataSource control. The graph displays perfectly, but I want the labels on the X-axis to display vertically rather than horizontally.
I have used the following code to try and do this but it is having no effect:
I am trying to create a chart with three x-axis labels where the chart series x-value member is a date. That is, each data point is a day returned from a SQL Server table. The first label row is to be the day component, the second label row the month name component and the third label row the year. The returned dataset can be from any time period and of varying length. It needs to look like below so each day can be seen but the bigger picture is also shown.
x-axis label(0): 26 27 28 29 30 31 1 2 3 4 5 6
x-axis label(1): March April
x-axis label(2): 2010
I can set the first row using the design time properties as such
[Code]....
I am not sure how to create the next to custom labels at runtime. I have gone through the options using Add(Double, DateTimeIntervalType, Double, Double, String, Int32, LabelMarkStyle) and Add(Double, DateTimeIntervalType, String, Int32, LabelMarkStyle) but I just cannot get them to appear in the chart label.
I tried the other method [Code]....
however could not find how to set the DateTimeIntervalType on the CustomLabel object.
There was nothing in the ChartSamples and I am not even sure if it can be done.
There are dynamic values on x axis which can range from 1-100. I need to increase the size of X-Axis when the range is high, so as to display the data properly.
What is the right approach when users (authenticated domain admins) should be able to start batch jobs (usually exe files) from an IIS (7.x) aspx (c#) page? This is an intranet site. The batch jobs have to run on the web server as Domain Admins. The website pool is executed by network service or some similar restricted account in AD.
Approaches I can think of (and their disadvantages): 1. Start exe file with System.Diagnostics.Process.Start with another account. This feature is disabled in IIS 7.x, how do I allow it?
2. Create a sheduled task and call scheduled task-api. This unmanaged dll is giving VS compiler warnings because it's unsafe to call from managed code.
3. I suppose there's a better approach, because the previous suggestions doesn't appear safe or robust.
I am having some trouble with a panel that contains a table. The td's in the table contain labels separated by <br />. Pretty simple. It looks fine in the designer, but when I run it, the labels overlap each other and it looks like a mess. I only observed this problem after I moved from VS2003 to VS2005. Here is the code:
How do I remove the 'New' WebForm Page (Start Page), and go directly to the 'Insert' & 'Cancel' Web Form Page without selecting the 'New' hyper link at [URL] Here is the front page code:
I know that the datagrid control loops through a database table from the first row to the last, but I want it to loop from the last row to the first. How can I do that? Also I wanted to know how could I drop some rows according to my needs while looping from end to start, so that the datagrid only displays those rows that I need to display?
I get 2 dates and I should find if exist other data in this dates
The overleaping can be one of 5 options 1. Start before and ended after 2. Start before and ended between the dates 3. Start between and ended after 4. Start and end between the dates 5. Start and end like the dates
This query should be very very Effective and run the quicker that possible