I have this Code

CommandText = "SELECT firstName FROM Students Where Students.ID
='"&idNum& "'"

myCommand = New SqlCommand(CommandText, myConnection)
Dim name As String = myCommand.ExecuteReader.GetString(0)
Response.Write(name)
myConnection.Close()



I get this Error massage:

Exception Details: System.InvalidOperationException: Invalid attempt to read when no data is present.

Check whether record exists before you start reading it.
i.e. before assigning the value check if it exists.

It is not how much we do,
but how much love we put in the doing.

-Mother Theresa