Filtering data befor a Combobox is loaded from a Store Object

[egodoy]

Hello,

Given the following HTML source, how can I filter out some values before loading the Xml data into the Combobox if the user cannot see some items from it?

<asp:XmlDataSource ID="XmlReferenceTablesDataSource1" runat="server" DataFile="ReferenceTables.xml"
    TransformFile="ReferenceTables.xsl"  />
<ext:Store ID="storeReferenceTableList" runat="server" OnRefreshData="Refresh_References"
    OnSubmitData="Store1_Submit" DataSourceID="XmlReferenceTablesDataSource1" 
    AutoLoad="true" ondatabound="storeReferenceTableList_DataBound">
    <AjaxEventConfig IsUpload="true" />
    <Reader>
 <ext:JsonReader>
     <Fields>
  <ext:RecordField Name="Name" />
  <ext:RecordField Name="Description" />
  <ext:RecordField Name="TableSchemaName" />
     </Fields>
 </ext:JsonReader>
    </Reader>
    <SortInfo Field="Name" Direction="ASC" />
</ext:Store>

...
...
<ext:ComboBox ID="tablescmbx1" runat="server" 
  StoreID="storeReferenceTableList" 
  Editable="false"
                DisplayField="Name" 
                ValueField="TableSchemaName" 
                TypeAhead="true" 
                Mode="Local"
                ForceSelection="true" 
                EmptyText="Select a table..." 
                Resizable="true" 
                Select&#111;nfocus="true" 
                TriggerAction="All">
     <AjaxEvents>   
 <Select OnEvent="tablescmbx1_Selected" ViewStateMode="Include">
     <ExtraParams>
   <ext:Parameter Name="TableName" Value="#{tablescmbx1}.getText()" Mode="Raw" /> 
     </ExtraParams>


 </Select>                        
      </AjaxEvents>
</ext:ComboBox>

If have tried the Store_DataBound and Store_DataBinding with no luck coming up with a good way to do this.

Thank you in advance,

[Vladimir]

Hi,

You can use XPath property of XmlDataSource to filter data. Here is some articles
http://www.c-sharpcorner.com/UploadF...a-d75a508362d8
http://www.beansoftware.com/ASP.NET-...e-Control.aspx


Or you can read xml file manually, filter data and set filtered result to the Data property of XmlDataSource*