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

filtering a column

7 Answers 174 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Minh
Top achievements
Rank 1
Minh asked on 08 Aug 2011, 04:36 AM
Hi,

while filtering a combox column within an item template, i received the following runtime error. This only happens on the radgrid combox column.

Microsoft JScript runtime

error: Sys.WebForms.PageRequestManagerServerErrorException: is neither a DataColumn nor a DataRelation for table DefaultView.

 


thanks,
Minh Bui

7 Answers, 1 is accepted

Sort by
0
Shinu
Top achievements
Rank 2
answered on 08 Aug 2011, 04:59 AM
Hello Minh,

Try setting DataField property to the DropDownColumn.
<telerik:GridDropDownColumn DataField="Name" UniqueName="Name" HeaderText="Name">
</telerik:GridDropDownColumn>

Thanks,
Shinu.
0
Minh
Top achievements
Rank 1
answered on 08 Aug 2011, 05:02 AM

I'm using the RadComboBox...

 

<telerik:GridTemplateColumn UniqueName="AreaName" HeaderText="Area"  

SortExpression="AreaName" ItemStyle-Width="150px">  

<FooterTemplate>  

Template footer 

</FooterTemplate>  

<FooterStyle VerticalAlign="Middle" HorizontalAlign="Center" />  

<ItemTemplate>  

<%#DataBinder.Eval(Container.DataItem, "AreaName")%> 

</ItemTemplate<EditItemTemplate>  

<telerik:RadComboBox runat="server" ID="RadComboBox1" EnableLoadOnDemand="True" DataTextField="AreaName" 

OnItemsRequested="RadComboBox1_ItemsRequested" DataValueField="ID" AutoPostBack="true"  

HighlightTemplatedItems="true" Height="140px" Width="100px" DropDownWidth="120px"

OnSelectedIndexChanged="ComboBox1_OnSelectedIndexChangedHandler">  

<ItemTemplate> <%# DataBinder.Eval(Container, "Text")%>  

</ItemTemplate>

</telerik:RadComboBox>

</EditItemTemplate>

<HeaderStyle Width="100px" />

<ItemStyle Width="100px"></ItemStyle>

</telerik:GridTemplateColumn>

 

0
Jayesh Goyani
Top achievements
Rank 2
answered on 08 Aug 2011, 06:54 AM
Hello,

Please elaborate your scenario.

Thanks,
Jayesh Goyani
0
Minh
Top achievements
Rank 1
answered on 08 Aug 2011, 07:00 AM

...While the grid was running on a webpage, I tried to use the filter on 1 of the radgridcombox column. It threw an error and and stopped on the 'throw error line' below...the attached file contains the JScript runtime error.


function

 

 

Sys$WebForms$PageRequestManager$_endPostBack(error, executor, data) {

 

 

 

if (this._request === executor.get_webRequest()) {

 

 

 

this._processingRequest = false;

 

 

 

this._additionalInput = null;

 

 

 

this._request = null;

 

}

 

 

var handler = this._get_eventHandlerList().getHandler("endRequest");

 

 

 

var errorHandled = false;

 

 

 

if (handler) {

 

 

 

var eventArgs = new Sys.WebForms.EndRequestEventArgs(error, data ? data.dataItems : {}, executor);

 

handler(

 

this, eventArgs);

 

errorHandled = eventArgs.get_errorHandled();

}

 

 

if (error && !errorHandled) {

 

 

 

throw error;

 

}

0
Sebastian
Telerik team
answered on 08 Aug 2011, 11:17 AM
Hello Minh,

To enable built-in filtering for template columns, you need to set DataField for them which matches the name of the underlying source field (see this demo for reference). Hence alter your template column definition as follows:
<telerik:GridTemplateColumn UniqueName="AreaName" DataField="AreaName" HeaderText="Area" 
  
SortExpression="AreaName" ItemStyle-Width="150px"
  
<FooterTemplate
  
Template footer
  
</FooterTemplate
  
<FooterStyle VerticalAlign="Middle" HorizontalAlign="Center" /> 
  
<ItemTemplate
  
<%#DataBinder.Eval(Container.DataItem, "AreaName")%>
  
</ItemTemplate> <EditItemTemplate
  
<telerik:RadComboBox runat="server" ID="RadComboBox1" EnableLoadOnDemand="True" DataTextField="AreaName"
  
OnItemsRequested="RadComboBox1_ItemsRequested" DataValueField="ID" AutoPostBack="true" 
  
HighlightTemplatedItems="true" Height="140px" Width="100px" DropDownWidth="120px"
 
OnSelectedIndexChanged="ComboBox1_OnSelectedIndexChangedHandler"
  
<ItemTemplate> <%# DataBinder.Eval(Container, "Text")%> 
  
</ItemTemplate>
 
</telerik:RadComboBox>
 
</EditItemTemplate>
 
<HeaderStyle Width="100px" />
 
<ItemStyle Width="100px"></ItemStyle>
 
</telerik:GridTemplateColumn>


Regards,
Sebastian
the Telerik team

Browse the vast support resources we have to jump start your development with RadControls for ASP.NET AJAX. See how to integrate our AJAX controls seamlessly in SharePoint 2007/2010 visiting our common SharePoint portal.

0
Minh
Top achievements
Rank 1
answered on 08 Aug 2011, 12:02 PM

Hi,

my code is exactly as was described within the suggestion.

 

 

 

<telerik:GridTemplateColumn UniqueName="AreaName" HeaderText="Area"  

SortExpression="AreaName" ItemStyle-Width="150px">  

<FooterTemplate

Template footer

</FooterTemplate>

<FooterStyle VerticalAlign="Middle" HorizontalAlign="Center" />

<ItemTemplate>

<%

#DataBinder.Eval(Container.DataItem, "AreaName")%>

</ItemTemplate>

<EditItemTemplate>

<telerik:RadComboBox runat="server" ID="RadComboBox1" EnableLoadOnDemand="True" DataTextField="AreaName"

OnItemsRequested="RadComboBox1_ItemsRequested" DataValueField="ID" AutoPostBack="true"

HighlightTemplatedItems="true" Height="140px" Width="100px" DropDownWidth="120px"

OnSelectedIndexChanged="ComboBox1_OnSelectedIndexChangedHandler">

<ItemTemplate>

<%# DataBinder.Eval(Container, "Text")%>

</ItemTemplate>

</telerik:RadComboBox>

 </EditItemTemplate>

<HeaderStyle Width="100px" />  

<ItemStyle Width="100px"></ItemStyle>

 

 

</telerik:GridTemplateColumn>

 

0
Accepted
Jayesh Goyani
Top achievements
Rank 2
answered on 08 Aug 2011, 12:08 PM
Hello Minh,

please add DataField and let me know if any concern.

<telerik:GridTemplateColumn UniqueName="AreaName" HeaderText="Area"  

SortExpression="AreaName" ItemStyle-Width="150px"
DataField="AreaName"


If this is not your case then send screenshot/Image and explain what you want and what is your issue in this screenshot/Image.

Thanks,
Jayesh Goyani
Tags
Grid
Asked by
Minh
Top achievements
Rank 1
Answers by
Shinu
Top achievements
Rank 2
Minh
Top achievements
Rank 1
Jayesh Goyani
Top achievements
Rank 2
Sebastian
Telerik team
Share this question
or