filtering radgrid with dropdown

[MBEN]

I have a radgrid in which I create a table and assign it to the Controls for an item in the Itemdatabound event as below.
I want to filter the PayoutType column based on a given list (ex , Retirement, Termination, Withdrawal). The table cell can any number of these values for one row. But since it is not bound to a database column I am unable to filter it.

Could you tell me how I can fiter in this scenario?

protected void rgPayoutElections_ItemDataBound(object sender, GridItemEventArgs e)

    {

        if (e.Item is GridDataItem)

        {

            GridDataItem item = e.Item as GridDataItem;

            int accountID = Int32.Parse(item.GetDataKeyValue("AccountID").ToString());

            DataRow[] dr = PayoutElection.GetPayouts_ByAccount_ListByParticipant(Int32.Parse(Profile.ParticipantID), accountID);

             

            Table tblPayoutType = new Table();

            foreach (DataRow row in dr)

            {

                TableRow trPayoutType = new TableRow();

 

                TableCell cellPayoutType = new TableCell();

                cellPayoutType.Text = row["PayoutType"].ToString();

                cellPayoutType.CssClass = "textRed";

                trPayoutType.Cells.Add(cellPayoutType);

                tblPayoutType.Rows.Add(trPayoutType);           

            }

            item["PayoutType"].Controls.Add(tblPayoutType);

       }

    }



[Andrey]

Hello,

I am not sure that I understand correctly what your requirement is. From the code you have shared I see that you add a Table control to the controls collection of each row in RadGrid. However, in order to filter the Grid you need to use some input control. The Table control is not an input control.

Based on the title of the thread, I assume that you will use dropdown control. Where the dropdown control will be located? You could hook the SelectedIndexChanged event of the dropdown control and in its body you could change the filter expression of the MasterTableView and thus you will achieve your goal.

You could check this online demo application which demonstrates similar approach. Another approach is shown in this online demo application.

Kind regards,
Andrey
the Telerik team