My issue is basically the same one posted in the following post:
http://forums.infragistics.com/forums/p/20698/74609.aspx#74609
In my application I bring over data from a database and display it in my WinGrid. The data could be entered in lower or upper case depending on how the user input it into the database. The problem is that when the data is in mixed case the WinGrid does not want to show the data that has been entered in uppercase.
A colleague of mine created a mini-project to illustrate this issue. He created a dataset with 2 tables and a data relation and added several records to each table. One of the records added to the child table was added with an uppercase value. This record does not show in the second band, but it is accessible via ADO GetChildRows(). This suggests that it's a WinGrid issue and not an ADO issue. I've attached the project to this post.
We have tried using the CaseSensitive property on the DataTable to make this work but it doesn't appear to be the correct option. How can I get the wingrid to display my data when it's in a mixture of cases?
Thank you!
Steve
Hi Steve,
I'm not sure I follow you. This doesn't sound like the same issue as the other thread at all. That issue was talking about UltraDropDown matching values in a case-sensitive manner. But you seem to be suggestion that you are missing rows of data from your grid based on the case of that data.
I don't see how the casing of the data could possibly affect whether or not that data displays in the grid. The contents of a cell are pretty much opaque to the grid.
Hi Mike,
You are right. The link I pasted in does not really sound like my issue at all. It was probably the closest I could find to my issue while searching the forums while not exactly being the same. I should've said that instead of saying it was the same. My apologies ...
Did you happen to look at the test mini-project I attached? Why would the ADO side of .Net be able to see and access the row that has the data value in uppercase but then the grid not display that line? That is truly the mystery here. If you have any other suggestions, please let me know.
Thanks again!