I use PowerShell Studio 2021 5.8.196.0 (64bits) on Windows 10 64bits
On my projet, then the form is loaded i populate the CheckedListBox2 with data getting from Postgresql database.
- #Affichage des accessoires
- try
- {
- $result_all_Accessories = Get-ODBC-Data -query $query_SC_All_Accessories
- #create a datatable to bind to our combobox
- $datatable_result_all_Accessories = New-Object system.Data.DataTable
- #Define Columns
- $col1_result_all_Accessories = New-Object system.Data.DataColumn "Value", ([string])
- $col2_result_all_Accessories = New-Object system.Data.DataColumn "Text", ([string])
- $col3_result_all_Accessories = New-Object system.Data.DataColumn "Price", ([double])
- $col4_result_all_Accessories = New-Object system.Data.DataColumn "Provider", ([string])
- $col5_result_all_Accessories = New-Object system.Data.DataColumn "Type", ([string])
- #add columns to datatable
- $datatable_result_all_Accessories.columns.add($col1_result_all_Accessories)
- $datatable_result_all_Accessories.columns.add($col2_result_all_Accessories)
- $datatable_result_all_Accessories.columns.add($col3_result_all_Accessories)
- $datatable_result_all_Accessories.columns.add($col4_result_all_Accessories)
- $datatable_result_all_Accessories.columns.add($col5_result_all_Accessories)
- foreach ($row1_result_all_Accessories in $result_all_Accessories)
- {
- $row_result_all_Accessories = $datatable_result_all_Accessories.NewRow()
- $row_result_all_Accessories.Text = (($row1_result_all_Accessories.$column_SC_Accessories) + " ( " + $row1_result_all_Accessories.$column_SC_Accessories_Price + " $Global_Currency_Code )")
- $row_result_all_Accessories.Value = $row1_result_all_Accessories.sc_it_Accessoriesid
- $row_result_all_Accessories.Price = $row1_result_all_Accessories.$column_SC_Accessories_Price
- $row_result_all_Accessories.Provider = $row1_result_all_Accessories.$column_SC_Accessories_Providers
- $row_result_all_Accessories.Type = $row1_result_all_Accessories.$column_SC_Accessories_Types
- $datatable_result_all_Accessories.Rows.Add($row_result_all_Accessories)
- }
- $checkedlistbox2.ValueMember = "Value"
- $checkedlistbox2.DisplayMember = "Text"
- $checkedlistbox2.DataSource = $datatable_result_all_Accessories
- }
- catch { }
- $checkedlistbox2_ItemCheck = [System.Windows.Forms.ItemCheckEventHandler]{
- #$Script:items = $checkedlistbox2.CheckedIndices #DOES NOT RETRIEVE THE CORRECT INDEX IF THERE ARE FILTERING ITEMS
- $Script:items = $checkedlistbox2.CheckedItems
- }