I have created a function to create a string to populate a y axis with data:
Function talktosql() As Double
Dim ConnString As String = "Data Source=MARK-WORKMSSMLBIZ;Initial Catalog=Yahoo_data;Integrated Security=True"
Dim SQLString As String = "SELECT [RDSA.L] FROM yahoo_data.dbo.XLON"
Dim SqlDataAdapter1 As New SqlDataAdapter(SQLString, ConnString)
[code]....
so it should for example come out like this:
Dim yValues As Double() = {55.62, 45.54, 73.45, 9.73, 88.42, 45.9, 63.6, 85.1, 67.2, 23.6}
I cannot seem to get the data from the function into the right format to populate "yvalues".(the msgbox that I put in at the end in the first code renders the result "0")
I'm just trying to create a graph where the user can input data into textboxes and then plot the data. I am attempting to use Zedgraph, but open to other suggestions. The program below creates a plot, but it won't update when the textboxes are updated.
Imports ZedGraph Public Class Form1 Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
I am using Visual basic express 2010. I have a set of data in a text file and I want to read that text file into the visual basic and create a chart. I am able to import the data into visual basic but I don't know how to use that data and create a 2d line graph from that data. [code]What I want to do in visual basic is create a chart like the chart created by microsoft excel.
I am wondering how one would go about using the graph control to display a bar graph that shows trends from my database.They are rather easy trends. I am building an industrial issue tracker and I would like for it to show how many issues were submitted each month for the last 6 months and also how many issues in the last month were of certain types that are categorized in my database.
This isnt the first time i have posted about a graph, last time i was posting about which way i should do it, now that i have created the graph (by drawing individual lines) i was wondering what the easiest way to actually get data from a SQL database and output it as a line on a graph. here is a picture of what the graph looks like (bottom of the page) [URL]
I am trying to plot a set of data using a function I have defined as an array: Private Sub calculate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles calculate.Click range(1) = min.Text For i = 2 To 100 [Code] ..... Range(i) I want to be my x values and fee(i) to be the y values. When I try to select range() and fee() as the x and y values for a series, I get an error because they are not of type double.
I'm currently trying to use ZedGraph to plot a graph based on some data I have extracted from a machine, with reference to a user entered "Frequency" range. I has to be a line graph, with Frequency on the X-axis, and extracted data on the Y-axis. There are 4 channels for the machine, but all data values extracted are close to each other, so multiple Y-axes are not needed. I'm also trying to do it within a class, and the graph should only be drawn when I click "Button3", otherwise there would be no data anyway and button2 extracts the data.
Below are my class (the graph code is at the bottom) and form1, which button3 should call the class, but I'm stuck for both the button interfacing and the class writing. I have also attached the output I get so you can have a look at what I need. Open it in Excel to see the format. The whole program is also attached as a text file if you prefer it that way.
i am doing A-level computing and for my project i need to be able to create a graph in a VB form using data imported from a spreadsheet at a given destination. I'm struggling to find any tutorials or posts that fit
Anyone have VB.Net or VBA code to ascertain if an Excel Object is positioned over (Hiding) spreadsheet data?I have code to create/position a chart object. Where would I begin to determine if there is data "under" an object.
I am working on a project and I want to have a list box with a custom data template populate with user data. My question is, when I click on an item in the list box, how can I tell what item I selected? Basically, if I select "kevin", I want to display his data. If I select Dave, I want to display his data. I do not know how to get the data our after it is bound...
I 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.
I'm programming in VB, using Visual Studio 2008.This is a Windows Forms program.GOAL: I want to populate a multi column ListView1 with the <Name>, <Calories>, and <Fat> of each <Food> when I click Button1.
Objects I'm using: ListView1 Button1 Profile.xml (not technically an "Object," I know ...)
i have two DataGridViewComboBoxColumn that i add at run time i need the items of the first DataGridViewComboBoxColumn to stay the same in all the rows of the gridview but i want the items of the second DataGridViewComboBoxColumn to be different from row to the other depending on the selected item of the first DataGridViewComboBoxColumn
I HAVE SUB TO PUBULTAE DATATABLE AND SET THIS DATATABLE TO COMBO DATATSOURCE.I NEED PUBULTE COMBO 2 VALUE BY PARAMETER FROM COMBO 1 TO PASS THIS PARAMETER TO STPRED PROCEDURE AND RETURN DATATABLE SURCE FOR COMBO 2
HOW FILL COM 2 PER ROW Dim ID As String = COMBOBOX1.VALUE dt = DB.returnDataTable("SP_UNITS_NAME", ID)
HOW BIND DT TO COMBOBOX 2 FOR EACH ROW IN DATAGRID
I have a data grid, and I am pulling data from a mysql table. How can I populate my grid with the data? I also want it so when someone double clicks the item it will perform an event. How can that be done as well?
We have a lot of PDF documents and would like to save information filled in by the user in SQL database and then pre-populate the answers in multiple PDFs for printing. We'd also want user to digitally sign the pdf and store the signature in database. Ideally I'd like to create VB project with form that users would fill in and then information should "flow" into existing PDF. Then later I'd setup some reports based on user-filled information. We probably will purchase Adobe LifeCycle software to use with PDF.
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?
I have a dropdownlist that I want to populate with a specific value and specific text. I'm not using a datasource but I am manually making a connection and retrieving data in code. How can I populate this dropdownlist? If I read the data with a datareader and increment an array I only get either the value or the text. This is what I have so far, but it is completely wrong:
//connection string etc goes here Dbcmd2.CommandText = "select dept,deptname from table" Dim dr As SqlClient.SqlDataReader[code]....
How can I get this to work without having to create a class object for Department? Is there anyway or should I create the class object?