Hello binding experts!
I would like to bind a custom property of a UserControl to a typed DataSet.
My scenario:
On the form there is a DataGridView control
Its DataSource is pointing to a BindingSource
The BindingSource is pointing to a Typed DataSet
My UserControl has a property also bound to the DataSet through the BindingSource.
So far this works great. When I navigate the rows in the grid, the UserControl gets (or sets) the column value for the row.
Now for the problem:
When navigating the rows, the dataset is being marked as changed for the rows I select, even if I make no changes to the data.
When I do a similar binding with a TextBox or DateTimePicker it does not update the dataset when navigating. It's only when I bind to my custom property that it marks the dataset row as being changed.
How do I fix this so I can navigate without actually modifying the dataset?
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
You can restrict any necessary coding to the user control itself. If, when you do its binding, you set the Data Source Update Mode to "Never" you can override that using WriteValue if the relevant value is actually changed by the user rather than just what is displayed having been changed by navigation. Here's the relevant help links
http://msdn2.microsoft.com
http://msdn2.microsoft.com
Otherwise, so far as I can see, the change to the bound property's value that is caused by the navigation itself is seen as a change by the binding manager and so passed as a change (even if it is only re-writing the existing value) to the dataset.
Roger
Business Accounts
Answer for Membership
by: SanclerPosted on 2005-12-27 at 02:29:05ID: 15554774
As a guess, I think you might be able to overcome it by calling the binding manager's .CancelCurrentEdit method at the start of your navigation code. But, if you do that, you will also need to add some code to check if any change (as opposed to just navigation) has been made and, if so, skip the .CancelCurrentEdit line.
I say "as a guess" because I haven't actually seen this happen, and am not at the moment in a position to experiment to try and make it happen.
Roger