I am doing a registration system, and my system should have a report by using a bar/pie chart.How i want to create a bar chart with value generate from database. what component should i have to create those chart? im using visual studio 2008 and mysql query.
View 5 RepliesI'd like to get suggestion in both C# and VB.NET I created Chart like the following image:
[Code]....
I am doing a bar chart project. my project should looks like this:
The problem i have right now is that i don't know how to draw the rectangle in the right way. my rectangle start to draw at the left top, how do i fix my code to make the rectangle draw start from the bottom? Also, i know how to draw string of my each input value, but i don't know how to print data values inside each bar, centered horizontally and vertically. This is what i have done so far
Here is my code:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim Blue As Brush = Brushes.Blue
Dim Red As Brush = Brushes.Red
[CODE].........................
i have an application running on VS2010 and i'm using sql server 2008 r2. "Employee" table holds employees bio data, i can draw org chart using MS visio 2010 manual,i need to draw the org chart in Visio format from the VB.net application.
View 1 RepliesI have a ms access database with few tables and queries. I need to draw a graph/chart with the results of the queries in excel.
Is it possible to do with vb.net coding?
I have two values those are contiguously One is Time along x-axis and second is the CPU Usage in percentage along Y - Axis. I want to draw a continuous line Chart/graph what ever called.
View 11 RepliesI trying to draw a bar chart based on the five values getting from the user via textbox...When i run this program no error is occured, but the chat is drawn...Can anyone please help me out in this regard.
here is the code i have so far
[code]...
I have a chart in Excel that I'd like to use a subtitle on. There is no SubTitle Property on the chart object, so I looked in the Excel User interface and found that you can only create a sub-title by using a text box. The text box looks like its associated with the chart, not the worksheet, so how would I access that text box from code?
View 1 Repliesi am making a window application using visual studio 2010 and vb.net. i want to make charts daynimacilly using data from the database. how this can be done?
View 3 RepliesI have X and Y data columns coming from database.
I have to show scatter plot chart with Linear, Exponential, Log, power using asp.net chart control.
My requirement is to graph (scatter graph) data from 2 arrays. I can now connect the data from the array and use it on the chart. My question is, how do I set the graph's X- and Y- axes to show consistency in their intervals?
[Code]...
I'm trying this example but it doesn't seem to work. It gives a IndexOutOfRangeException:I'm using a txt file where the columns are Tab seperated.)
Imports System.Windows.Forms.DataVisualization.Charting
Imports System.Data
Imports System.Data.OleDb
[code].....
How do I dynamically add or remove a chart series on a WinForm. To date all my MS Charting experience has been dealing with ASP.Net charts with static sql select statment to a SQL Database. In the new project that I have been assigned I have different cities with different amounts of points that they want monitored. One city might have 3 an another might have 5 or 7 so I can't hard code the amount of series that I need. It needs to be set up so the amount of series can be flexible depending on the city selected and then display those points on the chart.
View 4 RepliesWhen i'm tryed to print Data chart the resolution of the chart changed as shown:
View 3 RepliesI need to display a graphical representation of database(access) in vb 2005. is there any way to do it. I dont mind how I just need to display barchart but data is in Ms Access.
View 2 RepliesI've got a datatable with two columns "Status" (string) and "Total" (integer).
Status Total
Success 34
Missing 2
Failed 10
I want to databind this into a pie chart with each Status per slice but I'm not sure what method of data binder is required?
I am using microsoft chart controls in VB.net. The graph data currently comes from my database, but all the series and chart formats were made before runtime. I want to know how to make charts on runtime, being able to select the x axis from my dataset and multiple y columns from my dataset.
View 1 RepliesI can not figure out how to get the chart to display the labels. When I try and add labels, the lines get messed up. Also, if I try and do multiple lines it does not always work out very well. I tried different ColumnLabels and they behave very strange as well. What I want is to be able to have several lines. Each with their own label. And also, I want to specify text for each point at the very bottom of the graph. Let me know what suggestions you have. [Code]
View 3 Repliesi wish to create line chart, pie chart and bar chart using vb.net of visual studio 2005.Second question is i wish to copy a few data into datagridview from microsoft office tools such as access or excel using shortcut key 'ctrl+C' and 'ctrl+V'.code to do the 2 functions above without installing additional tools?
View 5 RepliesI am trying to draw an image from a MS Access database by use of e.Graphics.DrawImage(New Bitmap()). In my database Row 0 Item 1 holds the path to the image I want to draw.
My current code looks like this:
Code:
Private Sub pnlStart2_Paint(ByVal sender As Object, ByVal e As_ System.Windows.Forms.PaintEventArgs) Handles pnlStart2.Paint
e.Graphics.DrawImage(New Bitmap(ds.Tables("Track1").Rows(0).Item(1)), 3, 3)
End Sub
When I run my program I get the following message in my code: Illegal characters in path how I can draw the image from the database?
I am working on an application that ties into a SQL database on the back end. Currently the main form contains a series of combo boxes (Graph type, data format, location, and customer), two date pickers, and a button to launch the selections in a new form. Everything works just fine except there are a couple of things I can't seem to accomplish.
Example Data:
[CODE]...........
Case Select (with commented out lines for variations attempted):
[CODE]..........
1) I would like to be able to use some sort of case statement to color the bars in my chart based on value. I have tried approaching this in a couple of different ways but neither of the options seem to work. First, I tried this (the If Not is used because depending on what values are passed to the stored procedure in SQL, different columns will be returned):
[CODE]..........
Only one series is created with this method, so I can see how/why a Select Case would set all bars the same color. I have also tried creating a series for each row in the returned dataset but it results in 22 bars of different colors, for each of the rows (484 bars):
[CODE]..........
So is there any way to modify the second set of code there to only select the value from the "Percent TMHB" cell that corresponds with Row(i), rather than ALL values from the "Percent TMHB" column for EACH Row(i)?
2) Since I am drawing/creating these graphs in a new window, is there any way to also create a new timer on the "newFrm" and have the tick refresh the data? I've struggled with this but I feel like it should be easy. Say someone chooses a "TMHB", "Percentage", "Chicago", "All" (Graph type, data format, location, customer) and launches the graph, which opens in a new window, then they want to do "TMHB", "Percentage", "LA", "All" and have both windows up, refreshing automatically throughout the day. Can I somehow store the SelectCommand.Parameters values in the new form/timer so that it will query the database again every 5 minutes?
Example code for the StoredProcedure and creating the new form:
If combo_GraphType.SelectedItem = "TMHB" Then
Dim newFrm As New Form
Dim newChart As New Chart
[CODE]..................
Got a chart control i wanna make from a data table. the table looks like this:
the chart i want will look like this:
'''
''''
[code].....
I'm having problem with MS Chart chart type column. If there are only 9 bar in the chart like the following picture, then the axis-x label show up properly.
However, there are more than 9 bars bar the chart, the axis-x label wont show up properly, some of them just dissappear.
Here's my mark-up for the chart:
<asp:Chart ID="chtNBAChampionships" runat="server">
<Series>
<asp:Series Name="Championships" YValueType="Int32" Palette="Berry"
[Code]....
I don't know it works with only 9 bars? Is there any way to make the chart work properly? Also, if possible, how to make each bar have different color.
I need to get the DataGridView to perform the way it should perform. I'm new to the .NET environment, but I learn fairly quickly. However, I find it difficult to decipher themassive black box of the DataGridView control enough to make it do anything other than what it already does--Draw very slowly.
View 3 RepliesI have the smallest dataset in the world that simply consists of a month (text) and and amount. I want to produce a chart showing the month along the y-axis and the value up the x-axis. How do I do it? I have dragged the chart control onto the report page and populated the dataset. The chart shows but nothing like what I would expect. Just to make it simple I populated the dataset with an amount equivalent to the month number so it should show as 1 in January, 2 in Feb etc...However no matter where I drag the dataset's column names I don't get what I want. Where am I going wrong?
I use this simple loop to populate the dataset:
dsSales.Tables("Sales").Clear()
For i As Integer = 1 To 12
dsSales.Tables("Sales").Rows.Add(MonthName(i), i)
Next
ReportViewer1.RefreshReport()
I get this as a result:
I'm only getting started with VB.Net, using VB Express 2008.Using the System.Data.SQLite wrapper, I need to read data off a SQLite database file, and chart data using basic bars, pies, lines, etc. Nothing fancy.
View 1 RepliesI can't figure out how to plot anything on this chart...finally got it to actually display a pie chart, now I'm trying to somehow bind a data source to it and from there, select the series data..I have added the database to the project as a data source but I don't know how to bind it to the pie chart. some other info: this db has 100's of tables and the program I'm working on is going to be a "status monitor" of sorts that will contain about 6-8 different types of charts all plotting different info for me in chart form.I want to bind this one data source to all the charts and just have them display different information (based on the sql query perhaps)
View 9 RepliesI have a form that uses a button to draw a line and a second button to draw a rectangle. I have a third button to clear the form but can't find a code example to code the Clear button.
View 4 RepliesI have to draw a bar graph in my vb.net program. I used AxMSChart to create a graph. Everything has gone fine but when i published this and run on Vista PC, all form was good except my form includes MSChart. It says class not registered.So i have to draw a graph except MSChart tool.
View 10 RepliesBasically I've coded an Excel 2007 project in VB.NET 2010 that allows you to create charts with a fair amount of interactivity. I want the user to be able to save and reopen this workbook and still have that interactivity in any already-created charts, so they don't have to re-create them.
When I create the charts, I use Sheet1.Controls.AddChart(...), which returns a Microsoft.Office.Tools.Excel.Chart with which I can handle events and such. However, when I reopen the file and look through the Sheet1.Controls collection, there are no Chart objects. Accessing the charts through Sheet1.ChartObjects.Chart gives me Interop Charts, when I need the Tools Charts.