Please guide how to integrate ColumnFilter into wisej application

0
0

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

  • You must to post comments
0
0

Auto for all columm of ddataagrid use:

For Each col As Wisej.Web.DataGridViewColumn In DataGridView1.Columns
ColumnFilter1.SetShowFilter(col, True)
Next

 

  • You must to post comments
0
0

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

  • Nhan Nguyen
    Thanks, I did it. The problem is before you dump the data from the datasouce into the grid, run this command: DataGridView1.AutoGenerateColumns = False DataGridView1.Columns(“colname”).DataPropertyName = “name”
  • You must to post comments
0
0

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

  • Nhan Nguyen
    Thanks, I did it. The problem is before you dump the data from the datasouce into the grid, run this command: DataGridView1.AutoGenerateColumns = False DataGridView1.Columns(“colname”).DataPropertyName = “name”
  • You must to post comments
0
0

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

  • You must to post comments
0
0

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/

  • Nhan Nguyen
    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
  • Nhan Nguyen
    Thanks, I did it. The problem is before you dump the data from the datasouce into the grid, run this command: DataGridView1.AutoGenerateColumns = False DataGridView1.Columns(“colname”).DataPropertyName = “name”
  • You must to post comments
Showing 5 results
Your Answer

Please first to submit.