How to display or also count the empty value?

See more:

VB

.NET

OleDb

I have datagridview that is already connected in my database using oledb. And it also displaying the count query and it also compute the results that are in critical level.

I have Active, Spare, Defective items.

Sample in Datagridview:

Active 1000
Defective 10
Spare 50

It is already compute the level of the defective. But if the defective is zero or none. It becoming like this:

Active 1000
Spare 50

It counts the "Spare" as the "Defective". I want to show in Datagridview that the defective is "0" if it is not existed. To prevent the computation of spare as defective.

What I have tried:

Dim Activeqty As Integer
        Dim Spareqty As Integer
Dim defectqty As Integer

Activeqty = DataGridView1.Rows(0).Cells(1).Value.ToString()
defectqty = DataGridView1.Rows(1).Cells(1).Value.ToString()
Spareqty = DataGridView1.Rows(2).Cells(1).Value.ToString()

Activepercentage = Activeqty * 0.1
If Actprcnt > defectqty Then
    CriticalReport.Listview.Items.Add("CRITICAL")
End If