Databases
StackOverflow2013
Postsdbo
PODataTableReader is invalid for current DataTable 'TempTable'
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PODataTableReader is invalid for current DataTable 'TempTable'
    text
    copied!<p>I'm getting the following error whenever my code creates a DataTableReader from a valid DataTable Object:</p> <p>"DataTableReader is invalid for current DataTable 'TempTable'."</p> <p>The thing is, if I reboot my machine, it works fine for an undetermined 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.</p> <p>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).</p> <p>Some technical info:</p> <p>DEV Box: Vista 32bit (with all current windows updates) Visual Studio 2008 v9.0.30729.1 SP dotNet Framework 3.5 SP1</p> <p>SQL Server: Microsoft SQL Server 2005 Standard Edition- 9.00.4035.00 (X64) Windows 2003 64bit (with all current windows updates)</p> <p>Web Server: Windows 2003 64bit (with all current windows updates)</p> <p>Any help, ideas, or advice would be greatly appreciated!</p> <p>UPDATE 1:</p> <p>Ok - Have tried the following now with no success:</p> <p>1: Rebooted 2: SFC / ScanNow 3: Changed SQL Servers 4: Tried a different method that uses DataTableReaders 5: Cleaned solution</p> <p>The only thing I did find that worked was copy &amp; pasting the code from the main Visual studio instance, into another which had a simple console app. This then worked as expected (queried database and got results into a dataTable, created a datatablereader on that table, then queried hasrows before calling .Read()... All of which worked.</p> <p>I am struggling to see what could cause this, as there are NO code faults - i'm 100% certain, as it runs perfectly when published to the webserver.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload