Hi,
I'm using a SQL server 2005 case insensitive database for my program.
I populated DataTables in a DataSet with DataAdapters with a select * command for each table in the Database. (I set DataTable.CaseSensitive & DataSet.CaseSensitive to false)
Then I added DataRelations to the DataSet to represent the foreign keys.
This all seems to work ok.
But when I bind my usercontrols to the DataSet with the DataSource property, and the specified DataTable with the DataMember property, the List in the CurrencyManager for that control only contains items that would have been there in a case sensitive situation.
For example, say you have a table called 'Parent', with column: 'parent_name', and another table called: 'Child' with columns: 'parent_name', 'child_name' with a foreign key from Child.parent_name to Parent.parent_name.
I bind 2 GridViews to the 2 tables, and select 1 row in the master ('Parent') gridview.
Now, in the case where parent_name is equally 'cased' in both tables, there is no problem and i can see the rows in the gridview. But when there is a situation like: Parent.parent_name = 'John' but Child.parent_name = 'JOHN' that child won't appear in the gridview.
I've set all the CaseSensitive properties on the DataTables to false, as well as on the DataSet, but it doesn't seem to work.
I couldn't find a solution in the documentation, so I hope someone can help me.
Many thanks in advance!
Greetings,
Sander