Default DataColumn.Colu mnName Property?

[bordsby]

Situation:
I am using an OleDbDataAdapte r to fill a DataSet's DataTable with data
from an Access database. The DataSet's DataTable is bound to a
DataGrid. After the OleDbDataAdapte r.Fill method is called, the
DataGrid displays the column headings as the column names output from
the Access SQL query. I would like to change some of the styles for
certain columns in the DataGrid, so I first need to set the
DataGridColumnS tyle.MappingNam e Property of each DataGridColumnS tyle.
According to the .NET docs, "The MappingName property is usually set to
the ColumnName of a DataColumn."

Question:
What is the ColumnName Property of a DataColumn equal to when the
DataColumn is automatically created as a result of the
OleDbDataAdapte r? Is it equal to the column heading string?

[Bart Mermuys]

Hi,

"bordsby" <bo*****@gmail. com> wrote in message
news:11******** ************@o1 3g2000cwo.googl egroups.com...

Situation:
I am using an OleDbDataAdapte r to fill a DataSet's DataTable with data
from an Access database. The DataSet's DataTable is bound to a
DataGrid. After the OleDbDataAdapte r.Fill method is called, the
DataGrid displays the column headings as the column names output from
the Access SQL query. I would like to change some of the styles for
certain columns in the DataGrid, so I first need to set the
DataGridColumnS tyle.MappingNam e Property of each DataGridColumnS tyle.
According to the .NET docs, "The MappingName property is usually set to
the ColumnName of a DataColumn."

Question:
What is the ColumnName Property of a DataColumn equal to when the
DataColumn is automatically created as a result of the
OleDbDataAdapte r? Is it equal to the column heading string?

ColumnName is the name of the column as it appears in the query if you use
DataAdapter.

DataColumn:
- ColumnName : the name of the column as it appears in the query (if you
used DataAdapter)
- Caption : returns ColumnName unless it has been set to something else

If the DataGridColumnS tyles are auto-generated then:
- MappingName = DataColumn.Colu mnName
- HeaderText = DataColumn.Colu mnName

so that's why the HeaderText in the grid is the same as the column names in
your query.

If you create the column styles yourself, then you have to set MappingName
and HeaderText yourself. MappingName should be set to one of the
DataColumn's ColumnName and HeaderText can be set to whatever you want.
HTH,
Greetings

[bordsby]

Thank you for the clarification.

If the query uses an "AS" qualifier like

SELECT column AS [A Column Name With Spaces]

Will the spaces mess anything up? I don't think so since it wants a
string, but just to clarify....

[Bart Mermuys]

Hi,

"bordsby" <bo*****@gmail. com> wrote in message
news:11******** *************@z 14g2000cwz.goog legroups.com...

Thank you for the clarification.

If the query uses an "AS" qualifier like

SELECT column AS [A Column Name With Spaces]

Will the spaces mess anything up? I don't think so since it wants a
string, but just to clarify....
DataColumn.Colu mnName will be 'the column name with the spaces', it
shouldn't cause any problems. Though some people prefer not to use column
names or aliases that have spaces and do the formatting later (eg.
DataGridColumnS tyle.HeaderText ).
HTH,
Greetings

[bordsby]

That seems like a better idea anyway, then I don't need the aliases...

I really appreciate the help.