Solved : Cannot add a DataRelation or Constraint that has different Locale or CaseSensitive settings between its parent and child tables.

Many days ago, I was implementing parent-child relation in windows DataGridView using adding relation in DataSet among two DataColumns of two different DataTables and I faced below error.

Error Message :

Cannot add a DataRelation or Constraint that has different Locale or CaseSensitive settings between its parent and child tables.

Solution:

I found alternate solution from internet but below solution works for me fine. Its due to two datatable Locale property has different value. If you are going to add relationship then Locale of two datatable must be same. 

Mistake:

1) tblCustomer DataTable Properties:

2) tblOrder DataTable Properties: