hi there
using oledb here

i am doing a simple select statement. Data does exist if i look at the table myself or do a SQL query in MS Access where i am obtaining the data from however asp.net/vb.net reports there is no data recieved from the database - but that data is there.

any ideas?

Code:
 Dim theCarIDStatement As String = "SELECT CarID FROM cars WHERE carManufacturer = '" + cmbCars.SelectedItem.Text + "'"
        If cmbCarsModel.Items.Count <> 0 Then
            theCarIDStatement += " AND carModel = '" + cmbCarsModel.SelectedItem.Text + "'"
        End If

        Dim CarIDoleDBQuery As New OleDbCommand(theCarIDStatement, theOLEDBConnection)

theOLEDBConnection.Open()

Dim theCarIDDataReader As OleDbDataReader = CarIDoleDBQuery.ExecuteReader()
Dim theCarID As Integer
theCarID = theCarIDDataReader.GetInt32(0) '<< HERE