AJAX :: How To Set X-axis Min And Max Value From Database Table In MSChart Control

May 7, 2015

Suppose if DB table has x-axis values as below for particular Id: 65    67.5 68.5  70.0 78.5 80.0   81.5 82.5  83.0  83.5  84.0  84.5  85.5  86.5 

Then it should select x-axis Min value as 65 (for that particular Id), in below line: //Chart1.ChartAreas["ChartArea1"].AxisX.Minimum and it should select x-axis Max value as 86.5 (for that particular Id, in below line: //Chart1.ChartAreas["ChartArea1"].AxisX.Maximum.These values differ everytime for different Id. ( particular Id has multiple x-So everytime for particular Id, it should take x-axis Min and Max value from Database.I tried below code, but its not working. (Also this code enables MajorGrid = true dont know how. I had set it Enable = false from code behind.)

string query = "SELECT max(x) from Tables where Param_ID= '" + id + "' and DeletionDate is null";
DataTable dt2 = GetData(query);
Chart1.ChartAreas["ChartArea1"].AxisX.Maximum = Convert.ToDouble(dt2);

View 1 Replies


Similar Messages:

VS 2008 - MSChart Using DateTime On X Axis?

Mar 29, 2010

I have installed the asp.net MSChart control for VS2008 and set up a chart on my webform. I am using DataBindTable in code to bind data from a LINQ query. The data for the x axis looks something like this:

Date/Time
15/03/2010 08:00:00
15/03/2010 14:00:00
15/03/2010 20:00:00
16/03/2010 08:00:00
16/03/2010 14:00:00
etc

When the chart displays the X axis only displays multiple dates, and not times, no matter what properties I try to change.

View 2 Replies

VS 2010 Mschart Axis Minimum Or Maximum?

Oct 18, 2010

I have an mschart control which is databound in code-behind. The Y axis values can vary from vary small to very broad. So the range is set to auto. This works fine except when the values in range of 0 and <1.
In this range the axis only has a zero, it does not have a "1" at top. Is it possible to set to dynamically set the maximum? So if the maximum value is less than one, still show a one.
i.e. get maximum value and set the Y axis maximum = maximum value +1

View 5 Replies

VS 2010 - Sort X Axis On MSChart With Multiple Series

Oct 28, 2013

I have an MsChart with 6 series. The data is retrieved from MySQL database and every series has different number of elements.

The X axis is represented by date values (YYYY-MM). I am sorting data ASC on date from MySQL query but when i generate the chart i have the values (from left to right) : 2010-01 , 2011-04, 2013-04, 2011-04,2012-04.

I tried sorting data like this , for every series:

Code:
Chart1.Series(0).Sort(PointSortOrder.Ascending, "X")

But still no effect. How can i sort data on X axis?

View 4 Replies

AJAX :: Line Chart Control - Display All Values On X Axis

Mar 6, 2013

I work with a tank of visual studio when I click to display the graph he shows not all points on the X axis

for example the table nbr_num_semaine_av contains values in order

(18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,1,2,3,4)

but the graph shows on the X axis only that 18, 38, 41

for (int k = 0; k < semaine.Count(); k++) {
Chart4.Series["Nombre de points terminés"].Points.AddXY(nbr_num_semaine_av[k], nbr_points_Termin[k]);
Chart4.Series["Nombre Total d'element"].Points.AddXY(nbr_num_semaine_av[k], nbr_element.Count());
}
Chart4.Series["Nombre de points terminés"].ChartType = SeriesChartType.Line;
Chart4.Series["Nombre Total d'element"].ChartType = SeriesChartType.Line;
Chart4.Series["Nombre de points terminés"].IsXValueIndexed = true;
Chart4.Visible = true;

View 1 Replies

AJAX :: Control Toolkit Line Chart Reverse Y Axis

Feb 1, 2014

I am currently making a line chart of Ajax control toolkit referring to an article [URL] .....

It works fines as described. My question is how to reverse Y axis of the line chart. 

I need to place 1 (not 0) at the top of Y axis and biggest number near the bottom with some margin from axis X. The described chart is biggest number neat the top and 0 at the bottom. 

View 1 Replies

Forms Data Controls :: Chart - Display X Axis And Y Axis Values As Sum?

Mar 30, 2011

Iam having simple chart.

Which is displaying X and Y values.

Iam using SqlDataSource control to Bind data from database.

Now, How to display Sum of X values on top of chart ?

View 1 Replies

Web Forms :: Display Time On Y Axis And Days On X Axis?

Sep 6, 2010

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.

