I'm trying to get my head around excel charts. I've poured over these posts for the last couple of days now and i'm coming up dry. I've got a xl file thats got some data in the first 2 columns. I want to put the data in an XY scatter plot. Column A is the x coordinates and b is the Y.[code]...
View 6 RepliesHow to create org charts in vb.net?
View 6 RepliesHow to create Charts in vb.net. Is it possible to have a chart like this without any additional components
View 1 RepliesI would like to create several pie charts at form load. I have a database and I'm able to populate the pie chart dynamically but what I want to know is that is it possible for the system to create multiple pie charts? The pie chart represents the amount of free and used disk space.. obviously a server has multiple drives. I would like each pie chart to represent each drive.. but I don't want to drag and drop a chart control each time.
[Code]...
Can i create a connection which will give the next registered user a user ID (a number) from the .csv?
II tried something with Sum and +1 every time an "add" button is clicked, so it would count the number of registered users but when i clear the .csv file i will have a number that ain't connected with the amount of users.
if i Ex. have twenty people registered in my .cvs file the next one will show the number 21 in a label in the "add form". Excel have the numbers from the 1 to infinity in the side if i could call the next empty line number into a label or something like that the user ID will follow the numbers of registered users.[code]....
I have a slight problem with something i am working on. I found this module here:
View 2 RepliesOkay say we have a class that implements INotifyPropertyChanged and a property that has code in the setter to raise the PropertyChanged event. On the GUI side we have a text box with the code:
txtFirst.DataBindings.Add("Text", p, "FirstName", True) Where p is a Person object and FirstName is the property that raises the PropertyChanged event.
[code].....
I have been looping thru all of the rows in a DGV and matching a variable to a specific cell in the row to 'do stuff to that DGVRow.
For Each dgRow As DataGridViewRow In Me.dgvInsertCommercial.Rows
If dgRow.Cells("SomeColumn").Value = pid Then
'do stuff
end if
Is there a way to actually query or make a selection instead of having to loop thru all of the dgvRows?jfc
We have an item cull that retrieves items and their appropriate data from one server. Their Primary Keys need to be INNER JOINed with another table. However, the second table is on another server. We can retrieve that data using a separate select statement and accompanying VB objects.
How would one go about this programmatically in VB? Is a loop the best practice available? Although we are in a Microsoft Ecosystem, Server Linking is not possible.
I need a way to programaticaly block and then later unblock specific websites based on their domain names. I only need to block browsers (so http & https would be sufficient, I guess?) but not just Internet Explorer, it should also work for anyone trying to run Chrome or Firefox too.
View 4 RepliesI am programmatically updating some columns in a datagridview. When the user has also updated some columns then my program generated changes are also saved to the database (MSAccess). If the user does not update a dgv column, my program edits are not saved. I have read in another posting somewhere that I should be updating the bindingsource rather than the dgv cells. I have some code that was attempting to do this but it doesn�t work.
Dim dvr As Data.DataRowView
With TblClassMembersDataGridView
.EndEdit()
.CommitEdit(DataGridViewDataErrorContexts.Commit)
[code]....
PS. Is the bindingsource in a on-to-one relationship with the table returned by the Fill method? If not, I can see one obvious error.
I can edit the values in the dgv cells manually, add rows, delete rows all without problem and then update the database.My problem is in one form where I want to allow the user to filter the rows in the grid and then enter a value in a textbox and programmatically update all the cells in one column with that valueI can update the rows, and see the changes in the datagridview. When I try and update the database (using UpdateQuery on the underlying TableAdapter of the datagird) only some of thechanged rows are being updated I though it might be related
View 9 RepliesI am using .net 3.5 and vb.net 2008 I have a program that copies access databases (.mdb) over from one server to another to be used ofr a ArcGIS webservice. The databases are edited on one server then nightly copied over to the webserver so they can be consumed in an intranet page).
The program is just a windows form that runs copy command in the load procedure. The program itself is run form the scheduler as an admin user for the machine but no one is actually logged in when it runs at 1 at night. I then get this kind of error reported to me:
[Code]...
How can we add charts in VB.Net?
View 1 Repliessetting up a Bar chart and a Pie chart... The Barchart repsent how many people have that and the piechart is how much of what that person has bought.. i need to be able to change that?
View 2 Repliescurrently i m workin on Ms CHarts wid VB.NET nd create a chart sucessfully bt nw i wnt to click on that particular bar of that chart nd want to get that particular axis label of that bar ..
View 2 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 RepliesUnder VB2 I could create a form with many charts (One form had 12 graphs). You could define the chart once and cut and paste it the required number of times on the form. Each chart had an index and the code used the index to create and update the desired chart with the appropriate x,y data. Is it possible to do this in VB2010?
View 5 RepliesMy project that I had built used spreadsheets and charts within the forms to provide the user with the necessary data. This worked fine for VB2008 as it had all of the ActiveX office web components built into it. It seems that VB2010 has a different set of base components and emphasis office 14.0. I was wondering how people have gotten around this or if they can. I tried using DataGridView, but it doesn't seem to be able to do what I want to do. I need the ability to have users enter data into a table and then use that information to be able to build graphs real-time based on their data.
View 2 RepliesI am writing an ASP.Net VB2005 application, and I want to give my users the ability to create custom reports and charts on the fly, based on parameters defined in a wizard control. The data source is SQL 2008. This is also on my own dime, so I am looking for something that will not require a second mortgage.
View 2 RepliesI have a MVC application, which creates a Chart in the business logic like this:
StatisticsModel.Chart.Width = 150
StatisticsModel.Chart.Height = 300
StatisticsModel.Chart.Attributes.Add("align", "left")
StatisticsModel.Chart.Titles.Add("Statistics for: " + StatisticsModel.ProductNumbers)
StatisticsModel.Chart.ChartAreas.Add(New ChartArea)
[Code]...
i am working on a vb.net windows application. i want to incorporate the dynamic graphs and charts in the application.
View 1 Repliesi am trying to use an arraylist to build a graph using fusionfree however i cant get it to work, it keeps showing the same item from the array list
[code]...
I have a form with two seperate charts placed on top of each other.I am trying to set up a toggle button that works in sequence i.e. loads second graph over first on click. When clicked the second time it loads the first one and so on.I realise i can do this by making one visible then making it not visible but i am having troubles with the circular click requirement.
View 3 RepliesIs there a way to conditionally format an Excel Chart? For example I have a bar graph. Currently I have the bars a purple color. I would like to turn a certain bar red if it meets certain criteria. Is there anyway to do this?
View 1 Repliesi want to create excel charts in vb.net with data fetched from my database server in which records are selected at run time through vb.net form.
View 5 RepliesI'm trying to create multiple Excel charts, in one work sheet using VB.net.This is the code:
Code:
'creating the chart
Dim chartPage As Excel.Chart
Dim xlPump1Charts As Excel.ChartObjects
[code]....
how to create data charts in Access / VB ?
View 2 RepliesProbably a silly question but is it possible in Excel or VB to drag a charts point(s) ?I had a quick look at the object "Points"(part of Series Collection object) methods and saw there was a "Select" function.
View 4 RepliesI am creating a data analysis program (using Visual Studio 2010) having several functions. One of the functions is to create graphs (scatter plots) of my data. Now occasionally, I may collect a data point that appears good when I take it, but when I plot it on my graph, I find that it's bad data and needs to be deleted.
My problem is that I would like to have a button called, say, "Delete Points". I hit that button and then choose the point directly from the scatter plot. The data source for the plot is then updated removing the offending point. I would then also have a button called "Restore Points" to bring back deleted points.
I have been thinking of doing this in Excel, but only because I don't have much experience with any other plotting program. Using the Excel approach will have its shortcomings, like needing to push the "Delete Points" button on a GUI separate from the Excel window (and thus needing to activate the Excel window).