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

Question

I want to rename my DataTable column names.

I tried this:

dt.Columns[8].ColumnName = "regnum";

dt.AcceptChanges();

but my data is lost afterwards.

Answer 1

dt.Columns[8].ColumnName = "regnum";

This just binds your Columns[8] to the non-existing "regnum" column in the Db.

If you want to rename the actuals Db column, execute an SQL script.

But my guess is you actually want to change the Caption:

  dt.Columns[8].Caption = "regnum";