I am using VB.net Express I need to produce a chart so am using MSchart object.I am using the following code to try to add data (2) to column 1 of a series
Me.Reject_Chart.Series(0).Points.AddXY(1, 2)
I do not get an error immediately but then before the form can be refreshed I get a stack overflow.how to I set this data?
I am importing data from an excel file, and it is stored in a dataset. The data is then filtered with a binding source, and that data is outputted into a datagridview. The filtered data in the datagridview contains data for 2 identification numbers. I want to graph each ID number in a chart on their own bar, in either a stacked bar graph, or a double bar graph.
I am having trouble assigning each series to an ID number: I have tried using multiple binding sources, but each seems to override the previous giving too much/too little data. I have tried using multiple datagridviews, however I cannot assign more than one datagridview as the datasource for the chart. The code I have pasted below outputs a double bar graph, however both bars graph the same ID number.
Private Sub dataButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles dataButton.Click
Try
Dim cnRange As String = "provider=Microsoft.Jet.OLEDB.4.0; " & _
"data source='" & strFileName & "';" & _
"Extended Properties=""Excel 8.0; IMEX=1; HDR=No;"""
'moApp.Visible = True
[Code] .....
I have an array of type Double() (1 x n) that I am trying to quickly plot on a graph I've already set up. The only thing I want/need to do is take my array and store it as data points (y-axis values) in the series I already have. What's the best way to do this? Also, will the data points that are plotted change as my array changes, and if not, how would I replot those new points and get rid of the old points?
View 1 RepliesI have an ASP Chart (v4) which displays the data I need perfectly. I want it to show labels at the top of the data points and I am having some difficulty with it. Here is my code that works for both series but does not display the labels:
[Code]...
I think my subject sums up what I am interested in knowing. I am looking to create a chart where Series1 is from Table1, Series2 is from Table2 in the given Dataset. My code below doesn't throw any errors, but it appears to be grabbing the data for each series from the first table.
Imports System.Windows.Forms.DataVisualization.Charting
Public Class Form1
Public Sub New(ByVal ChartData As DataSet)
' This call is required by the designer.
InitializeComponent()
[Code] .....
I'm working in VS2010 on a visual basic application. It takes in serial port data, writes it to an access database, and then graphs the data.The data only comes in once every minute, so it's not like I'm building an oscilloscope. Right now, the chart is reading from the database using a table adapter and graphing just fine, so long as I keep the number of records in the database low.If I add too many records to the database, the chart shows a red "X" through it. I've played with changing the axes, but it is still a problem.I don't really need to graph the whole database.The twenty most recent records would suffice.How can I make a chart series with only a small subset of the database in it.Perhaps it cold be populated with a query?
View 1 RepliesI'm faced with a (fun, actually) data mining problem; I have raw ASCII files from instruments, and I want to move that data (~400 GB) into a database, then be able to run various algorithms determining correlations of time series, etc. I would like to write the mining algorithms in Visual Basic (.net, VS 2010 right now), and be able to do visualizations with VB code I have in hand.On the nature of the data: think of a set of several thousand devices, each recording a measurement at a given interval - so I'm talking time-series vectors. It's not more complex than that - though I may have vectors with holes, etc. - not sure what problems of that sort lurk in the data.I spent today re-acquainting myself with VB.NET's interface to (in one case) a Microsoft Access database. What used to be fairly simple - DAO I think it was - involved tables, recordsets, etc (and that would likely be fine). Now I seem to be required to have a weird variety of generally useless objects, e.g. 'adapters', 'datasets', etc. The problem is that I know exactly what I need, and all this extraneous stuff just gets in the way (certainly in coding complexity and opaqueness, and likely in efficiency as well). If any of these mechanisms gave me a kind of virtual access to the entire dataset, and let me control caching parameters, etc.it might be great, but I found nothing along those lines. It seems like useless bloat, though I suppose it must be useful to someone.Anyway, I tried a number of different approaches, and none seemed at all aimed at what I need to do: efficiently do math on a large dataset. I can't believe I'm the first to have this problem, but I can find no useful wisdom out there. I'd be comfortable with pretty much any underlying database mechanism: MySQL, SQL Server, MS Access, but ideally something generally SQL based (I may eventually have to transition this entire system to draw from a client's SQL database, though that's not an overriding concern now). Other than that I want simplicity and efficiency. I thought my old ODBC techniques would work, and to some extent they do, though modifying tables seemed to have bizarre problems (no errors, but not modifications either).
I do have a fairly aggressive deadline to show some algorithm results, so my focus in the short term is to get something reasonable working *in* the short term - in other words, it's less important to me to pick the 'fastest' relational database than it is to pick a database that lets me focus on coding the algorithms, not working through tedious data access coding. If this db could be any smaller, I'd have tried to do it all 'in memory' at least for proving concepts; I don't want to have to learn an entire jargon and approach just to be able to retrieve data points.Perhaps I'll need to bite the bullet and just write something myself, a .dll perhaps just to save and restore large time series vectors. It seems a bit frightening to me that one would have to do this in this age, what with all the database systems out there, but I don't have much time to work through arcane interface logic.
Ok, what I would like to be able to do seems simple enough. I would like to be able to create an Excel document with a series of columns that contain data to import into Visual Basic 2008
[Code]...
This is my programs complete code, the only problem is i want to fix the amount of decimal places that show up in my gridview. The problem is if i do this on the asp side the location of the column gets thrown off and the column is duplicated. I figured if i just remade the table on the asp side it would work only problem is if i remove the sql for that particular column the asp side column cannot get data.
Imports System.Data.Sql
Imports System.Data.SqlClient
Imports System.Data
[Code]....
I want to merge or import a column of data from one data table created in VB.NET to another data table's 'same-named' column.The destination data table has all the required columns created before hand but the source data table contains one column at a time, whose name is the same as that of one of the columns in destination data table.Whatever coding I have done for the same till now, results in blank rows at starting. The destination data table looks like this:And I want it to be displayed it as:
View 1 RepliesSQL Server has a Data Type of "Float". Visual Studio has a Data Type of "Decimal". In other words, if I have a variable in a VB.Net app that is defined as a "Decimal" ...can I move that value into a SQL Server Data Table column defined as a "Float"?
View 4 RepliesI have a question about listbox. I want to display a series of * in one row. I know I have to use a loop, but I can not have the asterisk lined in one row.
View 3 RepliesI have a form in which there are two checkboxes then based on which check box the user selects a
series of labels and combo boxes are shown. I can't get the series of labels and cbx's to show and
to show when the check box is clicked.[code...]
I have a listview that has data in 4 different columns. It's just a quick phone storing project to keep "tuned up" on my programming.This is what i have to add the data into each column.[code]I need help finding the data in the second, third, and fourth column because that above is just returning the data in the first column.
View 2 RepliesHow to add a checkbox column at first column of datagridview including column header?After adding, how to code to "check all" or "uncheck all"?
View 27 RepliesImagine there is a line, in a text file, with three values separated with commas.
View 4 RepliesI have a strong amount of pictures, which i would like to "protect" by adding watermark on them. Is there any way of adding watermark by using vb.net or C# ?
View 3 RepliesI am new to Visual 2010 and cannot seem to find any information about using Charts.I have an array, call it PressureOutputs(1000), which I wish to plot against a second array,e(1000).Can anyone please explain how I would add these two arrays to create a series on an x-y scatter graph (which is already present on the Windows Form Application), or point me to a source of information about how to do this?
View 2 Replieshow to check if numerous textbox's have a value, and then if they all have a value that is greater than zero, and then if they do, execute a command?
View 1 RepliesIf used the following code to create three line series and three point series consists of only one point each.[code]I need to check if X value and Y value of the two series matches.How can I find the X and Y value of a point within a line between two points like the ones in the picture?
View 5 RepliesIf used the following code to create three line series and three point series consists of only one point each.
Public Function JYJAD_EVNELOP()
ENVELOP.Series("Take-off").Points().Clear()
ENVELOP.Series("Zero Fuel").Points().Clear()
[code].....
Program: Visual Basic 2010
Database: MS Access
When I use the following piece of code to delete a single row in a table, it works.
Dim daCcorrente As OleDbDataAdapter[code]...
I am trying to write a code for Fibonacci series in VB, but some of the values in my series are incorrect.Below is what I have so far.
[Code]...
I want to know how a row from a datagridview can be put into a series of textboxes say 1,2,3.I have connected the datagridview to my ms access db, with three fields. I have three text boxes too. i just want to know how to get the row from datagridview to be moved to the three textboxes accordingly.
View 1 Repliesi'm new to visual basic and i'm trying to expand my programming knowledge by creating random projects that include personal advantages. Right now I am trying to create a program that prescribes a series of commands necessary for the execution of game emulators with the touch of a couple buttons. ive created a gui of sorts ... i just don't know to make it function.
[Code]...
I have this task of writing a code that would play a series of wav files and then allow a person make comment on that wav file.
View 1 RepliesTrying to write a series of lines to a streamwriter in ASP.NET 3.5 VB.NET but I get an error 'Object reference not set to an instance of an object.' Here is the code
Dim sW As StreamWriter, iX As Integer = 0
For iX = 0 To 5
sW.WriteLine("SomeThing") 'Error occurs here
Next
My goal is to write a write a series of strings in different lines. This seems so simple but I don't see how the reference isn't set; I'm declaring two lines above.
Does someone here experienced this error: ERROR [58005] [IBM] SQL0902C A system error (reason code = "") occurred. Subsequent SQL statements cannot be processed.sQLSTATE=58005..I'm Trying to make a program that will retrieve data from IBM i Series DB2.I established a code below that will check if the program can connect to the server but the error message above appeared.[code]The error will appear on CheckDB2.Open()
View 2 RepliesSo I have a text box in a form. The test box needs to take the value entered and insert it into a column within a row in MySQL. I know it's connecting to the MySQL online, I have a message box telling me so upon a successful connection. I'm just having problems adding the value. Here's my code: Public Class frmOptions Dim ServerString As String = "server=db4free.net; Port =3306; user id=dailylogmain; password=XXXXXXX; database=dailylogmain;" Dim SQLConnection As MySqlConnection = New MySqlConnection
Private Sub frmOptions_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code]...
i am using asp.net.In my gridview control i have a column called "TotalAmount".The total amount in this column is to be calculated.How can i do this?
Like this:-
Col3(TotalAmount)
30
40
30
Total Amount=30+40+30=100?How can i calculate this 100?