Search code examples
c#.netdatacolumn

Why DataColumn.Caption doesn't work?


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;

Solution

  • 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;
    }