operation is not valid due to current state of object

Question

1.00/5 (1 vote)

See more:

i have a error operation is not valid due to current state of object
i have the below solution
<appsettings>
<add key="aspnet:MaxHttpCollectionKeys" value="2001">

but this is valid for only 600 hundred records but i have 5000 records in grid.so what will be the right values for 5000 records
please help me

Posted 20-Feb-12 0:43am

joti parkash

Add a Solution

Comments

CRDave1988 20-Feb-12 6:49am

NOt clear. where and when u get this error?

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Varun Sareen · Answer 1 · 2012-02-20T00:49:00

Dear Friend,

As i don't know what database statement you are using to read the data from the table, so assuming that you are using a data reader:-

Generally this occurs when your SQL statement returns no values, the reader has nothing to read. Which would also explain why it works sometimes, and it doesn't work other times.

Data reader requires an open connection since it works on connected architecture.check if the connection is opened. If the rows u r trying to read is locked by some other transaction, i guess oracle might throw this error, Check if u can give no lock hint with select statement.

I would suggest u to use disconnected architecture, usage of datasets. It is easy and simple. It reduces the load on database server. It gets the data and closes the connection automatically. In connected architecture i.e data reader the connection has to be remained open till all ur business logic is completed.

Sarvesh Kumar Gupta · Answer 2 · 2012-02-20T02:33:00

Solution 3

Hi, follow below link

Error - Operation is not valid due to the current state of the object.[^]

Posted 20-Feb-12 2:33am

Sarvesh Kumar Gupta