RadGrid issue when using on Sitefinity

[Jay Mehta]

Hi,

We have created a user control which has one radgrid control. The paging/sorting/filtering works well when tested locally.
But when we upload the user control to sitefinity site, the radgrid binds the data correctly but paging/sorting/filtering does not work.
On clicking on these options, it does a post back but no change on the grid.

Can you please help us figure out the issue?

Thank you,
Jay Mehta.

[Dimo]

Hello Jay Mehta,

Please refer to:

http://www.sitefinity.com/devnet/kb/sitefinity-3-x/radajaxmanager-initialized-too-late-in-the-page-life-cycle.aspx

If it does not help, please send the user control with any additional information that we may need to investigate the problem.

Sincerely yours,
Dimo
the Telerik team

[Jay Mehta]

Thanks Dimo.

We are using regular scriptmanager and it is declared in the master template.

We are not able to figure out the exact issue.

Here is the link of our sitefinity site, where the radgrid functionalities are not working:

http://www.gbci.org/main-nav/building-certification/leed-project-directory.aspx

Here is the code snippet of the radgrid declaration:

<TeleGrid:RadGrid id="RadGridProjects" tabIndex="0" runat="server" Skin="Lime" ShowGroupPanel="True"
                    Width="100%" AllowSorting="True" AllowPaging="True" AutoGenerateColumns="false" PageSize="30"
                    AllowFilteringByColumn="True">
                    <FOOTERSTYLE CssClass="GridFooter_Lime"></FOOTERSTYLE>
                    <GROUPINGSETTINGS CaseSensitive="False"></GROUPINGSETTINGS>
                    <PAGERSTYLE CssClass="GridPager_Lime" PagerTextFormat="Go to page: {4} &amp;nbsp;|&amp;nbsp; Displaying page {0} of {1}, projects {2} to {3} of {5}."
                        Mode="NextPrevAndNumeric" AlwaysVisible="True"></PAGERSTYLE>
                    <GROUPHEADERITEMSTYLE CssClass="GroupHeader_Lime"></GROUPHEADERITEMSTYLE>
                    <GROUPPANEL Visible="True">
                        <PANELSTYLE CssClass="GroupPanel_Lime"></PANELSTYLE>
                        <PANELITEMSSTYLE CssClass="GroupPanelItems_Lime"></PANELITEMSSTYLE>
                    </GROUPPANEL>
                    <FILTERITEMSTYLE CssClass="GridFilterRow_Lime"></FILTERITEMSTYLE>
                    <ALTERNATINGITEMSTYLE CssClass="GridAltRow_Lime"></ALTERNATINGITEMSTYLE>
                    <COMMANDITEMSTYLE CssClass="GridCommandRow_Lime"></COMMANDITEMSTYLE>
                    <SELECTEDITEMSTYLE CssClass="SelectedRow_Lime"></SELECTEDITEMSTYLE>
                    <HEADERSTYLE CssClass="GridHeader_Lime"></HEADERSTYLE>
                    <ACTIVEITEMSTYLE CssClass="ActiveRow_Lime"></ACTIVEITEMSTYLE>
                    <MASTERTABLEVIEW AllowFilteringByColumn="True" Width="100%" CssClass="MasterTable_Lime" GridLines="None">
                        <ROWINDICATORCOLUMN SortAscImageUrl="~/RadControls/Grid/Skins/Lime/SortAsc.gif" SortDescImageUrl="~/RadControls/Grid/Skins/Lime/SortDesc.gif"
                            FilterImageUrl="~/RadControls/Grid/Skins/Lime/Filter.gif">
                            <ITEMSTYLE CssClass="ResizeItem_Lime"></ITEMSTYLE>
                            <HEADERSTYLE Width="20px" CssClass="ResizeHeader_Lime"></HEADERSTYLE>
                        </ROWINDICATORCOLUMN>
                        <EDITFORMSETTINGS>
                            <EDITCOLUMN SortAscImageUrl="~/RadControls/Grid/Skins/Lime/SortAsc.gif" SortDescImageUrl="~/RadControls/Grid/Skins/Lime/SortDesc.gif"
                                FilterImageUrl="~/RadControls/Grid/Skins/Lime/Filter.gif" CancelImageUrl="~/RadControls/Grid/Skins/Lime/Cancel.gif"
                                EditImageUrl="~/RadControls/Grid/Skins/Lime/Edit.gif" InsertImageUrl="~/RadControls/Grid/Skins/Lime/Insert.gif"
                                UpdateImageUrl="~/RadControls/Grid/Skins/Lime/Update.gif"></EDITCOLUMN>
                        </EDITFORMSETTINGS>
                            <Columns>
                            <telegrid:GridBoundColumn Visible="False" HeaderText="Project ID" SortDescImageUrl="~/RadControls/Grid/Skins/Lime/SortDesc.gif"
                                DataField="ID" SortAscImageUrl="~/RadControls/Grid/Skins/Lime/SortAsc.gif" FilterImageUrl="~/RadControls/Grid/Skins/Lime/Filter.gif"
                                UniqueName="ID"></telegrid:GridBoundColumn>
                            <telegrid:GridBoundColumn Visible="False" HeaderText="Scorecard File ID" SortDescImageUrl="~/RadControls/Grid/Skins/Lime/SortDesc.gif"
                                DataField="ScorecardFileID" SortAscImageUrl="~/RadControls/Grid/Skins/Lime/SortAsc.gif" FilterImageUrl="~/RadControls/Grid/Skins/Lime/Filter.gif"
                                UniqueName="ScorecardFileID"></telegrid:GridBoundColumn>
                            <telegrid:GridBoundColumn Visible="False" HeaderText="Certification Level" SortDescImageUrl="~/RadControls/Grid/Skins/Lime/SortDesc.gif"
                                DataField="CertLevel" SortAscImageUrl="~/RadControls/Grid/Skins/Lime/SortAsc.gif" FilterImageUrl="~/RadControls/Grid/Skins/Lime/Filter.gif"
                                UniqueName="CertLevel"></telegrid:GridBoundColumn>
                            <telegrid:GridBoundColumn HeaderText="Project Name" SortDescImageUrl="~/RadControls/Grid/Skins/Lime/SortDesc.gif"
                                AutoPostBackOnFilter="True" DataField="ProjectName" SortAscImageUrl="~/RadControls/Grid/Skins/Lime/SortAsc.gif"
                                FilterImageUrl="~/RadControls/Grid/Skins/Lime/Filter.gif" CurrentFilterFunction="Contains" SortExpression="ProjectName"
                                UniqueName="ProjectName"></telegrid:GridBoundColumn>
                            <telegrid:GridBoundColumn HeaderText="Owner Organization" SortDescImageUrl="~/RadControls/Grid/Skins/Lime/SortDesc.gif"
                                AutoPostBackOnFilter="True" DataField="OwnerOrganization" SortAscImageUrl="~/RadControls/Grid/Skins/Lime/SortAsc.gif"
                                FilterImageUrl="~/RadControls/Grid/Skins/Lime/Filter.gif" CurrentFilterFunction="Contains" SortExpression="OwnerOrganization"
                                UniqueName="OwnerOrganization"></telegrid:GridBoundColumn>
                            <telegrid:GridBoundColumn HeaderText="City" SortDescImageUrl="~/RadControls/Grid/Skins/Lime/SortDesc.gif"
                                AutoPostBackOnFilter="True" DataField="City" SortAscImageUrl="~/RadControls/Grid/Skins/Lime/SortAsc.gif"
                                FilterImageUrl="~/RadControls/Grid/Skins/Lime/Filter.gif" CurrentFilterFunction="Contains" SortExpression="City"
                                UniqueName="City"></telegrid:GridBoundColumn>
                            <telegrid:GridBoundColumn HeaderText="State" SortDescImageUrl="~/RadControls/Grid/Skins/Lime/SortDesc.gif"
                                AllowFiltering="False" DataField="State" SortAscImageUrl="~/RadControls/Grid/Skins/Lime/SortAsc.gif"
                                FilterImageUrl="~/RadControls/Grid/Skins/Lime/Filter.gif" SortExpression="State" UniqueName="State"></telegrid:GridBoundColumn>
                            <telegrid:GridBoundColumn HeaderText="Country" SortDescImageUrl="~/RadControls/Grid/Skins/Lime/SortDesc.gif"
                                AllowFiltering="False" DataField="Country" SortAscImageUrl="~/RadControls/Grid/Skins/Lime/SortAsc.gif"
                                FilterImageUrl="~/RadControls/Grid/Skins/Lime/Filter.gif" SortExpression="Country" UniqueName="Country"></telegrid:GridBoundColumn>
                            <telegrid:GridBoundColumn HeaderText="LEED System" SortDescImageUrl="~/RadControls/Grid/Skins/Lime/SortDesc.gif"
                                AutoPostBackOnFilter="True" DataField="LEEDSystemVersionDisplayName" SortAscImageUrl="~/RadControls/Grid/Skins/Lime/SortAsc.gif"
                                FilterImageUrl="~/RadControls/Grid/Skins/Lime/Filter.gif" CurrentFilterFunction="Contains" SortExpression="LEEDSystemVersionDisplayName"
                                UniqueName="LEEDSystemVersionDisplayName"></telegrid:GridBoundColumn>
                            <telegrid:GridTemplateColumn Visible="False" HeaderText="Cert Level" GroupByExpression="CertLevel CertLevel Group By CertLevel"
                                SortDescImageUrl="~/RadControls/Grid/Skins/Lime/SortDesc.gif" AllowFiltering="False" SortAscImageUrl="~/RadControls/Grid/Skins/Lime/SortAsc.gif"
                                FilterImageUrl="~/RadControls/Grid/Skins/Lime/Filter.gif" UniqueName="ScoreCard">
                                <ItemTemplate>
                                    <asp:LinkButton ID="lbScorecard" Runat="server" CommandArgument='<%# DataBinder.Eval(Container.DataItem, "ScorecardFileID") %>' CommandName="ScoreCard"></asp:LinkButton>
                                </ItemTemplate>
                            </telegrid:GridTemplateColumn>
                            <telegrid:GridBoundColumn HeaderText="Scorecard" SortDescImageUrl="~/RadControls/Grid/Skins/Lime/SortDesc.gif"
                                AllowFiltering="False" DataField="certlevel" SortAscImageUrl="~/RadControls/Grid/Skins/Lime/SortAsc.gif"
                                FilterImageUrl="~/RadControls/Grid/Skins/Lime/Filter.gif" SortExpression="Scorecard" UniqueName="Scard"></telegrid:GridBoundColumn>
                        </Columns>
                        <COMMANDITEMSETTINGS RefreshImageUrl="~/RadControls/Grid/Skins/Lime/Refresh.gif" AddNewRecordImageUrl="~/RadControls/Grid/Skins/Lime/AddRecord.gif"></COMMANDITEMSETTINGS>
                        <EXPANDCOLLAPSECOLUMN SortAscImageUrl="~/RadControls/Grid/Skins/Lime/SortAsc.gif" SortDescImageUrl="~/RadControls/Grid/Skins/Lime/SortDesc.gif"
                            FilterImageUrl="~/RadControls/Grid/Skins/Lime/Filter.gif" ExpandImageUrl="~/RadControls/Grid/Skins/Lime/SinglePlus.gif"
                            CollapseImageUrl="~/RadControls/Grid/Skins/Lime/SingleMinus.gif">
                            <HEADERSTYLE Width="20px"></HEADERSTYLE>
                        </EXPANDCOLLAPSECOLUMN>
                    </MASTERTABLEVIEW>
                    <CLIENTSETTINGS AllowDragToGroup="True" AllowColumnsReorder="True"></CLIENTSETTINGS>
                    <ITEMSTYLE CssClass="GridRow_Lime"></ITEMSTYLE>
                    <EDITITEMSTYLE CssClass="GridEditRow_Lime"></EDITITEMSTYLE>
                    <FILTERMENU SelectedImageUrl="~/RadControls/Grid/Skins/Lime/SelectedMenu.gif" NotSelectedImageUrl="~/RadControls/Grid/Skins/Lime/NotSelectedMenu.gif"></FILTERMENU>
                </TeleGrid:RadGrid>

