The application we use is on ASP.Net C# uses IIS6 and SQL Server 2005. We have just about 7 users, who login at approx the same time every day.
On the days where there is not much usage, the regular users do not face a problem. But when all the users are on the application on the peak days - which is about 7-10 days every month, an otherwise flawless application starts giving DataSource related
errors.
The error mostly reads like "DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'ID'....."
However there is no DataBinding problem as the same page functions perfectly with the same set of data.
We normally just keep refreshing the browser till the error disappears or I log into the Management Studio > Management > Activity Monitor and check if there are any idle system processes. If there are i just kill them. After this is done, the application
seems to be working fine.
Sometimes the issues arise within 5 mins of doing the above, some times they disappear and the application is working fine.
Am not from the MS development platform and this is one mystery that has completely boggled me.
The error mostly reads like "DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'ID'....."
However there is no DataBinding problem as the same page functions perfectly with the same set of data.
According to your description, I would like to suggest you check you code to see if there is anything breaking.
The above exception occurs when a specified data item in the web control does not exist in the schema of the returned DataRowView. In other words the column that you have specified with the databound control is not present in the data returned from database.
.NET forums are moving to a new home on Microsoft Q&A, we encourage you to go to Microsoft Q&A for .NET for posting new questions and get involved today.
None
0 Points
2 Posts
Connectivity issue ? a very weird problem
Sep 16, 2014 03:45 AM|hemanginair|LINK
Hi,
The application we use is on ASP.Net C# uses IIS6 and SQL Server 2005. We have just about 7 users, who login at approx the same time every day.
On the days where there is not much usage, the regular users do not face a problem. But when all the users are on the application on the peak days - which is about 7-10 days every month, an otherwise flawless application starts giving DataSource related errors.
The error mostly reads like "DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'ID'....."
However there is no DataBinding problem as the same page functions perfectly with the same set of data.
We normally just keep refreshing the browser till the error disappears or I log into the Management Studio > Management > Activity Monitor and check if there are any idle system processes. If there are i just kill them. After this is done, the application seems to be working fine.
Sometimes the issues arise within 5 mins of doing the above, some times they disappear and the application is working fine.
Am not from the MS development platform and this is one mystery that has completely boggled me.
Any suggestions will really be immemsely helpful.
I can provide more info if required.
Thank you in advance -
Hemangi
All-Star
120146 Points
27989 Posts
Moderator
MVP
Re: Connectivity issue ? a very weird problem
Sep 16, 2014 03:55 AM|ignatandrei|LINK
YEs. Show stack trace and lines of code.
None
0 Points
2 Posts
Re: Connectivity issue ? a very weird problem
Sep 16, 2014 04:24 AM|hemanginair|LINK
Thanks for the response - how do i do a "stack trace"
as i said - we do not always get the error - so will get the code, next time the error appears
All-Star
45489 Points
7008 Posts
Microsoft
Re: Connectivity issue ? a very weird problem
Sep 18, 2014 05:01 AM|Zhi Lv - MSFT|LINK
Hi Hemangi,
According to your description, I would like to suggest you check you code to see if there is anything breaking.
The above exception occurs when a specified data item in the web control does not exist in the schema of the returned DataRowView. In other words the column that you have specified with the databound control is not present in the data returned from database.
More information about this exception, please refer to Mudassar Ahmed Khan's article: Exception - DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'x'
Best Regards,
Dillion