I have a wingrid that has a datasource being set to it.
the field names of the grid are the same as in my MS SQL database.
however when I switch to a oracle database, the fieldnames are all in caps.
I am option compare text on, everywhere.
I am using vs2008 and ultragrid ver 8.2.20082.1000
what is happening is all the field names are showing in the grid. not the ones I setup but what is in the dataset. Is there some compare option in the grid that I am missing. It should be case-insensitive.
I'm not sure I understand the issue. You cannot change the Key of a bound column. The key of the column comes from the data source. If the data source has field names that are all in caps, then so will the grid. There's no way around this.
You can change the caption of the grid column by using the column.Header.Caption property. So you can label the columns with more user-friendly text. But you can't change the actual key on the grid level - it can only be changed on the data source itself.
I have preset the grid with unbound columns.
Example:
ID (hidden)
ProfileID (hidden)
ProfileName
these are inthe "KEY" setting
WHen I bind a MSSQL dataset, it returns the field names exactly like above.
However Oracle returns the field names in all uppercase.
So when the dataset is bound to the grid i get
ID (visible)
PROFILEID (VISIBLE)
PROFILENAME(VISIBLE)
that is the problem I face.