VB.NET and MySQL: How to display the count value on label? : I have a monitoring in datagridview that has a display of list of vehicles and their types. I want to count the number of each type of the vehicle.

Example : there are 8 Sedans and 5 Motorcycles in the datagridview and I want it to display in the label.

here is my code:

 Dim table As New DataTable()
        
Dim command As New MySqlCommand("select count(ctype) from tblreport where ctype='SUV'", conn)
        
command.Parameters.Add("count(ctype)", MySqlDbType.VarChar).Value = Label6.Text
        
Dim adapter As New MySqlDataAdapter(command)
        
adapter.Fill(table)
        
DataGridView2.DataSource = table

Thanks in Advance