There is a boolean(bit) field in your database, hence the grid automatically generates a Data Grid View Check Box Column. Only the set method of one of them (the first one) is called, while visually in the datagridview, both actions cause check-mark.You are trying to save all changes that the user has made when he clicks a save-button. All you have to do is to update your dataset/datatable with the dataadapter. Sorry I didn't confirm exactly all your questions: It's a Winforms application, Sql Server Express datasource.So it seems the cell validation does not work on a per-cell basis, but on a per column basis (For the checkboxcolumn). It is not really clear what you have tried and what doesn't work. I don't autogenerate columns, but I specify with Columns. The thing is, I put a breakpoint on the Set method of the property (in dbml file), so I notice when it is called.
Still, it doesn’t make much sense when we think about the way Check Box’s work, in that, they can only ever be On or Off, and that once you have made your selection, you’re probably pretty confident that you want to change the value.It turns out that this is trickier than it might seem and doesn’t work great out of the box from .NET, but, not to fear, there are several easy work-arounds that will get the trick done. Further, let’s say that you’d like to know as soon as the user has made a change to their selection.You might want to handle this for a number of reasons: to enable a save button, to change the appearance of selected items, to display a pop-up window, or to check for consistency against other choices.