In my ADO.net app., I have an order form that when the order is completed, the user checks a "Completed" checkbox (boolean data). When this checkbox is checked it removes the order form the open orders list (& does other functions). On this form I have a label that I would like to be visible only when there are open orders. I have tried a datareader & a dataset to try to get this boolean data but I am unable to retrieve just this 1 column's data from the data table.
Dim Con as new Odbc,OdbcConnection
Dim Com as new Odbc.OdbcCommand
Com.CommandText = ("Select Completed from Orders")
Com.Connection = Con
I believe I have to do a loop thru the rows to get this data. I don't need to put it into any kind of lable or textbox. I just want to be able to read the boolean data so that if there is just 1 open order the open order label will be visible.