how to change or replace all column name in data table

Question

I am retrieving table from data base and storing in data table.

I need to change column name into new column name in data table I tried below code but its not changing..where I made mistake....

             foreach (DataColumn column in obj_dt.Columns)
             column.Caption = column.ColumnName.Replace("Tax","new tax");

             foreach (DataGridViewColumn gridColumn in dataGridView_dataGridView_curt_Prd_Dtls.Columns)
             gridColumn.HeaderText = obj_dt.Columns[gridColumn.HeaderText].Caption;

             dataGridView_dataGridView_curt_Prd_Dtls.DataSource = obj_dt;

score 0 · Accepted Answer · edited May 23 '17 at 11:59

0

Please Check the link below will helps you in finding your answer

How to rename the datatable column name without losing the data?

Why DataColumn.Caption doesn't work?

edited May 23 '17 at 11:59

Community

1
1

answered Dec 14 '13 at 17:32

Sajid Hussain

63
2
10

how to change or replace all column name in data table

1 Answers1