View 6 Replies

Display TimeSeries / Use The MSChart Control?

Dec 23, 2010

How can I display a TimeSeries?Is it possible to use the MSChart Control (Asp.net Charting Control)?

View 3 Replies

Forms Data Controls :: MSChart Control Doesnt Work On .net?

Dec 15, 2010

I would like to install my asp .net site on a free host. what do I need to install in order that the mschart control will work on the host.

what are the basic requirements.

at the moment I get an error about it.

View 2 Replies

Forms Data Controls :: Able To Align Y-labels At Chart If Using MSchart Control?

Jan 12, 2011

I am wondering if I am able to align y-labels at chart if I am using MSchart control. I searched at google, but I got feeling it is not possible to align them, just title of y-axis.

Here snip of the chart if my question is not clear enough: [URL]

View 2 Replies

C# - How To Turn Off The X-axis Labels In A Chart Control

Jan 31, 2011

I want to programmatically turn on/off the labels on an Chart Control.

The chart is for a load of stats, by person, and I want to be able to anonymise it by removing the labels.

Can this be done from the Chart Control, or do I need to do it at the underlying data-table?

View 1 Replies

C# - .NET Chart Control - Dynamically Change Y-axis Interval?

Feb 10, 2011

I have a bar graph displaying a number of different series (stacked on each other) and I'm trying to find a way to dynamically change the y-axis interval if the values go above a set value.

If the bars only go up to a maximum of 50, I'd like the interval to be 25 so the bars still 'look' rather small. But if a large spike comes through, the interval needs to be set to 0 so the large spike is more noticeable.

View 1 Replies

VS2010 Chart Control: Reducing Y-Axis Margin?

Nov 1, 2010

How do I reduce the width of the left margin area shown below, marked in red?

View 1 Replies

Web Forms :: Axis Values Not Getting Displayed In Chart Control

May 10, 2012

I am using asp.net charts in my application, i have given the axis values from code behind. I added the on page load but the problem when i go directly to that page the graph will not appear but if i reload the same page it will appeare. this happens when i publish the application and try on IIS, but there is no problem before publish (while run in VS).

View 1 Replies

AJAX :: Change Text Of AXIS X Labels Of LineChart?

May 7, 2015

I would like to change the text of my X axis.

Look the below picture :

View 1 Replies

Forms Data Controls :: Formatting Axis Of A Chart Control?

Jun 29, 2010

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

View 5 Replies

Forms Data Controls :: Ms Chart Control Zoom In On Axis?

Aug 11, 2010

I have a .net3.5 mschart control bound to a data table displaying a line graph. I wigh to zoom in on an axis on an asp.net web form.

View 1 Replies

Visual Studio 2010 Chart Control: Make Y Axis An Integer Value, Not Decimal?

Nov 1, 2010

I like the way that the chart control seems to automatically determine the X axis range for me based on the data, but in this case, the data can only be whole numbers.

What is the easiest way to specify whole numbers for this axis?

View 2 Replies

SQL Server :: How To Connect SQL Database To Table Control

Feb 11, 2011

how i can connect sql database to table control?

View 1 Replies

AJAX :: Upload File To Database Table Using AsyncFileUpload ?

Sep 23, 2010

can i upload my pdf or word file to oracle/SqlServer database table ?

View 4 Replies

Display Total Count Of Records In Database Table In Label Control?

Apr 17, 2013

I want to display no. of rows a table contain from database on label, how can i do that..

View 1 Replies

Forms Data Controls :: How To Freeze The X Axis Of The Chart Control In Ms Chart

Feb 24, 2010

how to freeze the x axis of the chart control in ms chart? need to use because data displayed at large amount that is scrollable.

View 1 Replies

Web Forms :: Passing CurrentUser.UserId With File Upload Control To Database Table?

Feb 18, 2010

implementing an file upload control that uploads the binary data to the database table and associates it with the correct user/the current user who uploaded the data.

View 8 Replies

AJAX :: Save Multiple Files File Path In Database Table

May 7, 2015

I want to save three images path  in table also upload images in folder,how it is possible?[Using ajax file upload control]table columns are imagepath1,imagepath2,imagepath3. URL....

HTML
<asp:AjaxFileUpload ID="AjaxFileUpload1" runat="server" AllowedFileTypes="jpg,jpeg,png,gif"
MaximumNumberOfFiles="3" OnUploadComplete="File_Upload"
Width="500px" />
 C#
protected void File_Upload(object sender, AjaxFileUploadEventArgs e)

[code]....

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved