Can you paste your code/SQL here?

>I have some code that executes and sql command. When I get a SqlDataReader as the result and then do a simple iteration on the reader such as:
>while ( dr.Read() ) {
>
>}
>
>I get less results than when I get DataTable or DataSet as the result set. The sql is EXACTLY the same. The DataTable result set is what i would expect, and the reader returns less records.
>
>I'm running .net 1.1 with sql server 2000.
>
>Can anyone point to something I might be doing wrong. Could it be something in my connection string, or something else? Sure do appreciate the feedback, as I am at a loss.
>
>Dave