Listbox : setting true or false for checkbox using code take time

Garry

Yes. If the columns are always the same, you can set them up in the Window Designer’s Column Headers editor, or directly in code:

p_listbox.ColumnCount = 3
p_listbox.HasHeaders = True
p_listbox.SetHeaderText(0, "Reference")
p_listbox.SetHeaderText(1, "Name")
p_listbox.SetHeaderText(2, "Date")

That gives you an empty ListBox with headings, without running a database query. You can load the records later when needed.

If the columns change depending on the SQL, you can read the column names from the empty RecordSet returned by your existing LIMIT 0 query:

p_listbox.ColumnCount = rs.ColumnCount
p_listbox.HasHeaders = True

For i As Integer = 0 To rs.ColumnCount - 1
    p_listbox.SetHeaderText(i, rs.ColumnName(i))
Next

rs.Close()

Here, rs is the result of your query. You do not need to call MoveToNextRow() to read those column names.

Could you post the SQL statement, which database you are using, and roughly how long the headings take to appear? I’d like to check where that delay is coming from before recommending a different query.

Richard_And_Trisha

p_listbox.RemoveAllRows()
p_listbox.ColumnCount = rs.ColumnCount - 1
p_listbox.ColumnSortable = True
p_listbox.GridLinesVisible = True

# Skip column 0 because it is the database ID stored in RowTag.
For c As Integer = 1 To rs.ColumnCount - 1
  p_listbox.SetHeaderText(c - 1, rs.ColumnName(c))
Next

p_listbox.ColumnTextAlignment(0) = TextAlignment.Centre
p_columnwidths = p_columnwidths.Replace("x", "%")
p_listbox.ColumnWidths = p_columnwidths

'code to check for LIMIT 0 in sql and don't do the insert row

p_listbox.FrozenColumnCount = 2 # ISSUE : does not work correctly, column 1 does not freeze
p_listbox.SelectionMode = "Multiple"

do you think I need to set the selection mode and frozencolumncount or even p_listbox.ColumnSortable when just show the column header

I found out I was filling up combobox from the data file, so adjust code to only fill the combobox when click on FocusReceived() for the various combobox and only if nothing is in the combobox. once it is filled, just show the dropdown.

it is much faster now. the following value from my log file
2026-10-13 15:06:15 : [DONE] ✔ MyModule.g_do_FillListbox - 1.9 ms
2026-10-13 15:06:15 : [DONE] ✔ MyModule.g_do_FillListbox - 0.0 s
2026-10-13 15:06:15 : [DONE] ✔ MyModule.g_do_FillListbox - 0.000 min

Garry

Moving the ComboBox loading until it is needed sounds like it has resolved the delay. Your new timing of 1.9 ms looks good.

You don't need those three properties just to display the column headings:

ColumnSortable enables sorting when a heading is clicked.
SelectionMode controls whether users can select one row or multiple rows.
FrozenColumnCount keeps the leading columns pinned during horizontal scrolling.

If those settings are always the same, you can configure them once when initialising the ListBox. They don't need to be assigned every time you load records. Set up the columns before assigning FrozenColumnCount.

For the headings themselves, your ColumnCount and SetHeaderText() loop are sufficient, with HasHeaders = True. Keep the widths and alignment settings for the appearance you want. RemoveAllRows() is only needed if you have existing rows to clear.

Regarding your comment about freezing, FrozenColumnCount = 2 should freeze both ListBox columns 0 and 1, including a checkbox column if that is column 0. If column 1 still scrolls, could you attach a small project demonstrating it and tell me which Studio version you're using? I'd like to check that separately.

Richard_And_Trisha

Garry ColumnSortable enables sorting when a heading is clicked.
SelectionMode controls whether users can select one row or multiple rows.
FrozenColumnCount keeps the leading columns pinned during horizontal scrolling.

guess I can even do it on opening of the window

Richard_And_Trisha

Garry Regarding your comment about freezing, FrozenColumnCount = 2 should freeze both ListBox columns 0 and 1, including a checkbox column if that is column 0. If column 1 still scrolls, could you attach a small project demonstrating it and tell me which Studio version you're using? I'd like to check that separately.

column 1 is the reference which I want it not to scroll

Garry

Yes, the Window’s Opening event is a good place to set ColumnSortable and SelectionMode if they are always the same.

You can also set FrozenColumnCount there, provided the ListBox columns have already been created. If you create the columns later in your fill method, set it after that column setup.

For the layout you describe, with the checkbox in ListBox column 0 and Reference in ListBox column 1:

p_listbox.FrozenColumnCount = 2

That should keep both columns fixed while the remaining columns scroll horizontally. The count refers to the ListBox columns; the database ID you skip and store in RowTag does not count.

If Reference still scrolls with that arrangement, please send a small project demonstrating it and your Studio version. Your setting looks correct for that layout, so I’d like to investigate why it is not behaving as expected.

Richard_And_Trisha

everything is working now.. I am very happy.

Garry

Glad I could help 🙂

« Previous Page