RenameColumn
Rename a code that allows only stating the current name column and a new name.
Source
public static void RenameColumn(this System.Data.DataTable dt, string oldName, string newName)
{
if (dt != null && !string.IsNullOrEmpty(oldName) && !string.IsNullOrEmpty(newName) && oldName != newName)
{
int idx = dt.Columns.IndexOf(oldName);
dt.Columns[idx].ColumnName = newName;
dt.AcceptChanges();
}
}
Example
// Consider that dataSetName is the DataSet that contains a DataTable
dataSetName.Tables[0].RenameColumn("Column1", "Name");
dataSetName.Tables[0].RenameColumn("Column2", "Email");
dataSetName.Tables[0].RenameColumn("Column3", "RegistrationDate");
Author: Raphael Augusto Ferroni Cardoso
Submitted on: 4 jun. 2014
Language: C#
Type: System.Data.DataTable
Views: 5148