Thursday, March 27, 2014

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
IT Certification Category (English)640x480

Partner Sites

VideoToGifs.com

EasyOnlineConverter.com

SqliteTutorials.com


Top Online Courses From ProgrammingKnowledge

Python Course http://bit.ly/2vsuMaS
Java Coursehttp://bit.ly/2GEfQMf
Bash Coursehttp://bit.ly/2DBVF0C
Linux Coursehttp://bit.ly/2IXuil0
C Course http://bit.ly/2GQCiD1
C++ Coursehttp://bit.ly/2V4oEVJ
PHP Coursehttp://bit.ly/2XP71WH
Android Coursehttp://bit.ly/2UHih5H
C# Coursehttp://bit.ly/2Vr7HEl
JavaFx Coursehttp://bit.ly/2XMvZWA
NodeJs Coursehttp://bit.ly/2GPg7gA
Jenkins Course http://bit.ly/2Wd4l4W
Scala Coursehttp://bit.ly/2PysyA4
Bootstrap Coursehttp://bit.ly/2DFQ2yC
MongoDB Coursehttp://bit.ly/2LaCJfP
QT C++ GUI Coursehttp://bit.ly/2vwqHSZ