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.
I guess my question is in the grids is the "KEY" case sensitive? If it is is there a way to make it case in-sensitive?
I am defining unbound columns then assigning a dataset that has matching column names, except in oracle the column names are all uppercase.
No, as I said, the keys of the columns come from the data source. Perhaps you should explore why the field names are all upper case.
they are uppercase becuase that is what Oracle does. :)