DataTableReader is invalid for current DataTable 'TempTable'
        Posted  
        
            by Sk93
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by Sk93
        
        
        
        Published on 2010-03-15T09:52:47Z
        Indexed on 
            2010/03/15
            10:09 UTC
        
        
        Read the original article
        Hit count: 567
        
Hi,
I'm getting the following error whenever my code creates a DataTableReader from a valid DataTable Object:
"DataTableReader is invalid for current DataTable 'TempTable'."
The thing is, if I reboot my machine, it works fine for an undertimed amount of time, then dies with the above. The code that throws this error could have been working fine for hours and then: bang. you get this error. It's not limited to one line either; it's every single location that a DataTableReader is used. Also, this error does NOT occur on the production web server - ever.
This is an example of one of the lines where it falls over:

If I step over this line, I get this:

However, if I do this in the immediate window:

I get no problems. Same goes if I actually use that line in the code.
This has been driving me nuts for the best part of a week, and I've failed to find anything on Google that could help (as I'm pretty positive this isn't a coding issue).
Some technical info:
DEV Box: Vista 32bit (with all current windows updates) Visual Studio 2008 v9.0.30729.1 SP dotNet Framework 3.5 SP1
SQL Server: Microsoft SQL Server 2005 Standard Edition- 9.00.4035.00 (X64) Windows 2003 64bit (with all current windows updates)
Web Server: Windows 2003 64bit (with all current windows updates)
any help, ideas, or advice would be greatly appreciated!
Cheers, Ian
© Stack Overflow or respective owner