Filtering Problem

[Cristian]

Hi im trying to add filtering to my grid, I set the allowfilteringByColumn property to true and when I put a field to filter and push enter the grid is not visible and is a line instead.I'm filling my grid with this store procedure

private void llenagridBaja()
       {
           try
           {
               var SSEGUAEntities = new BD_SSEGUAEntities();
               var resultado = SSEGUAEntities.spBajaEmpleado1();
               if (resultado != null)
               {
                   RadGrid2.DataSource = resultado;

               }
           }
           catch (Exception ex)
           {
               Alerta(ex.Message);
           }
           RadGrid2.Visible = true;
           RadGrid2.ShowFooter = true;
       }

And this is the aspx code of my grid

<telerik:RadGrid ID="RadGrid2" runat="server" AutoGenerateColumns="False"
                                GridLines="None" Skin="Sunset" onitemdatabound="RadGrid2_ItemDataBound"
                                AllowPaging="True" AllowSorting="True" onitemcommand="RadGrid2_ItemCommand"
                                onpageindexchanged="RadGrid2_PageIndexChanged"
                                onselectedindexchanged="RadGrid2_SelectedIndexChanged"
                                AllowFilteringByColumn="True" >
                                <ClientSettings EnablePostBackOnRowClick="True">
                                    <Selecting AllowRowSelect="True" />
                                </ClientSettings>
<MasterTableView>
<CommandItemSettings ExportToPdfText="Export to Pdf"></CommandItemSettings>

<RowIndicatorColumn>
<HeaderStyle Width="20px"></HeaderStyle>
</RowIndicatorColumn>

<ExpandCollapseColumn>
<HeaderStyle Width="20px"></HeaderStyle>
</ExpandCollapseColumn>
    <Columns>
        <telerik:GridBoundColumn DataField="fiCircuito" HeaderText="Circuito"
            UniqueName="columnCirc">
            <HeaderStyle HorizontalAlign="Center" />
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="nom_edo" HeaderText="Estado"
            UniqueName="columnEdo">
            <HeaderStyle HorizontalAlign="Center" />
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="nom_cd" HeaderText="Ciudad"
            UniqueName="columnCd">
            <HeaderStyle HorizontalAlign="Center" />
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="fiIdSolicitud" HeaderText="Folio"
            UniqueName="columnFolio" >
            <HeaderStyle HorizontalAlign="Center"  />
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="nom_padre"
            HeaderText="Nombre Madre/Padre" UniqueName="columnPadre">
            <HeaderStyle HorizontalAlign="Center" />
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="nom_menor" HeaderText="Nombre del Menor"
            UniqueName="column1">
            <HeaderStyle HorizontalAlign="Center" />
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn
            UniqueName="columnIdM" DataField="fiIdMenor" Visible="False">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn HeaderText="Fecha" UniqueName="column4"
            DataField="fech_baja">
            <HeaderStyle HorizontalAlign="Center" />
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="ind_baja" HeaderText="Estatus Empleado"
            UniqueName="columnEstatus">
            <HeaderStyle HorizontalAlign="Center" />
        </telerik:GridBoundColumn>
        <telerik:GridButtonColumn ButtonType="ImageButton" HeaderText="Avisos"
            UniqueName="column2"  ImageUrl= "~/imgs/new-message-icon.png"
            CommandName="Avisos">
            <HeaderStyle HorizontalAlign="Center" />
        </telerik:GridButtonColumn>
        <telerik:GridButtonColumn ButtonType="ImageButton"
            HeaderText="Actualiza Estado" UniqueName="column3"
            ImageUrl="~/imgs/refresh_document-icon.gif" CommandName="Actualiza">
            <HeaderStyle HorizontalAlign="Center" />
        </telerik:GridButtonColumn>
         <telerik:GridBoundColumn HeaderStyle-HorizontalAlign="Center"
                                            HeaderText="Estatus"  DataField="fcDescEdoSol"
                                            UniqueName="fcDescEdoSol" Visible="False">
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
                                        </telerik:GridBoundColumn>

                                          <telerik:GridBoundColumn HeaderText="Adscripción Actual"
            UniqueName="columnAdscAct" DataField="area_Nueva" Visible="false">
            <HeaderStyle HorizontalAlign="Center"  />
        </telerik:GridBoundColumn>

         <telerik:GridBoundColumn HeaderStyle-HorizontalAlign="Center"
                                            HeaderText="Expediente "  DataField="fiExpEmpleado"
                                            UniqueName="EXPEDIENTE" Visible="False">
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
                                        </telerik:GridBoundColumn>

    </Columns>
</MasterTableView>
                            </telerik:RadGrid>

Hope you could help me

I try adding a RadFilter and I have the same problem

[Shinu]

Hello Cristian,

The issue occures because you are binding the grid using Simple data binding technique. If you are using any advanced feature in grid(like paging), then a better approach is binding RadGrid using "AdvancedData binding" using NeedDataSource event.

For more information about this can be available here.
Advanced Data-binding (using NeedDataSource event).
Grid / Advanced Data Binding.

Thanks,
Shinu.

[Cristian]

Thanks shinu problem solved with NeedDataSource Event