print an entire table in C#

Question

I'm trying to print the content of a DataTable, starting with the column headers, followed by the content of the table tupples.

output.Add($"Table : [{dataTable.TableName}]");
string strColumnNames = "";
foreach (DataColumn col in dataTable.Columns)
{
    if (strColumnNames == "")
         strColumnNames = col.ColumnName.PadLeft(col.MaxLength - col.ColumnName.Length);  // (*)
    else strColumnNames = strColumnNames + "|" + 
                          col.ColumnName.PadLeft(col.MaxLength - col.ColumnName.Length);  // (*)
}
output.Add($"[{strColumnNames}]");


foreach (DataRow dataRow in dataTable.Rows)
{
    string temp = "";
    for (int i = 0; i < dataRow.ItemArray.Count(); i++)
    {
        if (i == 0)
            temp = dataRow.ItemArray[i].ToString();                          // (**)
        else temp += "|" + dataRow.ItemArray[i].ToString();                  // (**)
    }
    output.Add($"[{temp}]");
}

The (*) parts in this code are using the MaxLength property of the DataColumns maximum length in order to get a column-like output.

I would like to do the same in the (**) parts, but I don't know how to access the corresponding DataColumn, starting from the dataRow object.

Does anybody have an idea?
Thanks in advance

No need to start from dataRow if you use dataTable... dataTable.Columns[i].MaxLength — Stephan Bauer
– Stephan Bauer, Commented Nov 8, 2021 at 12:58
What is output ? Won't you simplify the process by converting the DataTable to a CSV string before outputing it ? — Steve B
– Steve B, Commented Nov 8, 2021 at 17:17

Petter Hesselberg · Accepted Answer · 2021-11-08 12:58:36Z

4

You already have the dataTable instance available. dataTable.Columns[i] should give you the appropriate DataColumn.

answered Nov 8, 2021 at 12:58

Petter Hesselberg

5,5983 gold badges29 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Arun_Raja1 · Accepted Answer · 2021-11-08 13:04:38Z

1

Datatable has already been instantiated here. If you want to print the datacolumn you should use dataTable.Column[i] for the appropriate column.

answered Nov 8, 2021 at 13:04

Arun_Raja1

2851 silver badge1 bronze badge

Collectives™ on Stack Overflow

print an entire table in C#

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related