Google Like Filtering to nested grid

[Rahul]

Hello All,
    I have used three level hierarchy of grid in my webisite. I want google like filtering to inner two grid in the hierarchy. Can you provide me any sample. How should i do google like filtering to inner grid.

Thanks
Rahul

[Princy]

Hi Rahul,

In the PreRender event you can access the NestedTableView and then clear the columns to add the custom filtering column . I have made use of the code snippet in the help document  http://www.telerik.com/help/aspnet-ajax/grdtraversingdetailtablesitemsingrid.html

C#

protected void  RadGrid1_PreRender(object sender, EventArgs e)
     {
         foreach (GridDataItem dataItem in RadGrid1.MasterTableView.Items) {
             if (dataItem.Expanded) {
                 GridTableView gridTableView = (GridTableView)dataItem.ChildItem.NestedTableViews[0];
                 gridTableView.Columns.Clear();
                 foreach (DataColumn dataColumn in ds.Tables[0].Columns)
               {
                     RadGrid.MyCustomFilteringColumn gridColumn = new RadGrid.MyCustomFilteringColumn();

                     gridColumn.DataField = dataColumn.ColumnName;
                     gridColumn.HeaderText = dataColumn.ColumnName;
                     gridTableView.Columns.Add(gridColumn);
                 }
                 gridTableView.Rebind();
             }
         }


     }

Thanks,
Princy

[Princy]

Hi Rahul,

In the PreRender event you can access the NestedTableView and then clear the columns to add the custom filtering column . I have made use of the code snippet in the help document  http://www.telerik.com/help/aspnet-ajax/grdtraversingdetailtablesitemsingrid.html

C#

protected void  RadGrid1_PreRender(object sender, EventArgs e)
     {
         foreach (GridDataItem dataItem in RadGrid1.MasterTableView.Items) {
             if (dataItem.Expanded) {
                 GridTableView gridTableView = (GridTableView)dataItem.ChildItem.NestedTableViews[0];
                 gridTableView.Columns.Clear();
                 foreach (DataColumn dataColumn in ds.Tables[0].Columns)
               {
                     RadGrid.MyCustomFilteringColumn gridColumn = new RadGrid.MyCustomFilteringColumn();

                     gridColumn.DataField = dataColumn.ColumnName;
                     gridColumn.HeaderText = dataColumn.ColumnName;
                     gridTableView.Columns.Add(gridColumn);
                 }
                 gridTableView.Rebind();
             }
         }


     }

Thanks,
Princy

[Princy]

  

[Rahul]

Hi Princy
  When i click on the link provided by you it cannot find the page.

  One more thing
  I have have write the code on "GridDetailTableDataBindEventArgs" event of the RadGrid and implement google like filtering in that
  function. When i click on the combo box it gives me following error.

  The target 'ctl00$ContentPlaceHolder1$RadGrid1$ctl00$ctl06$Detail10$ctl02$ctl02$RadComboBox1fname' for the callback could not be found or did not implement ICallbackEventHandler.

 I have used following code.

  protected void DetailsBinding(object source, Telerik.Web.UI.GridDetailTableDataBindEventArgs e)
        {

            GridDataItem dataItem = (GridDataItem)e.DetailTableView.ParentItem;
            switch (e.DetailTableView.Name)
            {
                case "ABC":
                    {
                        //string CustomerID = dataItem.GetDataKeyValue("ConsultID").ToString();
                        DataTable dt = GetPatientDataTable();
                        foreach (DataColumn dataColumn in dt.Columns)
                        {

                            if (dataColumn.ColumnName != "Edit" && dataColumn.ColumnName != "Details" && dataColumn.ColumnName != "Status")
                            {

                                MyCustomFilteringColumnCS gridColumn = new MyCustomFilteringColumnCS();
                                //this.consultantgrid.MasterTableView.Columns.Add(gridColumn);
                                //RadGrid1.MasterTableView.Columns.Add(gridColumn);
                                e.DetailTableView.Columns.Add(gridColumn);
                                gridColumn.DataField = dataColumn.ColumnName;
                                gridColumn.HeaderText = dataColumn.ColumnName;
                                gridColumn.ShowSortIcon = false;
                                gridColumn.AllowFiltering = true;
                             
                            }
                        }

                        e.DetailTableView.DataSource = dt.DefaultView;
                        break;
                    }

                case "PQR":
                    {
                        // string OrderID = dataItem.GetDataKeyValue("ConsultID").ToString();
                        e.DetailTableView.DataSource = GetPatientDataTable();
                        break;
                    }
            }

                   }


Please help me. I will try the above code and get back to you.

  Thanks
   Rahul

[Rahul]

Hi Princy,
 I have tried code given by you. When i click on combo box to display filtering it displays only loading.... When i try to debug then
it dose not go to "list_ItemsRequested" function in "MyCustomFilteringColumnCS" class file..

Help me..?

Thanks
Rahul