Radgrid not loading new data on postback after sort

[Munish Sharma]

I am working on a radgrid which loads from datatable at runtime under NeedDataSource event. The grid is very dynamic and loads different columns in different cases. Everything works fine till I sort the column(either ascending or descending) and then do a postback to load new columns. When I do this it just fails to load the new changes.

Note: If I don't sort the column everything works fine. 

<telerik:RadAjaxManagerProxy ID="ampAnalysis" runat="server">
            <AjaxSettings>
                <telerik:AjaxSetting AjaxControlID="rgAnalysis">
                    <UpdatedControls>
                        <telerik:AjaxUpdatedControl ControlID="rgAnalysis" LoadingPanelID="LoadingPanel"/>
                    </UpdatedControls>
                </telerik:AjaxSetting>                
            </AjaxSettings>
        </telerik:RadAjaxManagerProxy>
        
        <telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server">
            <telerik:RadGrid ID="rgAnalysis" runat="server" ShowGroupPanel="false" Skin="Default" 
                AllowMultiRowSelection="True" AllowSorting="True" GridLines="None" BorderStyle="None" BorderWidth="0"   
                Height="500px" ShowFooter="True"  Width="100%" EnableViewState="False"
                AllowFilteringByColumn="True" PagerStyle-Mode="Slider" PageSize="12" AllowPaging="true" OnItemCommand="rgAnalysis_ItemCommand" >
                <GroupingSettings CaseSensitive="false" />
                <ExportSettings>
                    <Csv ColumnDelimiter="Tab" RowDelimiter="NewLine" FileExtension="txt" />
                    <Excel Format="Html" />
                    <Pdf FontType="Subset" PaperSize="Letter" AllowAdd="false" AllowCopy="false" AllowModify="false" AllowPrinting="true" Creator="ABI" 
                        PageBottomMargin="5mm" PageTopMargin="20mm" PageLeftMargin="5mm" PageRightMargin="5mm" PageHeight="297mm" PageWidth="420mm" />
                </ExportSettings>
                <FooterStyle HorizontalAlign="Right" Font-Bold="false"/>
                <MasterTableView AllowNaturalSort="true" ShowFooter="True" AllowMultiColumnSorting="true" EnableViewState="false" Width="100%">
                    <Columns>
                        <telerik:GridClientSelectColumn UniqueName="ClientSelectColumn" HeaderStyle-Width="50px" ItemStyle-Width="30px" />
                    </Columns>
                </MasterTableView>
                <ClientSettings>
                    <DataBinding EnableCaching="true"></DataBinding>
                    <Resizing ResizeGridOnColumnResize="true" />
                    <selecting AllowRowSelect="True" />
                    <Scrolling AllowScroll="True" SaveScrollPosition="true" FrozenColumnsCount="3">
                    </Scrolling>
                    <ClientEvents  OnRowSelected="rgAnalysis_RowSelected"  OnRowDeselected="rgAnalysis_RowDeselected" />
                </ClientSettings>
            </telerik:RadGrid>
        </telerik:RadAjaxPanel>

[Princy]

Hi Munish Sharma,

RadGrid does not support mixing declarative grid columns with grid columns added dynamically at runtime. You should either create all the columns in the grid programmatically, or else define them all in the ASPX file.This may be the issue which is causing such an undesired behavior in your code.Another best practice is to either use RadAjaxManagerProxy or RadAjaxPanel in your scenario,not both together.
Please provide your code behind as well if this doesn't help.

Thanks,
Princy

[Munish Sharma]

Princy,

It's nothing to do with the RadAjaxManagerProxy or RadAjaxPanel. As I said the grid works perfectly fine in most all the cases except just this one. There is no other issue with the functionality. 

Say my report1 has column1, column2, column3
and
report2 has column4, column5, column6

When I run report1, it shows me the column1, column2 & column3 and when I run report2 it shows me column4, column5, column6

But the problem comes when I run report1 and sort any column(column1 or column2 or column3) and then try running report2. Here it goes to needdatasource event and get the data for report2 and then crashes somewhere without any exception. I tried debugging it and found that it only comes once in column created event when I do the sort and run the second report. When I don't do the sort and run the second report it comes multiple times to column created event.

I have attached Images when it works without sorting (Without Sort 1, Without Sort 2, Without Sort 3)
I have also attached Images when it doesn't work with sorting(With Sort 1,With Sort 2,With Sort 3, With Sort 4)

I have added GridClientSelectColumn to get checkboxes for every row in grid. And yes we can add columns dynamically with the GridClientSelectColumn from datatable in need datasource.

Moreover, telerik:RadAjaxPanel is enclosed around the grid to call javascript as:
RadAjaxPanel1.ResponseScripts.Add("PrintRadGrid('" + rgAnalysis.ClientID + "')")

Javascript:
function PrintRadGrid(radGridId) {
            var radGrid = $find(radGridId);

            if ($telerik.isIE) 
            {
                if (document.getElementById('ctl00_cphCenter_rgAnalysis_ctl00').style.tableLayout == 'fixed') 
                {
                    document.getElementById('ctl00_cphCenter_rgAnalysis_GridFooter').style.width = '100%';
                    document.getElementById('ctl00_cphCenter_rgAnalysis_GridHeader').style.width = '100%';
                    document.getElementById('ctl00_cphCenter_rgAnalysis_GridData').style.overflow = 'visible';
                }
                else 
                {
                    if (document.getElementById('ctl00_cphCenter_rgAnalysis_ctl00').style.tableLayout == 'auto') 
                    {
                        document.getElementById('ctl00_cphCenter_rgAnalysis_GridData').style.overflow = 'visible';
                    }
                }
            }

[Jayesh Goyani]

Hello Munish Sharma,

I am agree with @princy. But if you faced only sorting issue then can you please try with the below code snippet.

RadGrid1.MasterTableView.SortExpressions.Clear();

Issue : As per screenshot you have applied sorting in sales column then you are binding the report2 data.
So, grid will remove reaport1 column and add report2 column then it will apply sales column sorting expression. in this binding process this will not able to find sales column in the grid so it will raised the Java-script error. So, Before rendering the radgrid it get the error so you are not to see changes in radgrid.

Solution : Before applied/changing the databind()/datasource from report1 to report2 or report2 to report1. Please clear the sort expression from the radgrid.


Thanks,
Jayesh Goyani

[Munish Sharma]

Hi Jayesh,

I am already using the sort clear command under postback before NeedDataSource but still the same problem./

command:
rgAnalysis.MasterTableView.SortExpressions.Clear()

Munish

[Munish Sharma]

I have found the fix. I just needed to add another few lines of code on Form_Load event:

If Not Page.Request.Params.[Get]("__EVENTTARGET") Is Nothing Then
            If Page.Request.Params.[Get]("__EVENTTARGET").Contains("pnlReporting") Then
                rgAnalysis.MasterTableView.SortExpressions.Clear()
                rgAnalysis.DataBind()
            End If
        End If