Making the first row in a DataTable the name of the columns

Question

I´m trying to set the first row of a DataTable to be the column names. I´m using a GenericParsing library from Code Project. The problem is that the parser sets a default name for the columns.

Thanks.

Answer 1

I think you need the following:

foreach (DataColumn column in table.Columns)
{
    string cName = table.Rows[0][column.ColumnName].ToString();
    if (!table.Columns.Contains(cName) && cName != "")
    {
         column.ColumnName = cName;
    }

}

table.Rows[0].Delete(); //If you don't need that row any more

Answer 2

This should do what you want:

DataRow firstRow = table.NewRow();
List<string> names = new List<string>();
foreach (DataColumn column in table.Columns)
{
    names.Add(column.ColumnName);
}
firstRow.ItemArray = names.ToArray();
table.Rows.InsertAt(firstRow, 0);

If the first row already exists and you want to "overwrite" this change the first line to:

DataRow firstRow = table.Rows[0];

And remove the last line.