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

Clientside error message on RadGrid

9 Answers 264 Views

Grid

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

Silver asked on 17 Jul 2009, 01:54 PM

I am just looking at the Telerik controls as part of an evaluation for some work I will be carrying out but have come up against an error with the RadGrid control.

I have a simple linqdatasource retrieving a firstname and lastname from a contact list. I have implemented a radgrid with paging, filtering, sorting and grouping. The grid brings back the first page of results but I receive the following client side message when I try to navigate to the next page...

sys.webforms.pagerequestmanagerservererrorexception
Exception has been thrown by the target of an invocation

The grid is ajaxified, in a radmultipage that is controlled by a tabstrip.

Any ideas?

thanks

            <asp:LinqDataSource ID="LinqDataSource1" runat="server"
                ContextTypeName="TelerikEvalDbDataContext"
                Select="new (first_name, last_name)"
                TableName="contacts">
            </asp:LinqDataSource>

            <telerik:RadGrid ID="RadGrid1" runat="server" AllowFilteringByColumn="True"
                AllowPaging="True" AllowSorting="True" DataSourceID="LinqDataSource1"
                GridLines="None" ShowGroupPanel="True" Skin="Vista">
                <MasterTableView DataSourceID="LinqDataSource1">
                    <RowIndicatorColumn>
                        <HeaderStyle Width="20px" />
                    </RowIndicatorColumn>
                    <ExpandCollapseColumn>
                        <HeaderStyle Width="20px" />
                    </ExpandCollapseColumn>
                </MasterTableView>
                <ClientSettings AllowDragToGroup="True">
                </ClientSettings>
            </telerik:RadGrid>

9 Answers, 1 is accepted

answered on 23 Jul 2009, 08:04 AM

entityframeworkradgrid.zip

Hello Silver,

Please examine the attached test project which implements the described functionality. Depending on the given information the RadMultiPage and RadTabStrip are not connected with the issue.

Best wishes,
Georgi Krustev
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

Accepted

answered on 12 Oct 2009, 08:50 PM

This was happening with both paging via RadGrid (using either declarative LINQ DataSourceID and/or setting DataSource in OnNeedDataSource Event using LINQ) and also when retrieving additional data via RadComboBox using a web service. The Web Service uses a skip() and take() in the query. Both were generating errors when retrieving new data. Both scenarios using LINQ to SQL and SQL Server 2000 (Not happening with 2005). Both using a SQL Server View and generating a DataContext.

Error: "This provider supports skip() only over ordered queries returning entities or projections that contain all identity columns, where the query is a single-table (non-join) query or is a Distinct, Except, Insersect or Union (Not CONCAT) operation"
http://msdn.microsoft.com/en-us/library/bb386996.aspx

SOLUTION:
The problem here is that when using SQL Server 2000 and LINQ to SQL for paging (more precisely using the LINQ to SQL Skip() method), the LINQ to SQL DataContext requires that the Primary Key field be included in the query and that the DataContext Column definition have both the attributes IsPrimaryKey=true and the correct AutoSync enumeration (ie AutoSync="AutoSync.OnInsert"). Example: [Column (Storage="_ID", AutoSync="AutoSync.OnInsert", IsPrimaryKey=true, DbType="Int NOT NULL IDENTITY"....)].

I am using SQL Views and generated the DataContext by "dragging" the views onto the dbml designer. Although I have the PrimaryKey Column included in the views, the DataContext generated for the views did not automatically add the AutoSync and IsPrimaryKey attributes to the PrimaryKey columns.

Manually adding the attributes fixed the problem. Simple way was to select the column on the view in the ClassDesigner and using the properties tab set the Primary Key to true and AutoSync to appropriate enumeration (can do this in code with designer.cs manually as well).

Note that changes will be overwritten if the view is automatically regenerated again and above changes will need to be manually added again.