469,900 Members | 1,624 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,900 developers. It's quick & easy.

Datagrid EnableViewState problem

Hi everyone,
I have a datagrid to display search results. The search results at this
stage we only return the first 500 records to speed up the search. The
problem is, if I turn the EnableViewState on, the search regularly failed
with a message that says tempdb is full... It does not however happens all
the time. I have tried to turn the EnableViewState off, that seems to do the
trick but causes another problem, the datagrid's paging does not work for
hidden pages (example, we only 5 pages, numbered 1, 2,.., 5 with the rest can
be accessed by clicking the ... after the 5. After clicking the ... after the
5, the numbers 6 - 10 are displayed but if I click on any number from 7 to
10, it goes back to pages 1 - 5). HELP!!!!
Is there a size limit to the contents that can be displayed on an IE6 browser?
Has anyone experienced the same problem or is it just me?
Reducing the number of records returned is an alternative but it would be
much better if someone has a work around.
Any suggestion is greatly appreciated.
Calvin
Jan 12 '06 #1
2 2966
Hello,

Disable viewstate for each row after binding the data. Paging works without it

BindTheData();
foreach (DataGridItem item in dg.Items)
{
item.EnableViewState = false;
}
--
Milosz Skalecki
MCP, MCAD
"Calvin KD" wrote:
Hi everyone,
I have a datagrid to display search results. The search results at this
stage we only return the first 500 records to speed up the search. The
problem is, if I turn the EnableViewState on, the search regularly failed
with a message that says tempdb is full... It does not however happens all
the time. I have tried to turn the EnableViewState off, that seems to do the
trick but causes another problem, the datagrid's paging does not work for
hidden pages (example, we only 5 pages, numbered 1, 2,.., 5 with the rest can
be accessed by clicking the ... after the 5. After clicking the ... after the
5, the numbers 6 - 10 are displayed but if I click on any number from 7 to
10, it goes back to pages 1 - 5). HELP!!!!
Is there a size limit to the contents that can be displayed on an IE6 browser?
Has anyone experienced the same problem or is it just me?
Reducing the number of records returned is an alternative but it would be
much better if someone has a work around.
Any suggestion is greatly appreciated.
Calvin

Jan 12 '06 #2
Thanks so much Milosz. It worked like a charm.
Cheers.
Calvin

"Milosz Skalecki" wrote:
Hello,

Disable viewstate for each row after binding the data. Paging works without it

BindTheData();
foreach (DataGridItem item in dg.Items)
{
item.EnableViewState = false;
}
--
Milosz Skalecki
MCP, MCAD
"Calvin KD" wrote:
Hi everyone,
I have a datagrid to display search results. The search results at this
stage we only return the first 500 records to speed up the search. The
problem is, if I turn the EnableViewState on, the search regularly failed
with a message that says tempdb is full... It does not however happens all
the time. I have tried to turn the EnableViewState off, that seems to do the
trick but causes another problem, the datagrid's paging does not work for
hidden pages (example, we only 5 pages, numbered 1, 2,.., 5 with the rest can
be accessed by clicking the ... after the 5. After clicking the ... after the
5, the numbers 6 - 10 are displayed but if I click on any number from 7 to
10, it goes back to pages 1 - 5). HELP!!!!
Is there a size limit to the contents that can be displayed on an IE6 browser?
Has anyone experienced the same problem or is it just me?
Reducing the number of records returned is an alternative but it would be
much better if someone has a work around.
Any suggestion is greatly appreciated.
Calvin

Jan 18 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Andla Rand | last post: by
7 posts views Thread by A.M | last post: by
2 posts views Thread by Syed Sami R. Shah | last post: by
6 posts views Thread by sonic | last post: by
3 posts views Thread by Mortar | last post: by
5 posts views Thread by Jeff User | last post: by
6 posts views Thread by slinky | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.