This is the first I have run into this. Is there a way to turn the behavior off? Grid is populated with needdatasource event.
If a column name in my datatable is "SuperMan", the column header in the grid is displayed as "Super Man" (note the space in front of "M"). If the column name in my database is "superman" then the column header in the grid is "superman". Is there some option where I can turn off renaming my column headers? We capitalize for readability, but need the names to stay in tact so users can do excel lookups.
This particular page returns a variety of different datatables with different formats, most approx 50 columns wide so my preference is to not build lots of pages with predefined column headers to work around this.