June 10, 2009 at 6:35 am
Hi,
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...
http://www.unitbv.ro/cata/errors/2.jpg
http://www.unitbv.ro/cata/errors/3.jpg
http://www.unitbv.ro/cata/errors/1.jpg
http://www.unitbv.ro/cata/errors/class.txt
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+property+with+the+name+'DenumireMaterie"... And this is true since the database seems to return fields from *other* tables and note from the queried one...
Here are some other discussions from other forums, but nothing helped:
- http://forums.asp.net/t/1432140.aspx
- http://forums.asp.net/t/1426029.aspx
- http://forums.asp.net/t/1420133.aspx
Please HELP !!!!!
Catalin
June 10, 2009 at 6:51 am
My first thought is to accept Visual studios error and check the data type conversion.
Is the column ID_Facultare a BIGINT or just INT?
can you post the table def too?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
