Unanswered: Data returned but not from the correct table
I've encountered a very, very strange situation in my application. I say strange because the errors are **intermitent** and I cannot find out the cause why they occur.
The error is shown to the end-user using a code where I pass a sqlcommand to the DB (Sql 2005) trying to get a bigint (column ID_Facultate) from a single table. The problem is that I've got a string (the name of a lecture) that has nothing to do with the that table.
Also, when I get these errors, **all** my application is going crazy.
In the SQL Profiler everything *seems* fine (the last executing rows seem to be the ones sent by my application)
Here are some links to 3 captured screens during the errors and the code I've used. Please note the Watch1 with the **very wrong** string value where I expected some integer...
The same error also appears in code where I use SqlDataSource this time the error is similar to "System.Data.DataRowView'+does+not+contain+a+prope rty+with+the+name+'DenumireMaterie"... And this is true since the database seems to return fields from *other* tables and note from the queried one...
and what data type is ID_Facultate? An INT in the data definition language right?
If your data type is an int, and I am more of a SQL guy than a .Net guy, but this sounds a lot like some thing I saw on a project a couple of years ago. If your data type is integer, there is no way the database is returning a string and this has something to do with IIS/.Net and session management.