Web Forms :: Put 4 Category On Axis X Of LineChart
May 7, 2015
I would like to put 4 categories (fixed) on my chart (example: 1,2,3,4 quarter on the x-axis) and display data from the database in the right category.
// AVG correspond à moyenne et on multiplie par 100 puisque à la base la colonne est de type Decimal
string query = string.Format("select Entite, AVG(AvancementQuantitatifT1 * 100) FROM reponse WHERE ObjectifStrategique = '{0}' GROUP BY Entite", Objectif_strategique.SelectedItem.Value);
[Code].....Â
For example I want to do something like that :
select Progressquarter1, Progressquarter2,Progressquarter3, Progressquarter4 and put respectively in quarter 1 quarter 2 quarter 3 and quarter 4.
View 1 Replies
Similar Messages:
May 7, 2015
I would like to change the text of my X axis.
Look the below picture :
View 1 Replies
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
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
Mar 30, 2011
I am working in a project that is a musical website. I want to display the web page with all categories I have. In my database , named Category_Master, I have two fields like Category_Id (which is a primary key ) and Category_Name. I have generated category_Id with NEWID() function. The category_Id is not supposed to display on the web page. But, i have to select Category_Name and according to that , I have to get the category_Id. If I am using Static connection with SqlDataSource, i am able to make visible=false property so that the category_id won't be visible. But , at that time, I can't write code to Select the category_id of the selected index.
If i am using disconnected approach, I filled the dataset with the Category_Master, and binded it to GridView. But, at that time, I can't hide the category_id from the user. I want to select category_id by clicking on the category_name with out displaying category_id ..?
View 4 Replies
Nov 5, 2010
i create example using Northwind database so i create a new website and add new ADO.Net Entity Data Model (.edmx) called Northwind.edmx and i add Categories and Products table inside this (.edmx) file
and add new ADO.Net Data Servuce called "ADODataService" and add it as WebReferences called NorthwindService
so i add new web page and drag DropdownList and Gridview as i want to bind Dropdownlist to all categories and when i select category from Dropdownlist bind Gridview to all Products related to this category
so my code
[Code]....
and my code
[Code]....
so when i select category from Dropdownlist nothing happen :(
also you will find commented code in method BindCategory whuch is not work also.
View 1 Replies
Feb 7, 2010
I'll try to explain as simple as I can in text what my problem is. I don't see any other way to make my issue clear.
I have a GridView that uses an ObjectDataSource.
The ObjectDataSource has an DataObjectTypeName defined, so I pass/get complete objects or list of objects to/from the data access methods.
The objects I'm working with, let's say we work with Book objects, contain a Title and a Category, BUT the Category is an object itself. When the Select method is called, we get a List of Book objects, which is perfectly displayed, overridden ToString method in the Category objects within the Book objects.
The problem I face is that I can't find a way to update the category in my GridView. What I did already accomplish is:I used a template field in the GridView for the Category so I could use a DropDownList for that field in Edit mode.
I bound the DropDownList to another ObjectDataSource that gives me a list of CategoryObjects.
So when I enter Edit mode... the row shows a nice ddl with the available categories. It even selects the right original category.
So far so good... but when I want to save my new selection, I get an error that a string (the selected category in the ddl) cannot be converted to a Category object (that's what the Book object, that is going to be used for the update, expects).
View 5 Replies
Jul 26, 2010
I am trying to put different tooltips in my MS chart (No in the points) I want these tooltips in my values in axis and I cannot do it.
View 3 Replies
May 7, 2015
I am using asp chart (framework 4.0) in one of the web page.
Chart displays x and y points from database.I want to fix the scaling of only Y-axis i.e., between 1 to -1as y axis point will lie within 1 to -1, as below:
10.750.500.250Â Â Â Â Â ------------------------------------------------0.25-0.50-0.75-1
C# code:
Chart1.Visible = true;
string id = Request.QueryString[1].ToString();
string query = "SELECT x,y from Table where ID= '" + id + "' and DeletionDate is null";
DataTable dt = GetData(query);
string[] x = new string[dt.Rows.Count];
double[] y = new double[dt.Rows.Count];
[Code].....
View 1 Replies
Jan 1, 2013
I want to display the multiline chart for comparing two or more employee attendance in asp.net ... I am trying but I didn't get exact solution ....
View 1 Replies
Aug 19, 2010
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.
View 9 Replies
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
Jan 11, 2011
we are currently running a website in which the home page has recent tab section which contains list of category list i need to block a category.
View 1 Replies
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
Sep 17, 2010
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?
View 4 Replies
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
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
i
x
i
I would like to have
i
i
i x
i
View 3 Replies
Jan 19, 2010
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.
View 2 Replies
Jun 3, 2010
I'm databinding the checkbox list to a db table which has a category assigned for multiple records. I can list the checkbox but I can't sort them by category using the checkbox list control. Can somebody post an example on how to achieve this? Category 1chk Record 1 chk Record 2 chk Record 3Category 2chk record 4 chk record 5 Etc
View 3 Replies
Jan 25, 2013
I want to make Image Gallery for products By Category
for example clothes, books,...
I want doing it with the two links
Image-Gallery-using-ASP.Net-DataList-Control-Part-I
Image-Gallery-using-ASP.Net-DataList-Control-Part-II
without Category it works fine
but I changed this lineÂ
FROM tbl_product ) AS tbl WHERE Row >= '
to
FROM tbl_product ) AS tbl WHERE cat_id=@cat_id Row >= '
andI added
[Code]....
and now I face this messageProcedure or function spx_Pager has too many arguments specified.
View 1 Replies
Nov 17, 2010
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):
1. SIEMP
2. SISOUT
3. SIGTI
4. SISFIN
5. SISPL
6. SISTER
But it´s only shows:
1. SIEMP
2.
3. SIGTI
4.
5. SISPL
6.
I must set a parameter that forces "all" series to be showed.
View 2 Replies
Sep 9, 2010
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:
<AxisX Title="Patient Safety Submissions" IsLabelAutoFit="True">
<LabelStyle Angle="90" interval="1" />
</AxisX>
[code]....
View 2 Replies
Feb 17, 2011
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.
View 1 Replies
Apr 26, 2010
I'm working on a dynamic table of contents (toc). The toc is generated from data in a sql database. There are 5 sections in the toc and within each of the five sections, there are a varied number of rows. (Section 1 may have 5 rows, while Section 2 has 12 rows). To help differentiate between the sections, I'd like the ability to add some type of grouping in my gridview. So, it would look like below. Do I just add a different gridview for each section, or is there a way to "categorize" the gridview to break up the data with a Section 1 Category
a
b
c
d
e
Section 2 Category
a
b
c
d
e
f
g
h
i....
View 3 Replies
Apr 14, 2014
i want to develop image album on my website
1 upload photo category wise
2 view photo category wise
View 1 Replies
