Dec 20, 2016, 4:55 AM
Filtering like Excel
I want to filtering like Excel:
Attachment 24798
And then I use ListFilter and Store
Attachment 24799
Have another way to do that or my code is wrong?
Visual Studio 2010 Pro
Ext.net 3.5
Windows 8 Pro
.net framework 4.5
Attachment 24798
And then I use ListFilter and Store
<ext:Store ID="Store_Inventory" runat="server">
<Model>
<ext:Model ID="Model1" runat="server" >
<Fields>
<ext:ModelField Name="Colour" />
</Fields>
</ext:Model>
</Model>
</ext:Store>
<ext:Store ID="Store_Filter" runat="server">
<Model>
<ext:Model ID="Model2" runat="server" >
<Fields>
<ext:ModelField Name="Colour" />
</Fields>
</ext:Model>
</Model>
</ext:Store>
<ext:GridPanel ID="GridPanel1" runat="server" StoreID="Store_Inventory" Title="" Width="" Height="600" AutoScroll="True" >
<ColumnModel ID="ColumnModel1" runat="server">
<Columns>
<ext:Column ID="Column3" runat="server" Header="Colour" Width="150" Sortable="true" DataIndex="Colour"/>
</Columns>
</ColumnModel>
<Features>
<ext:GridFilters runat="server" ID="GridFilters1" Local="true" Height="200">
<Filters>
<ext:ListFilter DataIndex = "Colour" StoreID="Store_Filter" LabelField="Colour" />
</Filters>
</ext:GridFilters>
</Features>
</ext:GridPanel>
Protected Sub ShowData()
Dim temp_string As String
temp_string = "SELECT * FROM [T - Inventory]"
HK_Pro.Open()
rd_select.Close()
Dim daTT As New SqlDataAdapter(temp_string, HK_Pro)
Dim dsTT As New Data.DataSet
dsTT.Clear()
daTT.Fill(dsTT, "dw")
Me.Store_Inventory.DataSource = dsTT
Me.Store_Inventory.DataMember = "dw"
Me.Store_Inventory.DataBind()
HK_Pro.Close()
End If
End Sub
Protected Sub Showfilter()
Dim temp_string As String
temp_string = "SELECT Colour FROM [T - Inventory] GROUP BY Colour"
HK_Pro.Open()
Dim daTT As New SqlDataAdapter(temp_string, HK_Pro)
Dim dsTT As New Data.DataSet
dsTT.Clear()
daTT.Fill(dsTT, "dw")
Me.Store_Filter.DataSource = dsTT
Me.Store_Filter.DataMember = "dw"
Me.Store_Filter.DataBind()
HK_Pro.Close()
But,it didn't work.Just show the colour list, when I select for filtering it's empty.Attachment 24799
Have another way to do that or my code is wrong?
Visual Studio 2010 Pro
Ext.net 3.5
Windows 8 Pro
.net framework 4.5