This is the code i Use:Dim the_user As OdbcDataReaderDim myQuery As String = "Select count(*) from users where user_name='" & CStr(username) & "'"Dim myConnection As New OdbcConnection(conn.get_dsn)Dim myCommand As New OdbcCommand(myQuery, myConnection)myConnection.Open()'then the use of this OdbcDataReaderbut i can't run another query know else if i cancel the OdbcCommand and the OdbcDataReaderlike this:the_user.Close()myCommand.Cancel()then i can run another query.and at the end i close the connection:myConnection.Close()My question is like That :How i can run query in a loop of another query without the exception i got.