I have a datagrid on my form which displays a data table from a DataSet (extracted from an Access DB) when the user selects an option from a combo box on the form. I would like this same data to be displayed in an MSChart on the same page but I dont know how to link the chart to the DataSet
View 3 RepliesPopulate MSChart From DataGrid / Access DB
View 6 RepliesI have a database with testmarks of - lets say 30 students. I would like to print a distribution chart using Mschart. The values will be loaded into an array ChartData(30) The distribution chart X-axsis should range from 0 - 100 and the Y-axsis 0 to the average amount.... hopes it makes sence....
[Code]...
I was given a ppt slide with 12 chart objects and a text box for each. see the zip attachment. This is a collection of metrics that we track and chart monthly. The previous custodian of this duty would manually open each and update the datagrid for each and add comments as needed. I want to automate this process using vb2008 express. I have a basic handle on windows forms and sql tables, but don't have a clue how to access these chart objects and text boxes in the ppt slide. I've tried adding the slide to my project - like an image, but nogo.
I thought I could update the slide using my form controls, taking data entered on the data grid, create my SQLdb and update the slide. There is a one to one relationship for each item on the form and the ppt slide - 12 ea (charts & boxes) on both. My issue is how to define the chart object (mschart) in vb and update the ppt slide.
I am trying to bind an Access database to a MSChart control in VB Net 2008. I have a test database populated with four fields SAMPLE-DateTime, Values-Number, MAX-Number and MIN-Number. I'd like to only display the rows that fall within a specific date range but I'm running into a problem when i try to execute the following command:
[Code]...
How do I print a MSChart in vb2008?
View 2 RepliesI've googled a bit and saw someone said they had success in simply dragging the .dll files over to their application's path. I have tried this as well, and unfortunately it doesn't work. It stops the errors, but my chart is entirely blank. Some of the features of the chart work. ie: the legend shows up. But I have hidden some items from the legend and they still appear in the legend while running on a 2.0 system. For example, on my development machine, it shows 4 items in the legend, but on the 2.0 machine, there are all 7 - including the 3 that I have hidden.
[Code]...
I would like to use MSChart to display a line chart (X-Y plot with 2 array) on visual basic 2008. I am wondering if someone here can share working examples of using MSChart on VB 2008. In my program, I would like to read in 2 pressure array, each as function of time. Then, plot the pressures using MSChart.
View 4 RepliesI have browse the net and can not find any examples of code that i can use to see how the Mschart control works. Can someone please help me with some examples.
View 4 RepliesI need to be able to plot (for example) the following values on a chart:
4.5
3.1
5.3
2.1
<1.0
2.5
The value <1.0 is there as we cannot give the exact value if it is less than 1 but we need to display it.
Is there a way of just displaying the datapoint label with '<1.0' as text, or something similar?
I am using combobox on a form to select a graph to display on MSChart. The points are then drawn on the chart which is fine for the first chart selected.If I then select a second chart to display it adds the data to the current graph.I have tried Me.Chart1.Series(0).Points.Clear()which clears the points but the axis information remains ie The first chart has 10 sets of points so the y axis goes to 10. When selecting the next chart which has 15 points the y axis goes to 25 even with the points removed.I have also tried manually setting the x and y max values after the new points are added but it doesnt alter the values.Any idea how to set the chart back to default so that I can plot the next.
View 2 RepliesI have created a chart with MS chart control on a form. On the form there is a menubar. Now i want to only print the chart and not the menubar and form layout. When i use one of the next two lines the whole form is printed.
Me.PrintForm1.Print()
'Or
PrintForm1.Print(Me, PowerPacks.Printing.PrintForm.PrintOption.Scrollable)
I also want the printed chart to be a fixed size. The size of the chart depends on the size of the form. The size of the form depends on the resolution of my screen. So the printed chart isn't always the correct size.
vb.net 2008, using DataGrid, How to connect with MS Access DataBase 2000?, In VB6 just drag Datagrid and ADODC set the datasource can see the data in few seconds.
View 3 RepliesWhat I am trying to do basically is open an access query in a datagrid view and then be able to make changes to the datagrid and then save it back to the database.When I try to save:
Me.BindingSource.EndEdit()
Me.TableAdapter.Update(DataSet)
It says that update is not a member of the tableadapter... Why is that?
I have a datagrid which I am using LINQ to fill, I then add some custom columns and fill them in programmatically - if the users clicks on the column header to re-sort, all the data in the added columns disappears. I am obviously missing something very basic here but can't seem to see the forest for the trees. I also have a couple of other questions about how I am doing things:
[Code]...
I started a forms solution in VB 2008, created a datasource to an access database (2010) and used the datagrid view to display the data. 3 fields in the access database are lookup fields with 2-8 values each, typed in by me, since the linking to other fields did not work. This is not working either. When I change the column to combo-box or not, those values, typed into access, are NOT showing up in the datagrid. the combo box has its drop down arrow but the value fields are empty.
View 10 RepliesMS released the new MSChart for .net 3.5 sp1. I'm trying to get the hang of it in VS2008. One big issue I have is that if I have no data plotted the chart area axis's aren't drawn. Does anyone know a way around that? That seems like a pretty basic/common issue.
View 6 RepliesI've spent hours searching the internet on this, and found a bunch of posts with similar problems, but none of the solutions I saw have worked for me, so bear with me. I have an application that's a couple years old that has a form with a chart on it(using mschart). Worked on my old development machine, and most users. Eventually some users started letting me know that the chart wasn't working for them. The chart was a minor feature, and I was unable to reproduce the problem, so it kept getting pushed back.
[Code]...
I am working in windows xp sp3, I am using MS visual studio 2008 with vb.net, In my system i dont have AxMSchart20Lib,Mschart20Lib and Mschart.ocx. From where to download in microsoft site. give the microsoft download url.
View 7 RepliesAny way to access a specific column and row of a datagrid generated by a sql-query in visual basic. The datagrid looks, simplified, like this:
Column1 Column2
Data1 Data2
Now I would need a function, that reads data2 out in visual basic (asp.net web).
I have taken up a task where end user should be able to enter information via vb interface into microsoft Access database. This then will be displayed onto the Datagrid via VB interface. The program needs to be setup in a way that first entry by end user will flash upon 3 hours.
Example:
VB Interface
=========
Basket Number | Number of Trays | Run Type | Time In
1 | 1 | CNC | 15:00:00
[code]....
Values defined within database shows in this datagrid.The Datagrid works fine and I can insert values into the database fine as well however, I am not sure how to setup a timer so that when 3 hours are up the first entry into the database(shown on datagrid) starts flashing.This is needed so that the end user gets an alert when the time is up so that he can take the trays out of the oven.
In Summary: Can we really setup a timmer so that a value in the datagrid will flash at a particular time.Below is the image of an application. Here you can see the data on the datagrid however I want it to flash after 3 hours. So the first entry will flash after 3 hours following the 2nd entry.
I am trying to save my data on datagrid to access and I got this error :| Object reference not set to an instance of an object. and is referring to this Me.myDA.Update(Me.myDataSet.Tables("Goods"))
Here's my code
Public Class frmGoods
Dim con As New OleDbConnection
Dim myDA As OleDbDataAdapter
Dim myDataSet As DataSet
CODE:.......................
I have a form with tabcontrols and datagrids in my accessfile I have 35 tables.I have set the datagrid to edit by enter and I use this code to update the tables:
View 7 RepliesI want to change the color of the row in my mschart i used this code but it says, index out of bounds. im working this for a couple of days but find no solution. im very much great full if i will be helped.
[codes]
AxMSChart1.RowCount = 5
AxMSChart1.Plot.SeriesCollection(1).DataPoints(1).Brush.FillColor.Set(250, 250, 250)
'error says index given is out bounds
[/code]
I have several questions regarding the MSChart
View 5 RepliesHow do I do the following with an MSChart?Set axes to x: [0 - 1000] and y: [0 - 1].Show the gridlines when chart has no points.Disable auto adjusting of gridlines.
Note: Setting Axis(X/Y).(Min/Max)imum seems to have no effect if a point exists inside the bounds.
in runtime I can see that X-axis limits of my chart (minimum and maximum) are automatically changed as I insert points. That's nice. So I came to an idea to change that minimum and maximum values. It worked. But as soon as I wanted to return (at runtime) to auto I came across some problems. First I discovered that when auto scaling is activated this values are:
[Code]...
VB2005 - I have a form that has three DGVs. Two of these DGVs have data that I want to plot on a chart (currently testing with MSChart). Im struggling to figure out how to just plot the data from one DGV. The DGV has a column Time and Level which I want o plot as X and Y respectively. Can this be done directly with data from a DGV?
View 3 RepliesIs it possible to access the horizontal offset, which I can't find in the property list of the datagrid?
View 2 RepliesNot able to update the table in access using the below function
Private Sub btnUpdate_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btnUpdate.Click
Dim cn As New OleDbConnection(Con)
Dim objUpdateCommand As New OleDbCommand
Dim objDataAdapter As New OleDbDataAdapter
[code].....