Thank you,

Jay Mehta.

[Dimo]

Hi Jay Mehta,

It looks like the RadGrid is not databound correctly - maybe you are binding it explicitly every time in Page_Load? Please refer to the relevant documentation:

http://www.telerik.com/help/aspnet-ajax/grdsimpledatabinding.html

http://www.telerik.com/help/aspnet-ajax/grdadvanceddatabinding.html

Greetings,
Dimo
the Telerik team

[Jay Mehta]

Thanks Dimo.

We are also using the same grid, same code on another website (not sitefinity driven), below is the link:

http://www.usgbc.org/LEED/Project/CertifiedProjectList.aspx

The grid works perfect here.

The only difference between radgrid's on these two sites is:

- The one which is not running properly is embedded in a user control and on sitefinity.

- The one running properly is embedded in a .aspx page and site is not sitefinity driven.

Thank you,

Jay Mehta.

[Dimo]

Hello Jay,

Since we are unable to track down the cause of the problem remotely, please send us your Sitefinity user control, which contains the RadGrid (include all relevant code behind) as well as a runnable ASPX page, in which the RadGrid works. Thank you in advance.

All the best,
Dimo
the Telerik team

[Jay Mehta]

Hi Dimo,

 

Please find attached aspx page in which grid works fine. The link of page is

 

