Comments by Nour Abdel-Salam (Top 3 by date)

Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click

Dim objConn As OleDbConnection
Dim objCmd As OleDbCommand
Dim strConnString As String
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("carrent.mdb") & ";Jet OLEDB:Database Password=;"
objConn = New OleDbConnection(strConnString)
objConn.Open()

Dim strSQL = "select * from ListOfCars where car_id=" & DropDownList1.SelectedValue & " "

objCmd = New OleDbCommand(strSQL, objConn)
Dim myreader = objCmd.ExecuteReader

Response.Write(DropDownList1.SelectedValue)
Response.Write(myreader.GetString(1)) 'here is the error message (No data exists for the row/column)


End Sub

yes car_id is int
----------------------------------------------------------------------
Dim strSQL = "select * from ListOfCars where car_id= &DropDownList1.SelectedValue& "
objCmd = New OleDbCommand(strSQL, objConn)

Dim myreader = objCmd.ExecuteReader 'a syntax error appears