preventing two controls that bound to the same table from sharing same data

Introduction

There is a simple problem faced by many developers, when there are two controls on a form which are bound to the same tables. Suppose there are two combobox on a form having same bound tables. If one user selects a value in one of them it will be automatically selected to other control also.

The reason for this is by default all controls share forms bindingcontext, to prevent it simply change the bindingcontext of one of the control to new context

this.comboBox1.BindingContext= new BindingContext();