>Const product_column As Integer = 0 >Const productname_column As Integer = 1 >Const units_instock_column As Integer = 2 >Const units_onorder_column As Integer = 3 >Const reorderlevel_column As Integer = 4 >Const discontinued_column As Integer = 5 > >With ListView1.Items > .Add(myreader.Item("productid")) > curentrow = .Count - 1 > .Item(curentrow).SubItems.Add(myreader.Item("productname")) > .Item(curentrow).SubItems.Add(myreader.Item("unitsinstock")) > .Item(curentrow).SubItems.Add(myreader.Item("unitsonorder")) > .Item(curentrow).SubItems.Add(myreader.Item("reorderlevel")) > .Item(curentrow).SubItems.Add(myreader.Item("discontinued")) > If myreader.GetInt16(units_instock_column) <= myreader.GetInt16(reorderlevel_column) And _ > myreader.GetInt16(units_onorder_column) = 0 And _ > myreader.GetBoolean(discontinued_column) = False Then > .Item(curentrow).SubItems.Item(units_instock_column).ForeColor = Drawing.Color.White > .Item(curentrow).SubItems.Item(units_instock_column).BackColor = Drawing.Color.DarkRed > Else > .Item(curentrow).SubItems.Item(units_instock_column).ForeColor = Drawing.Color.DarkOliveGreen > .Item(curentrow).SubItems.Item(units_instock_column).BackColor = Drawing.Color.DarkRed > End If >End With >>