Wierd. Are you doing Asyncronous exection? What is the value of RecordsAffected property after you close the data reader?
>Hi- There's not a ton to say. The sql is fairly straigtforward, and when I run it in the query analyzer I'd get, for example, 19 rows.
>
>When I create a DataTable with the same SQL, I'll get 19 Rows
>( dt.Rows.Count == 19 )
>
>When I create the reader and do like this:
>
>counter = 0;
>while ( dr.Read() ) {
>//In here look at the reader's contents for this row
>counter ++;
>}
>
>at the end of this, the counter == 14;
>
>There's really not much to it.
>
>Any ideas? Anything else i can provide?
>
>db
- Jayesh