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

No comments:

Post a Comment