I would like to though my datatable and seach in one particular column if there are any zeros.Currently I've been using the code below but I am not happy with the results . Any suggestions, ideas

If FormatNumber(myTable.Compute("0.00", "ProductCode = '" & txtProductCode.Text & "'   "), 2) IsNot Nothing Then
MsgBox("Can not save when a Raw Material has Zero Percent Percentage in Mix", MsgBoxStyle.Exclamation, "Remove Zeros")
Exit Sub
End If

Hi, I use this to show a label when the word "Out" is found.

For i = 0 To DataGridView1.CurrentRow.Index
                cv = CStr(DataGridView1.Rows(i).Cells("Column1").Value)
                If cv = "Out" Then
                    Label1.Visable = True
                End If
Next i