data reader question

[EyeTalion]

if the query below returns zero rows, then shouldn't the objDR.read = false? The reason I ask this is becasue I know that no rows are being returned but it still goes into the Do while loop?

sqlCmd = "select employee_last_name,employee_first_name,employee_id from pcms.pcms_pcard where employee_work_unit='" & CmbWorkUnit.Text & "' and status_ind='A' order by employee_last_name"
        Dim objCom As New OleDbCommand(sqlCmd, objCon)
        Try
 
            objCon.Open()
            objDR = objCom.ExecuteReader
            Do While objDR.Read = True
                Me.CmbCards.Items.Add(Trim(objDR("employee_first_name")) & " " & (Trim(objDR("employee_last_name")) & "  " & (Trim(objDR("employee_id")))))
            Loop
            objDR.Close()
        Catch ex As Exception
            MsgBox("Credit Card fill error: " & Err.Description)
        Finally
            objCon.Close()
        End Try

[salvelinus]

You might think so. Try using the HasRows property of the datareader if you're using framework 1.1
MSDN
I know an empty Access db still shows row 1, even though there's nothing in it. Maybe that's the problem.

[EyeTalion]

it's an Oracle DB

[salvelinus]

Well, the link at MSDN has a section on Oracle, not sure if it'll help you. But one example there runs similar code to yours using HasRows

If myReader.HasRows Then
  Do While myReader.Read()
    Console.WriteLine(vbTab & "{0}" & vbTab & "{1}", myReader.GetInt32(0), myReader.GetString(1))
  Loop
Else
  Console.WriteLine("No rows returned.")
End If