Oracle DataReader returns 1 row but Read method returns false

Question

I have a basic sql statement that looks up a user and returns one record but when I run a block of code that says if(myReader.Read()) it returns false. I have stepped through the code and examined the reader object and it does in fact contain one record. below is the code.

sql: SELECT user_name, user_password, user_state FROM users WHERE users.user_id = 123

    System.Data.Common.DbCommand _cmd = this.GetCommand(conn, _dbf, sqlText, CommandType.Text);
     System.Data.Common.DbConnection _cn = _cmd.Connection;
     System.Data.Common.DbDataReader myReader = null;

     _cn.Open();
     using(_cn) {
        myReader = _cmd.ExecuteReader();
        if (myReader.Read())  {
                <object gets built here with user data returned from sql>
          }
       }

Does this query return results when run from sqlplus or sql developer? — thecoop
– thecoop, Commented Feb 4, 2010 at 13:16
yes, ran the sql in toad and it returned results. Verified the connection string was pointing to the correct database. — TampaRich
– TampaRich, Commented Feb 4, 2010 at 14:38

pierre · Accepted Answer · 2010-02-04 14:12:43Z

1

Try:

if (myReader.HasRows)
  while (myReader.Read())
  .....

answered Feb 4, 2010 at 14:12

pierre

1,2451 gold badge13 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

TampaRich Over a year ago

that is how I would have done it but it is not my codebase to change. Just researching why another developers code is not working. Probably have them change it to this.

Collectives™ on Stack Overflow

Oracle DataReader returns 1 row but Read method returns false

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related