函数协议（事件：事件）：无效
{
//您现有的code在这里
    VAR的dataProvider：DataProvider的= MyGrid.dataProvider为的DataProvider; //恢复数据提供器
    dataProvider.removeAll（）; //删除所有行
    对于（VAR X：INT = 0，X＆LT; loadedData.length; X ++）
    {
        如果（loadedData [X] ==选择匹配）//在此处插入您的选择标准
        {
           dataProvider.addItem（loadedData [X]）; //添加回dataProvider中
        }
    }
}
功能resetFilter（）：无效
{
    VAR的dataProvider：DataProvider的= MyGrid.dataProvider为的DataProvider; //恢复数据提供器
    dataProvider.removeAll（）; // prevent重复
    dataProvider.addItems（loadedData）; //重新加载所有行
}
 

第2节： mx.collections.ArrayCollection

我的推理推荐，这是因为的ArrayCollection 已经有这样做没有丢失的物体失去范围数据的风险的功能外，还降低了$量C $ C /操作，你需要做的。要做到这一点，我们使用 ArrayCollection.filterFunction 和放大器; ArrayCollection.refresh（）过滤看得见的阵列在不改变源代码。

 私人变种的dataProvider：ArrayCollection的=新ArrayCollection的（loadedData）;
MyGrid.dataProvider = dataProvider中;
功能协议（事件：事件）：无效
{
    //您现有的code在这里
    dataProvider.filterFunction = myFilterFunction; //使用我的过滤器
    dataProvider.refresh（）; //刷新列表中可见使用新的过滤器/排序
}
功能resetFilter（）：无效
{
    dataProvider.filterFunction = NULL; //清除过滤器
    dataProvider.refresh（）; //刷新列表中可见使用新的过滤器/排序
}
功能myFilterFunction（项目：对象）：布尔
{
    如果（项目==选择匹配）返回true; //此处插入您的选择标准
    否则返回false;
}
 

在的filterFunction接受功能，并用它来测试每个对象的的ArrayCollection ，该函数返回一个布尔值，真的是，显示该对象和假为不diplay。

I'm using 2 comboboxes to filter a dataGrid that has been populated via csv file. The first combobox filters the columns and works fine:

//Listener and function for when the Agreement ID is selected
agreement_cb.addEventListener(Event.CHANGE, agreement);
function agreement(event:Event):void 
{
    //get the number of columns 
    var columnCount:Number = myGrid.getColumnCount();

    for (var i:int=0; i<columnCount; i++)
    {
        myGrid.getColumnAt(i).visible = false;
    }
    var columnNumber:Number = agreement_cb.selectedItem.data;
    myGrid.getColumnAt(columnNumber).visible = true;
    myGrid.getColumnAt(0).visible = true;
    myGrid.columns[0].width = 200;
}

But I can't find anything on how to get the same type of function to hide all of the rows except the one they select from the second drop-down (codes_cb).

Any help is appreciated...

UPDATE:

loadedData = myLoader.data.split(/rn|n|r/);
    loadedData.pop();
    for (var i:int=0; i<loadedData.length; i++)
    {
        var rowArray:Array = loadedData[i].split(",");
        loadedData[i] = {"SelectAgreement":rowArray[0],"KSLTPROF0057":rowArray[1] .........};
    }
    loadedData.shift();
    myGrid.columns = ["SelectAgreement", "KSLTPROF0057", ......];

    import fl.data.DataProvider;
    import fl.controls.dataGridClasses.DataGridColumn;

    myGrid.dataProvider = new DataProvider(loadedData);

A DataGrid always shows all objects in its dataProvider, so to hide rows, you need to hide the data objects. Some classes that work as dataProviders have this functionality built in that makes this really easy (Any Class that implements IList can be operate as a dataProvider), however fl.data.DataProvider is not one of those classes.

So I will provide answers using both, if you can, I highly recommend using mx.collections.ArrayCollection over fl.data.DataProvider.

Section 1: fl.data.DataProvider

For this I'm assuming that your loadedData array is a class property, not declared in a function.

function agreement(event:Event):void 
{
//your existing code here
    var dataProvider:DataProvider = MyGrid.dataProvider as DataProvider;//recover the dataprovider
    dataProvider.removeAll();//remove all rows
    for (var x:int = 0; x<loadedData.length; x++)
    {
        if (loadedData[x] == "SELECTION MATCH") //insert here your selection criteria
        {
           dataProvider.addItem(loadedData[x]); //add it back into the dataProvider
        }
    }
}
function resetFilter():void
{
    var dataProvider:DataProvider = MyGrid.dataProvider as DataProvider;//recover the dataprovider
    dataProvider.removeAll(); //prevent duplication
    dataProvider.addItems(loadedData);//reload all rows
}

Section 2: mx.collections.ArrayCollection

My reasoning for recommending this is because ArrayCollection already has the functions to do this without the risk of data being lost by objects losing scope, it also reduces the amount of code/operations you need to do. To do this we use ArrayCollection.filterFunction & ArrayCollection.refresh() to filter the "visible array" without changing the source.

private var dataProvider:ArrayCollection = new ArrayCollection(loadedData);
MyGrid.dataProvider = dataProvider;
function agreement(event:Event):void
{
    //your existing code here
    dataProvider.filterFunction = myFilterFunction;//use my filter
    dataProvider.refresh();//refresh the visible list using new filter/sort
}
function resetFilter():void
{
    dataProvider.filterFunction = null;//clear filter
    dataProvider.refresh();//refresh the visible list using new filter/sort
}
function myFilterFunction(item:Object):Boolean
{
    if (item == "SELECTION MATCH") return true;//insert your selection criteria here        
    else return false;
}

the filterFunction accepts a function and uses it to test each object in the ArrayCollection, the function has to return a Boolean, true for "Yes, display this object" and false for "Do not diplay".