I have a DataGridView control on my form which is bind to a local database.
The grid contains a checkbox column.
The application allows the user to perform some queries on the datagridview control in order to "filter" data.
The problem is, that the checkboxes are shown as checked only when the datagridview shows the whole table from the database (ie, no select statements). If the user performs a query on the table, then even if the checkboxes are checked - they won't look like they are indeed checked.
Why is this happening and how can this be solved?
Thanks in advance!