Member Avatar for tendaimare

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
  • 2 Contributors
  • 1 Reply
  • 121 Views
  • 20 Hours Discussion Span
  • Latest Post Latest Post by Gé48
Member Avatar for Gé48

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
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.