MySQL VB.NET Tutorial 16 : How to Link Chart /Graph with Database





Private Sub LOAD_CHART_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles LOAD_CHART.Click
MysqlConn = New MySqlConnection
MysqlConn.ConnectionString =
"server=localhost;userid=root;password=root;database=database"
Dim READER As MySqlDataReader
Try
MysqlConn.Open()
Dim Query As String
Query = "select * from database.edata"
COMMAND = New MySqlCommand(Query, MysqlConn)
READER = COMMAND.ExecuteReader
While READER.Read
Chart1.Series("NAME_VS_AGE").Points.AddXY(READER.GetString("name"), READER.GetInt32("age"))

End While
MysqlConn.Close()
Catch ex As MySqlException
MessageBox.Show(ex.Message)
Finally
MysqlConn.Dispose()
End Try
End Sub














---------------------------------------

Creating graph in Windows Forms Application Mysql vb.net

Data Binding a Chart to a Database visual basic

Line chart in c# using data from database

 - Graph database for vb.NET

How to Create Excel graphs using vb Program

Creating graphs using visual studio

Graph And Sql Data - C# Programming

Using Chart Control in Visual Studio 2010 C beginners

Creating graph in Windows Forms Application

Charts in SQL Server Reporting Mysql

Threaded plotting in Visual Studio visual basic with Windows Forms vb.net Windows Forms application

How to reload a fastline chart using Windows.Forms

Windows Charting Application

Learn the Windows Forms Chart Control

How do I plot data on a Chart in a CLR Form in C#?‎ Mysql

how to draw line graph in .net?‎ Mysql

Plot with visual studio C# express‎  Mysql

Comments