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

RadGrid bug on filtering with EntityDataSource

1 Answer 102 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Vlad
Top achievements
Rank 1
Vlad asked on 05 Mar 2015, 08:14 PM
wherever I try to filter a bounded column with RadGrid I get the following error:

"Could not resolve 'COLUMN NAME' in scope or current context. Check
that all referenced variables are in scope, if required schemes were
loaded and references to namespaces are correct. Next simple identifier,
line 6, column 3."

My page's code is:

<%@ Page Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="VerOcorrencias.aspx.cs" Inherits="DuctorWebSite.OuvidoriaPages.VerOcorrencias" %>
 
<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
 
<asp:Content ID="BodyContent" ContentPlaceHolderID="MainContent" runat="server">
    <meta http-equiv='cache-control' content='no-cache'>
    <meta http-equiv='expires' content='0'>
    <meta http-equiv='pragma' content='no-cache'>
 
    <link href="../Content/OuvidoriaPages.css" rel="stylesheet" />
 
    <div class="container-full">
        <h2>Lista de ocorrĂȘncias</h2>
 
        <telerik:RadGrid ID="RadGrid1" runat="server" DataSourceID="EntityDataSource1"
            RenderMode="Auto" Culture="pt-BR" Skin="Metro"
            AllowAutomaticDeletes="True" AllowFilteringByColumn="True" AllowPaging="True"
            AutoGenerateColumns="False" OnItemCommand="RadGrid1_ItemCommand" EnableLinqExpressions="False" GroupPanelPosition="Top">
 
            <ExportSettings>
                <Pdf PageWidth="">
                </Pdf>
            </ExportSettings>
 
            <MasterTableView DataSourceID="EntityDataSource1" DataKeyNames="OUV_Id" PageSize="25">
 
                <EditFormSettings>
                    <EditColumn UniqueName="EditCommandColumn" CancelText="Cancelar" EditText="Editar" UpdateText="Confirmar" ButtonType="ImageButton" CancelImageUrl="../Images/icons/cancelar.png"
                        UpdateImageUrl="../Images/icons/ok.png">
                    </EditColumn>
                </EditFormSettings>
 
                <Columns>
                    <telerik:GridButtonColumn CommandName="Editar" Text="Editar resposta" UniqueName="EditCommandColumn" ButtonType="ImageButton" ImageUrl="../Images/icons/editar.png" Resizable="False">
                        <ItemStyle Width="41px" />
                    </telerik:GridButtonColumn>
 
                    <telerik:GridButtonColumn CommandName="Delete" Text="Apagar mensagem inteira" UniqueName="DeleteColumn" ConfirmText="VocĂȘ tem certeza que quer apagar essa mensagem?" ConfirmDialogType="RadWindow" ConfirmDialogHeight="25px" HeaderStyle-Width="15px" ItemStyle-Width="15px"
                        ButtonType="ImageButton" ImageUrl="../Images/icons/apagar.png">
                        <HeaderStyle Width="15px" />
                        <ItemStyle Width="41px" />
                    </telerik:GridButtonColumn>
 
                    <telerik:GridBoundColumn DataField="OUV_Id" DataType="System.Int32" Display="False" FilterControlAltText="Filter OUV_Id column" HeaderText="OUV_Id" ReadOnly="True" SortExpression="OUV_Id" UniqueName="OUV_Id" Visible="False" Resizable="False">
                        <ColumnValidationSettings>
                            <ModelErrorMessage Text="" />
                        </ColumnValidationSettings>
                        <ItemStyle Width="41px" />
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="OUV_DtdRegistro" DataType="System.DateTime" FilterControlAltText="Filter OUV_DtdRegistro column" HeaderText="<b>DATA REGISTRO</b>" SortExpression="OUV_DtdRegistro" UniqueName="OUV_DtdRegistro" ReadOnly="True" DataFormatString="{0:dd/MM/yyyy}" Resizable="False">
                        <ColumnValidationSettings>
                            <ModelErrorMessage Text="" />
                        </ColumnValidationSettings>
                        <ItemStyle Width="50px" />
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="OUV_Protocolo" DataType="System.Double" FilterControlAltText="Filter OUV_Protocolo column" HeaderText="<b>PROTOCOLO</b>" SortExpression="OUV_Protocolo" UniqueName="OUV_Protocolo" ReadOnly="True" Resizable="False">
                        <ColumnValidationSettings>
                            <ModelErrorMessage Text="" />
                        </ColumnValidationSettings>
                        <ColumnValidationSettings>
                            <ModelErrorMessage Text="" />
                        </ColumnValidationSettings>
                        <ItemStyle Width="30px" />
                    </telerik:GridBoundColumn>
                    <telerik:GridCalculatedColumn DataFields="OUV_Nome,OUV_Email,OUV_Telefone" FilterControlAltText="Filter column column" UniqueName="column" Expression="OUV_Nome + '<br/>' + OUV_Email + '<br/>' + OUV_Telefone" HeaderText="<b>IDENTIFICAÇÃO</b>" Resizable="False">
                        <FooterStyle Width="100px" />
                        <ItemStyle Width="80px" />
                    </telerik:GridCalculatedColumn>
                    <telerik:GridBoundColumn DataField="OUV_Mensagem" FilterControlAltText="Filter OUV_Mensagem column" HeaderText="<b>MENSAGEM</b>" SortExpression="OUV_Mensagem" UniqueName="OUV_Mensagem" ReadOnly="True" Resizable="False" MaxLength="150">
                        <ColumnValidationSettings>
                            <ModelErrorMessage Text="" />
                        </ColumnValidationSettings>
                        <FooterStyle Width="500px" />
                        <ItemStyle Width="250px" />
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="OUV_DtdResposta" DataType="System.DateTime" FilterControlAltText="Filter OUV_DtdResposta column" HeaderText="<b>DATA RESPOSTA</b>" SortExpression="OUV_DtdResposta" UniqueName="OUV_DtdResposta" ReadOnly="True" DataFormatString="{0:dd/MM/yyyy}" Resizable="False">
                        <ColumnValidationSettings>
                            <ModelErrorMessage Text="" />
                        </ColumnValidationSettings>
                        <ItemStyle Width="30px" />
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="OUV_Resposta" FilterControlAltText="Filter OUV_Resposta column" HeaderText="<b>RESPOSTA</b>" SortExpression="OUV_Resposta" UniqueName="OUV_Resposta" Resizable="False" MaxLength="150">
                        <ColumnValidationSettings>
                            <ModelErrorMessage Text="" />
                        </ColumnValidationSettings>
                        <ItemStyle Width="250px" Wrap="True" />
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="OUV_Nome" FilterControlAltText="Filter OUV_Nome column" HeaderText="OUV_Nome" SortExpression="OUV_Nome" UniqueName="OUV_Nome" Display="False" ReadOnly="True" Visible="False">
                        <ColumnValidationSettings>
                            <ModelErrorMessage Text="" />
                        </ColumnValidationSettings>
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="OUV_Email" FilterControlAltText="Filter OUV_Email column" HeaderText="OUV_Email" SortExpression="OUV_Email" UniqueName="OUV_Email" Display="False" ReadOnly="True" Visible="False">
                        <ColumnValidationSettings>
                            <ModelErrorMessage Text="" />
                        </ColumnValidationSettings>
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="OUV_Telefone" FilterControlAltText="Filter OUV_Telefone column" HeaderText="OUV_Telefone" SortExpression="OUV_Telefone" UniqueName="OUV_Telefone" Display="False" ReadOnly="True" Visible="False">
                        <ColumnValidationSettings>
                            <ModelErrorMessage Text="" />
                        </ColumnValidationSettings>
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="OUV_ChaveLoc" Display="False" FilterControlAltText="Filter OUV_ChaveLoc column" HeaderText="OUV_ChaveLoc" SortExpression="OUV_ChaveLoc" UniqueName="OUV_ChaveLoc" Visible="False" ReadOnly="True">
                        <ColumnValidationSettings>
                            <ModelErrorMessage Text="" />
                        </ColumnValidationSettings>
                    </telerik:GridBoundColumn>
                    <telerik:GridCheckBoxColumn DataField="OUV_Ativo" DataType="System.Boolean" Display="False" FilterControlAltText="Filter OUV_Ativo column" HeaderText="OUV_Ativo" SortExpression="OUV_Ativo" UniqueName="OUV_Ativo" Visible="False" ReadOnly="True">
                    </telerik:GridCheckBoxColumn>
                    <telerik:GridBoundColumn DataField="OUV_idCAT" Display="False" FilterControlAltText="Filter OUV_idCAT column" HeaderText="OUV_idCAT" SortExpression="OUV_idCAT" UniqueName="OUV_idCAT" Visible="False" ReadOnly="True">
                        <ColumnValidationSettings>
                            <ModelErrorMessage Text="" />
                        </ColumnValidationSettings>
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="CAT_Descr" Display="False" FilterControlAltText="Filter CAT_Descr column" HeaderText="CAT_Descr" SortExpression="CAT_Descr" UniqueName="CAT_Descr" Visible="False" ReadOnly="True">
                        <ColumnValidationSettings>
                            <ModelErrorMessage Text="" />
                        </ColumnValidationSettings>
                    </telerik:GridBoundColumn>
                </Columns>
                <PagerStyle Position="TopAndBottom" />
            </MasterTableView>
 
 
            <FilterMenu RenderMode="Mobile">
            </FilterMenu>
            <HeaderContextMenu RenderMode="Mobile">
            </HeaderContextMenu>
 
        </telerik:RadGrid>
 
    </div>
    <asp:EntityDataSource ID="EntityDataSource1" runat="server" ConnectionString="name=DuctorWebSiteEntities"
        DefaultContainerName="DuctorWebSiteEntities" EnableDelete="True" EnableFlattening="False" EntitySetName="Ouvidoria" OrderBy="it.OUV_DtdRegistro Desc" EntityTypeFilter="Ouvidoria">
    </asp:EntityDataSource>
</asp:Content>
I need some help, thanks.

1 Answer, 1 is accepted

Sort by
0
Pavlina
Telerik team
answered on 10 Mar 2015, 05:36 PM
Hi,

What happens if you set EnableLinqExpressions property to true? Also make sure that you are using the latest Telerik UI version in your application.

Regards,
Pavlina
Telerik
 

Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

 
Tags
Grid
Asked by
Vlad
Top achievements
Rank 1
Answers by
Pavlina
Telerik team
Share this question
or