This is a migrated thread and some comments may be shown as answers.

Problem in RadGrid when bind with large data (12000 rows)

1 Answer 219 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Heera
Top achievements
Rank 1
Heera asked on 08 Jan 2013, 09:29 AM
I bind radgrid with large data 12000 rows then  grid display this records with paging
my problem is when i click paging(next page) then error is occured(Not enough storage is available to complete this operation. in javascript (IE8 Browser))
2.firefox browser (Click on next page in RadGrid)

      The connection was reset
      The connection to the server was reset while the page was loading.
      The site could be temporarily unavailable or too busy. Try again in a few
      moments.
     If you are unable to load any pages, check your computer's network
     connection.
    If your computer or network is protected by a firewall or proxy, make sure
    that Firefox is permitted to access the Web.



My Code Is c#
Page load Event()
{
if (ViewState["data"] != null)
            {
                RadGrid1.DataSource = (DataTable)ViewState["data"];
                RadGrid1.DataBind();
            }
}

button1_click()
{
SqlQuery="contain 25 column in select statement"

 DA.Fill(DT);
            RadGrid1.DataSource = DT;
            ViewState["data"] = DT;
            RadGrid1.DataBind();

//12000 rows store in radgrid
}

============================

.aspx

<telerik:RadScriptManager ID="RadScriptManager1" runat="server">
            </telerik:RadScriptManager>


 <telerik:RadGrid ID="RadGrid1" runat="server" AllowFilteringByColumn="True"
                AllowSorting="True" CellSpacing="0" GridLines="None" PageSize="25"  
                 Height="351px" AllowPaging="True" 
                       >
                <ClientSettings>
                    <Scrolling AllowScroll="True" UseStaticHeaders="True" />
                    <Resizing ClipCellContentOnResize="False" />
                </ClientSettings>
                <MasterTableView>
                    <CommandItemSettings ExportToPdfText="Export to PDF"></CommandItemSettings>
                    <RowIndicatorColumn Visible="True" FilterControlAltText="Filter RowIndicator column">
                        <HeaderStyle Width="20px"></HeaderStyle>
                    </RowIndicatorColumn>
                    <ExpandCollapseColumn Visible="True" FilterControlAltText="Filter ExpandColumn column">
                        <HeaderStyle Width="20px"></HeaderStyle>
                    </ExpandCollapseColumn>
                    <EditFormSettings>
                        <EditColumn FilterControlAltText="Filter EditCommandColumn column">
                        </EditColumn>
                    </EditFormSettings>
                </MasterTableView>
                <MultiHeaderItemStyle Wrap="false" />
                <FilterMenu EnableImageSprites="False">
                </FilterMenu>
            </telerik:RadGrid>
<telerik:RadButton ID="RadButton1" runat="server" BorderStyle="Solid" OnClick="RadButton1_Click"
            Text="RadButton" UseSubmitBehavior="False">

============================

this is my requirement
please give me proper solution.

thank you in advance.

1 Answer, 1 is accepted

Sort by
0
Nicolaï
Top achievements
Rank 2
answered on 20 Sep 2013, 08:21 AM
Hello,

Some tips:

(- don't call .databind() if you can avoid it in page load)
- Only use the radgrid needdatasource event.

on the button click, only do:
Radgrid.ReBind()

(which will get the data from needdatasource event:
DA.Fill(DT);
 RadGrid1.DataSource = DT;
)
Tags
Grid
Asked by
Heera
Top achievements
Rank 1
Answers by
Nicolaï
Top achievements
Rank 2
Share this question
or