Data Reader [Resolved]

[carl_mathews200]

I am running sql server 2000 and have a stored procedure to return the user details for a given department.

Until now i had just 2 users in the database for testing purposes, now i have added a third and am having problems with the data reader, which will only return two records.

I have run the stored procedure in the QA and it returns all three users for the given department.

Is there any reason that the datareader will only return two records when there are clearly three in the table?

the code i am using to read it

While dR.Read
     ' For testing
     msgbox dR.Item("Username")
End While

Any suggestions or am simply doing something wrong??


Thank you.

EDIT: my own *stupid* mistake.