I use Wisej version 3.5 with integrated ColumnFilter version 3.5.17. However, when using the ColumnFilter control, I do not see the columnFilter item.DataGridView = DataGridView1 or similar. Attached image.
I use vb.net language. sql server to load data like this:
strSQL = ” Select * FROM Customer WHERE dvcs = ‘” & Mdvcs & “‘”
Dim cmd As New SqlCommand(strSQL, Sqlcon)
da = New SqlDataAdapter(cmd)
ds = New DataSet
da.Fill(ds, “Customer “)
DataGridView1.DataSource = ds.Tables(0)
I want the columns when loaded into gridview to be filterable.. Please help me
Auto for all columm of ddataagrid use:
For Each col As Wisej.Web.DataGridViewColumn In DataGridView1.Columns
ColumnFilter1.SetShowFilter(col, True)
Next
For databound DataGridViews use the functions Fill/Append instead of assigning a DataSource:
https://docs.wisej.com/docs/controls/lists/datagridview#append-and-fill
Best regards
Frank
Here’s a simple example running in Wisej 3.5
Click on the search icon in the middle column to filter it.
Note that if you examine columnFilter1 (from the designer) in the properties window, you can see how the properties are set up. The ImageSource is set to icon-search (which is why you see a search icon in the column). The FilterPanelType is set to SimpleColumnFilter. SimpleColumnFilter just shows a list of all possible values to filter by (in this case “ITG”, “Google”, and “Microsoft”).
Hope this helps,
Julie
I tried my best to follow the instructions but it keeps giving errors and can’t work, the sample source you shared doesn’t run on my local machine. Can you guide me with a simple example running on wisej 3.5
ColumnFilter documentation: https://docs.wisej.com/extensions/extensions/columnfilter
Here is a VB.NET sample using ColumnFilter: https://github.com/iceteagroup/wisej-examples-vb/tree/3.5/ColumnFilter
This blog explains how to use ColumnFilter: https://wisej.com/blog/columnfilter/
Please login first to submit.