Why DataColumn.Caption doesn't work?

c# .net datacolumn
Alex P. picture Alex P. · Jan 10, 2013 · Viewed 22k times · Source

I am trying to create a DataTable and bind it to a DataGridView. It works, but I can't set columns headers via the Caption property. It displays headers using the ColumnName ("City") instead. MSDN says that

"You can use the Caption property to display a descriptive or friendly name for a DataColumn."

Here is my code:

DataColumn dc = new DataColumn("City", typeof(string));
dc.Caption = "Город"; 

DataTable dt = new DataTable();
dt.Columns.Add(dc); 

DataRow row = dt.NewRow(); 
row["City"] = "Moscow";
dt.Rows.Add(row);

datagridview.DataSource = dt;

Answer

aquinas picture aquinas · Jan 10, 2013

Well, MSDN is right. That is what the Caption property is for. However, that doesn't mean that control makers have to use the caption property. In this case, Microsoft didn't do that (although they really should have). You can modify your code to this though:

///snip

dataGridView1.DataSource = dt;

foreach (DataGridViewColumn col in dataGridView1.Columns) {
  col.HeaderText = dt.Columns[col.HeaderText].Caption;
}

Related questions

DataColumn Name from DataRow (not DataTable)

I need to iterate the columnname and column datatype from a specific row. All of the examples I have seen have iterated an entire datatable. I want to pass a single row to a function to do a bunch of …

Read More
Create ADO.NET DataView showing only selected Columns

In C# & .NET, can one create a DataView that includes only a proper subset of the DataColumns of a given DataTable? In terms of relational algebra, one assigns a RowFilter in order to perform a "selection" operation (σ). How would …

Read More
Best way add a new column with sequential numbering in an existing data table

I have a non empty datatable . What is the best way to add another column to it that has sequential numbering starting from 1. I tried the following code. But did not work. DataColumn dc = new DataColumn("Col1"); dc.AutoIncrement = true; …

Read More