I have a datagridview which filters on a boolean field where it's false. If the user clicks on the field, the line disappears immediately I guess because it no longer satisfies the filter. Is there any way to prevent this?
Printable View
I have a datagridview which filters on a boolean field where it's false. If the user clicks on the field, the line disappears immediately I guess because it no longer satisfies the filter. Is there any way to prevent this?
How do you filter the data?
Complete is a boolean field.Code:tblTransactionsBindingSource.Filter = "Complete = False"
So you're saying that the datagridview is not updating immediately after you set the filter property of the binding source? If that is the case, try to call bindingsource.ResetBindings(false) after you set the filter to force the DGV to update.
No. When complete is clicked on the dgv and then something else is clicked, the line disappears. I'd like to prevent that.
Yes that can happen. The attached VS2008 project replicates your issue using xml loaded into a DataTable which becomes the data source of a BindingSource connected to a DataGridView.Quote:
Originally Posted by projecttoday
Work the filter using the button and combobox with the checkbox checked and unchecked. Watch the label under the checkbox for different behaviors i.e. row disappears or the filter auto flips to match the new value of the DataGridView Checkbox column.
In the end if you are filtered on one thing and change the value of a column which does not match the filter then you need to decide if the filter should be completely removed or in this case a Boolean toggle the filter.
Note ignore the other columns other than the first column in the DataGridView.
I'm not getting a project when I open Checkandlink in VB 2008 Express. Is this the solution file?
One option would be to call SuspendBinding on the BindingSource, but that's probably not a good idea. Another option might be change the way you set the Filter. Call the Select method of the DataTable to get all the rows that match your criteria. Create a String containing all their IDs. Create a filter expression that gets records where the ID is IN that list. Now, the records with those IDs will be displayed no matter what changes you make to them. Note that any new rows added will be filtered out though.
Currently when the checkbox is checked, the row does not disappear. It disappears when another row is checked. Then that row disappears when another row is checked. Is there any way to make it so it disappears immediately (as a workaround)?
If you'd read the documentation for the DataGridViewCheckBoxColumn then you'd know why that happens and how to do what you're asking for. I've said it before and I'll say it again: always read the documentation first.Quote:
Originally Posted by projecttoday
Do not know what the problem is as I do not have Express. I created the project at home on VS2008 and then opened it at work from downloading it here in VS2010 no problem.Quote:
Originally Posted by projecttoday