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 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]...
Why when I drag the datagridview in my designer, they don't give me a selection on which data source?
View 13 Repliesi am created Window based application .
i want to bind datagridview source to datatable .
whenever i write
Dim dt As datatable
dt = dgvtest.datasource
Error occur ?
I can't get my binding source to update from a DataGridView
This is how I'm loading the dataset into the dgv:
vb.net Dim sFileName = filelocation & "Checks.xls"
Dim connectionStringTemplate As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=""Excel 12.0;HDR=Yes;IMEX=1"""
Dim connectionString As String = String.Format(connectionStringTemplate, sFileName)
Dim sqlSelect As String = "SELECT * FROM [Sheet1$];"
Dim workbook As DataSet = New DataSet()
[Code]...
I want to create a binding source from a data gridView that i have that is connected to NorthWind database wit Mysql
View 5 RepliesI have a gridview in asp.net using vb 2005. on " Protected Overrides Sub Render"some of the data in the columns gets modified. when i do a view source.. and look at a column1's values it says 0010. in the render i am taking a value of ab0010 and turning it into the 0010 that is seen in the view source.. later on, there is a button_click event that goes through each line of the gridview and grabs some values. Here I'm doing a CType(gvr.FindControl("column1"), Label).Text the value is coming back as ab0010. so the question is.. the view source shows something different than what is in the viewstate?
View 1 RepliesI have a datagridview with a datasource from a MySQL query. Works fine. However, I want to add an extra column and generate some data into the cells. This works fine too and shows up as intended. However, I cannot sort on that extra column and the contents of the cells in the column are cleared out if I sort on the other colums. I realize this is all because of the original datasource, but Im hoping there is a way to "connect" the extra column in somehow?
Grid_SearcherResults.DataSource = dbconnection.bSource
Grid_SearcherResults.Columns.Add("Location", "Location")
'Then some code to set the value of the cells in the new column.. etc
I am trying to bind a list of a structure to my datagridview. But I just get a load of empty rows (I created the columns manually).
Public Sub New()
' This call is required by the Windows Form Designer.
InitializeComponent()
[Code]....
friend if I need a source code which filter a datagridview by two DateTimePicker.
we have:
a database
a table
two DateTimePicker
a DataGridView
and that the filtering process to do so on the field or table column this is the procedure I use to filter dategridview, only with a textbox. and is perfect, but as I modified to work with two DateTimePicker?
[Code]...
How to setup a datagridview to display data based on a combobox value, then query the data on that value to display the results in a datagridview. This is what i have so far but i'm sure the is a better way of doing it. the current code doesn't work. [code]...
View 1 RepliesI am trying to edit (in Visual Basic Express 2008) the source code of MapWindow's CSV to Shapefile plugin url... to read directly from a datagrid view. My datagridview is successfully created with the following code in frmMain:[code]With the help of BackWoodsCoder I was able to add the datagridview column names to the X and Y combo boxes but that's where I get stuck again. The original source code appears to re-read the delimited text file instead of using existing object code.I did try the MapWindow Forum first but have had no response thus far.
View 1 Replies1. I have a DataGridView box, that is connected to a MySQL database via the 'Data Source'. I am trying to do the datagridview1.rows.add("info here"), however i receive an error i cannot do this programmatically. I DO know the code to post to MySQL via the "insert into" la la la.However, I was curious if I can do this via the datagridview a bit..easier/simpler, such as a "datagridview1.rows.add(stuff)" sorta thing.
2. I am attempting to make a custom control, and as with ANY control, they have their.. settings. Example, a textbox, or label, has so you can set the Text. and color, etc.Others, have it (such as datagridview) have the little icon on the control itself, where you click it, and it opens a small window with settings.
As I have no idea on how to retrieve access data at the specific location in the table, so I wrote VBA code t export the entire access database to a datagridview which is located in the form1. There's a column of datagridview contain complete address information of a image. I'm thinking a way to link image source (of form 2 or xaml file) to the the column so that the image will be displayed. is there any code to get cell value at the specific location in the table? In excel VBA, sheets("Sheetname").Cells(rownumber, columnnumber).value is used to get the cell value, but how about code for this case?
View 2 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 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]...
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 use Mschart to produce charts. What I am trying to get is the nearest data point by where I click on the chart. The problem is that I can't find any connection between the HitTest values and the data point x/y values.Say, I clicked on the following point:
Dim result As HitTestResult = Chart.HitTest(e.X, e.Y)I have now values of X and Y where I clicked. How to associate it with the data point values?
What I want to achieve is to double-click on the chart which would find the nearest data point (x,y as integer) and knowing these values I would be able to recalculate other values based upon where the user needs it and double-clicks.
[Code]...
I want to associate date and time to x axis of mschart, but only date is shown on x axis and time is invisible.What's problem?
program :Public Sub drawChart(ByVal data() As Double, ByVal AxiX() As Date, ByVal i As Integer)
Dim numOfData As Integer = data.Count
[code].....
I have a windows forms project in VS2010 with a simple line chart.The data is dynamic and always ranging between 1.4000 and 1.5000.I want the Y axis's gridlines/labels to always be displayed on every #.##20 data point, as in: [code] So I tried the Interval property for the axis gridlines/ labels, setting it to 0.002, and the result was that the gridlines/labels were displayed every 0.0020 points, like for example this: [code]
but not on 0.0020 points too as shown previously.
I am using axMSChart objects to display charts in my VB .Net Windows Forms App.I am also trying to export them to a PowerPoint presentation which I automatically generate using Office Interop.However, when I use EditCopy to copy the Chart to the clipbord and paste it into PowerPoint, the color of the Edge of my Bar Chart is set to red for the firstSeriesCollection and green for the second one.
View 1 RepliesI have a problem regarding solutions that I have to develop. I work in a company which has a standard of NET Framework 3.5.Also the company has bought Visual Studio 2010 Premium for me.I need to develop an application in which I have to insert som Charts. Previosly in Visual Studio 2008 Express was very simple because I have installed MSChart Addon from Microsoft.The problem with VS2010 Premium is that I cannot create aplication with charts in NET Framework 3.5, only in .NET 4 but I cannot develop solutions in NET Framework 4.0 because, like I have said, the company standard installation is NET Framework
View 8 RepliesHow do you plot dynamic data (from a dataset) on MSChart?
View 3 RepliesPopulate MSChart From DataGrid / Access DB
View 6 RepliesI'm trying to make a very simple chart.[code]...
So the whole pie would represent the 1000 task and the 2 slices would represent the finished and unfinished task. How can i programmatically create this?