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

Elements not visible in the template filter of radcombobox

1 Answer 111 Views

Grid

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

TomShelby asked on 17 May 2019, 06:12 AM

Hi,

I have a RadGrid with a radcombobox for the filter template. In the ASPX code I have the following:

<telerik:GridTemplateColumn DataField="ID_Tipo" UniqueName="ID_Tipo"  

HeaderText="Tipo Usuario" DataType="System.string" FilterControlWidth="150px" SortExpression= "ID_Tipo"

 GroupByExpression="TipoUsuario Group by TipoUsuario"> <ItemTemplate> 

<%#DataBinder.Eval(Container.DataItem, "TipoUsuario")%> </ItemTemplate> 

<FilterTemplate> 

<telerik:RadComboBox ID="RCB_Filtro" Height="200px"<br

>                                    OnClientSelectedIndexChanged="TipoUsuarioIndexChanged"<

br> DataSourceID="SqlDataSource1" 

EnableAutomaticLoadOnDemand="True" 

CurrentFilterFunction="Contains" AutoPostBackOnFilter="True" 

AppendDataBoundItems="true" 

SelectedValue='<%# TryCast(Container, GridItem).OwnerTableView.GetColumn("Id_Tipo").CurrentFilterValue %>' 

DataTextField="TipoUsuario"

DataValueField="ID_tipoUsuario" 

runat="server" 

EnableLoadOnDemand="True"> 

<Items> 

<telerik:RadComboBoxItem Text="Todos" Value="" /> </Items> 

</telerik:RadComboBox> 

<telerik:RadScriptBlock ID="RadScriptBlock3" runat="server"> 

<script type="text/javascript"> 

function TipoUsuarioIndexChanged(sender, args) { 

var tableView = $find("<%# TryCast(Container, GridItem).OwnerTableView.ClientID %>"); 

if (args.get_item().get_value() == "Todos") { tableView.filter("ID_Tipo", args.get_item().get_value(), "NoFilter"); } 

else { 

tableView.filter("ID_Tipo", args.get_item().get_value(), "EqualTo"); } } 

</script> 

</telerik:RadScriptBlock> 

</FilterTemplate>

The radcombobox has an associated SQlDataSource:

<asp:SqlDataSource  runat="server" ID="SqlDataSource1" ConnectionString="<%$ ConnectionStrings:ApplicationServices %>"<br

>        ProviderName="System.Data.SqlClient" SelectCommand="SELECT [ID_tipoUsuario], [TipoUsuario] from [Tipos_usuario] ORDER By [TipoUsuario]"><

br> </asp:SqlDataSource>

But when I run the application, only the "All" item appears in the radcombobox. And when the "All" item is removed from the selection window, then the elements of the table are also loaded.

In the VB module there is no action defined for RadGrid_ItemDataBound or RadGrid_ItemCreated, since the load is done by SQLDataSource.

You can help me to see what is wrong or what I lack in the radcomobox definition. Thank you

1 Answer, 1 is accepted

answered on 17 May 2019, 11:06 AM

Hi,

Already solved. This must be the combobox.

<FilterTemplate> <telerik:RadComboBox ID="RCB_Filtro" Height="200px"<br

>                                    OnClientSelectedIndexChanged="TipoUsuarioIndexChanged"<

br> DataSourceID="SqlDataSource1" AutoPostBackOnFilter="True" AppendDataBoundItems="true"<br

>                                    SelectedValue='<%# TryCast(Container, GridItem).OwnerTableView.GetColumn("ID_Tipo").CurrentFilterValue %>'<

br

>                                    DataTextField="TipoUsuario" DataValueField="ID_tipoUsuario"<

br> runat="server" > <Items> <telerik:RadComboBoxItem Text="Todos" Value="" /> </Items> </telerik:RadComboBox> <telerik:RadScriptBlock ID="RadScriptBlock3" runat="server"> <script type="text/javascript"><br

>                                    function TipoUsuarioIndexChanged(sender, args) {<

br

>                                   var tableView = $find("<%# TryCast(Container, GridItem).OwnerTableView.ClientID %>");<

br

>                                    if (args.get_item().get_value() == "Todos") { tableView.filter("ID_Tipo", args.get_item().get_value(), "NoFilter");<

br> } else {<br

>                                   tableView.filter("ID_Tipo", args.get_item().get_value(), "EqualTo");<

br> } } </script> </telerik:RadScriptBlock> </FilterTemplate>