no data - but data is there!

[Techno]

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?

 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

[Techno]

interesting...if i do a while datareader.read() - it works fine...

[mendhak]

Yes, it's supposed to work that way.

Btw, does your query return only 1 value?

[Techno]

yup it does

[mendhak]

Then use .ExecuteScalar(). It's more efficient.