when i try to read my datareader it always returns null. please help.

Here is my code

    Dim SQL As String
    Dim varresult As String

        SQL = "<editied out>" 'the sql string works. returns a record when ran manually.

    Dim objConn As SqlConnection = New SqlConnection(ConfigurationManager.ConnectionStrin gs("strConnection").ConnectionString)
    Dim command3 As SqlCommand = New SqlCommand(Sql, objConn)


    objConn.Open()
    Dim dr As SqlDataReader = command3.ExecuteReader()


    If Not (dr Is Nothing) Then
        Do While dr.Read
            varresult = dr("SettingValue").ToString
        Loop
    End If

        dr.Close()

        objConn.Close()

Maybe this help you
[ MSDN rocks! :) ]
http://msdn.microsoft.com/library/de...eadertopic.asp
------------------ cut here -------------------------------------
Public Sub CreateMySqlDataReader(mySelectQuery As String, _
myConnectionString As String)
    Dim myConnection As New SqlConnection(myConnectionString)
    Dim myCommand As New SqlCommand(mySelectQuery, myConnection)
    myConnection.Open()
    Dim myReader As SqlDataReader =
myCommand.ExecuteReader(CommandBehavior.CloseConne ction)
    While myReader.Read()
        Console.WriteLine(myReader.GetString(0))
    End While
    myReader.Close()
    'Implicitly closes the connection because
CommandBehavior.CloseConnection was specified.
 End Sub
------------------ cut here -------------------------------------