Grid View Binding Error

Question

2.00/5 (1 vote)

See more:

.NET3.5

While binding a grid with more than 3000 record i am getting error like
'System.OutOfMemoryException' was thrown,

Stack

OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.]
System.String.GetStringForStringBuilder(String value, Int32 startIndex, Int32 length, Int32 capacity) +29
System.Text.StringBuilder..ctor(String value, Int32 startIndex, Int32 length, Int32 capacity) +104
System.Data.DataSet.SerializeDataSet(SerializationInfo info, StreamingContext context, SerializationFormat remotingFormat) +856
System.Data.DataSet.GetObjectData(SerializationInfo info, StreamingContext context) +18
System.Runtime.Serialization.Formatters.Binary.WriteObjectInfo.InitSerialize(Object obj, ISurrogateSelector surrogateSelector, StreamingContext context, SerObjectInfoInit serObjectInfoInit, IFormatterConverter converter, ObjectWriter objectWriter) +7630106
System.Runtime.Serialization.Formatters.Binary.WriteObjectInfo.Serialize(Object obj, ISurrogateSelector surrogateSelector, StreamingContext context, SerObjectInfoInit serObjectInfoInit, IFormatterConverter converter, ObjectWriter objectWriter) +51
System.Runtime.Serialization.Formatters.Binary.ObjectWriter.Serialize(Object graph, Header[] inHeaders, __BinaryWriter serWriter, Boolean fCheck) +410
System.Runtime.Serialization.Formatters.Binary.BinaryFormatter.Serialize(Stream serializationStream, Object graph, Header[] headers, Boolean fCheck) +134
System.Runtime.Serialization.Formatters.Binary.BinaryFormatter.Serialize(Stream serializationStream, Object graph) +13
System.Web.UI.ObjectStateFormatter.SerializeValue(SerializerBinaryWriter writer, Object value) +842

[ArgumentException: Error serializing value 'System.Data.DataSet' of type 'System.Data.DataSet.']
System.Web.UI.ObjectStateFormatter.SerializeValue(SerializerBinaryWriter writer, Object value) +3319
System.Web.UI.ObjectStateFormatter.Serialize(Stream outputStream, Object stateGraph) +110
System.Web.UI.ObjectStateFormatter.Serialize(Object stateGraph) +57
System.Web.UI.ObjectStateFormatter.System.Web.UI.IStateFormatter.Serialize(Object state) +4
System.Web.UI.Util.SerializeWithAssert(IStateFormatter formatter, Object stateGraph) +37
System.Web.UI.HiddenFieldPageStatePersister.Save() +79
System.Web.UI.Page.SavePageStateToPersistenceMedium(Object state) +105
System.Web.UI.Page.SaveAllState() +236
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1099

I needed to display one month record so its coming more than 3000,so pls help on this.Thanks in advance

Posted 6-Jan-10 1:42am

HimaSijo

Updated 6-Jan-10 17:33pm

v2

Add a Solution

3 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)

Christian Graus · Answer 1 · 2010-01-06T17:41:00

Solution 2

The error message speaks for itself. The big question is, why are you showing 3000 records in a single page, instead of offering paging and filtering, and what are you displaying in order for your code to use all your memory ?

Posted 6-Jan-10 17:41pm

Christian Graus

thatraja · Answer 2 · 2010-01-13T22:14:00

Solution 3

yes you must use paging or filtering otherwise end user will be frustrated. by using filtering you can display selected date transactions. But my suggestion is use paging with filtering.

Posted 13-Jan-10 22:14pm

thatraja

benjymous · Answer 3 · 2010-01-06T03:14:00

Solution 1

Presumably you're running out of memory. We really can't tell you much more from the little information you've given us.

If your table contains many columns, you could try trimming them down a bit in your query.

Posted 6-Jan-10 3:14am

benjymous