http://www.usgbc.org/LEED/Project/CertifiedProjectList.aspx

Also same aspx page has been converted into a ascx control and added on sitefinity page, and is not working.
link for that is 

http://www.gbci.org/main-nav/building-certification/leed-project-directory.aspx

Please let me know if you have any other question.

Looks like i can not attach my code file with this reply. Please provide us a way to send that to you. We don't want to put code on public forum.

Thanks
Namrata

[Dimo]

Hi Jay Mehta,

Thanks, but we already inspected the live URLs and it is not clear what causes the problem. You can attach files in formal support tickets sent from your Telerik account.

http://www.telerik.com/account/support-tickets.aspx

All the best,
Dimo
the Telerik team

[Duneel]

Hi,

I'm also having the same problem. The control works fine when it runs on a seperate ASP.NET web project. And When I moved to Sitefinity, it doesnt behave the same way. Sorting, pading...etc doesnt work. I'm using the NeedDataSource event to bind data and when that event it getting called i'm not getting the the new page index...etc. I tried moving the RadAjaxManager to the master page and then dynamically add the controls from the code-behind of the user control as explained in the sample code but no luck. Can someone tell me what should I do to resolve this. I dont want change the current implementation and implement explicit databingings based on different events.

Thanks,
Duneel

[Tsvetina]

