i need to display a chart according to the table stored in the database,i have installed mschart,when i choose datasource it is working properly? can anybody give me the details how to put a chart?
View 1 Replies
I am building a .net page and need to display some data residing in a database. Some of it's working, some not. I would like to use a table to display the data with the format below..
Table
row - question data
row - answer (count)
row - next answer (count)
row - BarChart representing the answer counts for question
row - next question data
row - answer (count)
row - next answer (count)
row - BarChart representing the answer counts for question
The question data and answer count rows are generated with no issue. However, the rows containing the barchart are problematic. Not sure how to create a new instance of a chart on the fly and hook in all the methods, etc. and get the control added to and displayed in the tablecell. Been looking for examples to create the chart on the fly with no real results.
I am stuck in chart controls...Here is my prob... There is a ListBox containing some items...when user selects multiple items from the list box I want to generate a dynamic table with the number of columns same as that of the number items selected in the listbox. And for each selected item I want to show a seperate chart in the columns...Currently I want the same chart control for every selected item (i.e. a static hard coded chart that i will replace later by dynamic values)....I am using a method that draws a chart control using a sample dataset... I am calling it each time when a new column is created..Also the DrawChart method executes for the first column only and throws an index out of range exception! after the first execution...my code is not working...here
my code...
[Code]....
[Code]....
I have an issue in using dot net chart control. In chart last column is not completely shown which give bad appearance and on right side of chart it looks like TickMark are enabled. I set MajorTickMark of AxisY2 disabled but still tick marks on right side.
View 2 Replieshow 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 RepliesI have a drop downlist,and next to it there is an MS bar chart.i want to change the datate of the MS chart ,once the user selects another year from the dropdownlist.
When the page loads ,the chart displays the default year(2011) and it works.The problem is that is does not change the data when you select another year from the dropdownlist.
Am I going mad/blind? Probably a combination of the two.
How does one go about removing the data labels from a pie chart with the new chart control in .net 4?
I can get these to display as tooltips absolutely fine, but ultiamtely I'd like the labels not to be present as it looks rather busy.
I've searched previous answers and seen code behind resolutions but surely there must be some sort of code infront option to turn these labels off?
I am using MS Chart control (3.5), and have a requirement where I need to display 2 pie charts. The datapoints for the pie charts is set programatically. My doubts are as follows:
1. Can I display both the pie charts in a single chart control and area, or do I have to use two controls? (Currently I am using two controls)
2. How can I maintain the same size for both the pie charts? This is my main concern, since the pie sizes keep changing, depending on the number of datapoints. I tried using custom properties like "MinimumRelativePieSize", but it's not working.
i'm trying to create a stacked bar chart on a vb web form using vs2010.My data source returns:
Error in Functionality Awaiting on Supplier
1IMT IssuesmActive6
IMT Issues,Awaiting on Supplier
2,IMT Issues,Awaiting on User 4
IMT Issues Closed 120
Login / Password Active
But I can't get this into a stacked chart. I know I must have to do quite a bit of work declaring what the series are and soforth, or having a different dataset but can't find any documentation on it.A link to some documentation or an example of a stacked chart from an sql datasource would be much appreciated.
I started using the awesome chart controls with my asp.net apps recently and so far they've been nothing short of breath taking. Right now I have a weird problem, on the first load of my page, the chart control appears correctly and the tooltip is correct, however, when I update it with new data, the chart displays correctly, but the tooltips are for the previous set of data.
I hope this makes sense. The first time I load the chart, the pie chart segments and tooltips are correct, after a partial postback (to get the new data), the pie chart segments are correct but the tooltips are for the previous data set.
Basically once the tooltips are set the first time, they can't be updated after that without a full page postback.
Here's how I set the tooltip:
[Code]....
Anyone else noticed this behaviour and have a work around?
Currently my only workaround is to check for a partial postback and not render the tooltip, which I'd rather not do as the tooltip display actual statistical data as opposed to the pie itself (which uses percentages).
I'm trying to build a chart in my application which will act as a client for an ASP.NET 3.5 web service that I created. The error I get is as follows:
Series data points do not support values of type System.Data.DataViewManagerListItemTypeDescriptor only values of these types can be used: Double, Decimal, Single, int, long, uint, ulong, String, DateTime, short, ushort.
I've tried various ways to resolve this but can't. This error points at the
chtStats.DataBind() line in the code below:
[Code]....
[Code]....
[Code]....
[Code]....
[Code]....
[Code]....
[Code]....
[Code]....
[Code]....
[Code]....
[Code]....
I am using Chart control to loop through and fill from GridView and it works fine.
Code:
myProductSeries.Points.AddXY(GridView1.HeaderRow.Cells(i).Text.ToString, GridView1.Rows(0).Cells(i).Text.ToString)
My question: How would I do that using a DataTable instead, is that possible. Does DataTable have a "Header" like GridView so do I fill the X value?
in converting gridview data to chart control,i am using asp.net 3.5 and vb.net.
View 1 RepliesIn my web forms application I have a site.master page with an update panel (Java Script ToolKit). Inside the update panel I have a survey and a columns chart to show its results. The chart properties are
visible = false
ImageStorageMode = UseImageLocation
RenderType = ImageTag
When the user votes, his/her vote is stored in a sql server table The chart is rebound to its data source
The chart visibility is set to true and the survey's questions are hidden. I've been trying to set the columns for the maximum and minimum values to a different color using the code I found in "Samples Environment for Microsoft Chart Controls" [URL] under Working with Chart Data Data Manipulation Finding Data Points Find Maximum and Minimum Values:
[Code]....
I have not got the columns to change their color. I have put the code inside every event handler I could think of (after it failed to work inside the page load event handler): Inside the chart Init, load, and pre_render handlers. Inside the click event handler for the voting button (before and after I call the chart.DataBind() method). Inside the page pre_render handler. Inside the ToolKitScriptManager pre_render handler. I checked the code behind the environment samples. All, to no avail.
I have a database with several data in. I want to select a data in database with dropdownlist. When you select the value in ddl, the selected data should come to chart.... My example;
- Database: ProblemDescription,
- My Tables: ID, Name, Department, Problems, Description, Date, Hour
I show the items of Department in dropdowlist, what I want is; when you choose a department you must see the Problems in Xaxis and I count the items in Yaxis. My query; SELECT Department, Problems, COUNT(*) AS totalProblems FROM tblProblemDescription GROUP BY Department, ProblemsDoes anyone show me a way how to solve this problem with databinding in Chart.
What is the name of chart
View 6 Replieshow can get the date value in my chart and proceses on it
View 3 RepliesI am new to asp.net. I am suppose to continue a project. The previous person has created a line chart and I have to create a bar chart. However I do not know how to create a bar chart. Could u email me for the code as I realise that I can't upload the files.
View 5 RepliesI need to create the following stacked bar chart using the MS Chart control:
[IMG]http://i54.tinypic.com/2d1ti05.jpg[/IMG]
My table structure is as follows:
PEStaffAssessmentID int
PESubmissionID int
Q1_ConfidentDelivering int
Q2_ProfessionalAttitudes int
Q3_LeadershipEffective int
Q4_SupportedByPeers int
Q5_AssistedInexperienced int
Q6_ConfidentKnowing int
Q7_AbleToTalk int
Q8_CommunicationEffective int
Q9_ConfidentSupporting int
Q10_TeamShares int
Q11_CareDeliveredSafely int
Q12_MinimumMaintained int
Q13_MeetOwnExpectations int
Q14_SpendEnoughTime int
Q15_ProvidePhysicalCare int
Q16_ProvideEmotionalCare int
Q17_SpiritualCare int
Q18_ProvideCare int
Q19_ManageWorkload int
Q20_HighestStandardCare int
Q21_MoraleLevel int
Q22_RateCareReceived int
So each column in my datasource need to represented by a row in the graph. and the contents of the stacked bars should be the values in the fields. how to set up the series in the chart object to reflect this?
I need to display the data as pie chart,bar charts(2D,3D) here data is JSON data. any nice articles using jquery or java script free plugins ?
View 1 RepliesSee this code
protected void Page_Load(object sender, EventArgs e) {
chart.InitChart(new Chart {
Type = ChartTypes.Spline,
BackgroundColor = new BackColorOrGradient(System.Drawing.Color.FromName("'#f1f2f7'")),
ZoomType = ZoomTypes.X
[Code] ....
in this code I want to bind data from database in series so how can i bind data from database
in above they have two parameters in series parameter1 and parameter2.
they have hardcoded array . I want to make it dynamic.
when i create a chart, it renders with lots of white space around the actual chart itself, especially below the legend. how can i adjust this?
View 3 RepliesI m having a problem in showing chart with datatable. I want to show my chart as shown in below image. How can i do this in ASP.net using MS chart controls
View 3 RepliesIn 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?
I have an application that needs to read data from a view and do some extensive manipulation prior to delivering it to a chart control (without modifying the original data in the database). I have the chart control on the page, and in the code-behind I've built a dataset which I load and manipulate programmatically to have the table, columns and rows needed (no datareader involved) I'm having considerable trouble binding the chart to the 'in memory only' dataset. Chart Control;
[Code]....
Code-behind; The arrays arDate(), arPropBase(), arPropRisk() and arProject() are declared and loaded prior to this code. I am certain that the arrays do contain valid data - I have verified that while debugging
[Code]....
I have tried many different ways to bind the chart to my dataset at runtime without any success;
[Code]....
