VB.Net And MySQL Execute COUNT, MAX MIN, AVG

How To Execute MySQL Database Count Max  Min Avg In VbNet

vb.net and database count minimum maximum average

In This VB.Net Tutorial  We Will See How To Use MySQL ExecuteScalar Function To:
 - execute count command to get database table's records count.
 - execute min command to get database minimum value.
 - execute max command to get database maximum value.
 - execute avg command to get database average value.
In Visual Basic.Net  Programming Language And Visual Studio Editor.


Project Source Code:

Imports MySql.Data.MySqlClient

Public Class vbnet_mysql_ExecuteScalar

    Dim connection As New MySqlConnection("datasource=localhost;port=3306;username=root;password=;database=s_t_d")

    ' button count 
    Private Sub Button_Count_Click(sender As Object, e As EventArgs) Handles Button_Count.Click

        Dim command As New MySqlCommand("SELECT COUNT(`Id`) FROM `student`", connection)

        connection.Open()

        LabelVAL.Text = command.ExecuteScalar().ToString()

        connection.Close()

    End Sub

    ' button avg 
    Private Sub Button_AVG_Click(sender As Object, e As EventArgs) Handles Button_AVG.Click

        Dim command As New MySqlCommand("SELECT AVG(`Id`) FROM `student`", connection)

        connection.Open()

        LabelVAL.Text = command.ExecuteScalar().ToString()

        connection.Close()

    End Sub

    ' button max 
    Private Sub Button_MAX_Click(sender As Object, e As EventArgs) Handles Button_MAX.Click

        Dim command As New MySqlCommand("SELECT MAX(`Id`) FROM `student`", connection)

        connection.Open()

        LabelVAL.Text = command.ExecuteScalar().ToString()

        connection.Close()

    End Sub

    ' button min 
    Private Sub Button_MIN_Click(sender As Object, e As EventArgs) Handles Button_MIN.Click

        Dim command As New MySqlCommand("SELECT MIN(`Id`) FROM `student`", connection)

        connection.Open()

        LabelVAL.Text = command.ExecuteScalar().ToString()

        connection.Close()

    End Sub
End Class
      
///////////////OUTPUT:

VB.Net Use ExecuteScalar With MySQL Database




Share this

Related Posts

Previous
Next Post »

1 comments:

comments
Anonyme
14 mars 2019 à 23:09 delete

with much thanks :) Merci

Reply
avatar