Hi Duneel,

Please post the declaration and code-behind of your Sitefinity page, which contains the RadGrid so we can try to point out a possible cause of the issue. Thank you in advance.

In the mean time, have you checked if disabling temporarily AJAX (EnableAjax=false in the ajax manager declaration) changes anything about the grid's behavior?


Greetings,
Tsvetina
the Telerik team

[Luke]

Hi There,

I'm getting the same issue. I'm just trialling the product and checking out what it can do.

I created a basic user control with a grid that works fine embedded in an aspx page. However to get it going I would have to remove the script manager so it can run inside the CMS. I did this and the grid comes up fine and I can perform 1 function on it. Like I could filter it once or do one grouping. After that it just stops working.

I'm guessing it's to do with the script manager or ajax or something. Can you help?

This is the ascx code. 

<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="ItaliaStockQueryBasic.ascx.cs" Inherits="SitefinityWebApp.Sitefinity.ItaliaStockQueryBasic" %>
 <script type="text/javascript">
     //Put your JavaScript code here.
    </script>
    <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">
        <AjaxSettings>
            <telerik:AjaxSetting AjaxControlID="RadGrid1">
                <UpdatedControls>
                    <telerik:AjaxUpdatedControl ControlID="RadGrid1" />
                </UpdatedControls>
            </telerik:AjaxSetting>
        </AjaxSettings>
    </telerik:RadAjaxManager>
    <div>
        <asp:SqlDataSource SelectCommand="SELECT * FROM BLAH"
            ConnectionString="<%$ ConnectionStrings:"Italia Test DB 230309"ConnectionString %>"
            ProviderName="System.Data.SqlClient" ID="DataSource1" runat="server"></asp:SqlDataSource>
        <telerik:RadGrid ID="RadGrid1" runat="server" ShowGroupPanel="True" GridLines="None"
            DataSourceID="DataSource1" AllowFilteringByColumn="True"
            AllowPaging="True" AllowSorting="True">
            <HeaderContextMenu>
                <CollapseAnimation Type="OutQuint" Duration="200"></CollapseAnimation>
            </HeaderContextMenu>
            <MasterTableView GroupLoadMode="client" PageSize="20">
<CommandItemSettings ExportToPdfText="Export to Pdf"></CommandItemSettings>
                <PagerStyle Position="TopAndBottom" />
            </MasterTableView>
            <ClientSettings AllowDragToGroup="True" AllowColumnsReorder="True">
                <Selecting AllowRowSelect="True" />
                <Scrolling AllowScroll="True" UseStaticHeaders="True" />
            </ClientSettings>
            <FilterMenu>
                <CollapseAnimation Type="OutQuint" Duration="200"></CollapseAnimation>
            </FilterMenu>
        </telerik:RadGrid>
    </div>

[Tsvetina]

Hi Duneel,

Have you tried using the approach mentioned by my colleague previously in this thread:
http://www.sitefinity.com/devnet/kb/sitefinity-3-x/radajaxmanager-initialized-too-late-in-the-page-life-cycle.aspx

Kind regards,
Tsvetina
the Telerik team