C# Adding dynamic column and rows in Datatable

Question

I tried to add values to DataTable columns by vertically in loops.

But output doesn't looks good as expected.

DataTables dynamictable = new DataTable()
foreach (DataColumn cl in dataTable.Columns)
{
   dynamictable.Columns.Add(cl.ToString());
   List<string> plainList = dataTable.AsEnumerable().Select(x => x[cl].ToString()).ToList();

   for (int i=0; i< plainList.Count(); i++)
   {
       DataRow row = dynamictable.NewRow();
       row[cl.ToString()] = plainList[i];   
       enryptedTable.Rows.Add(row);
   }
}

Actual Output got from my code:

enter image description here

Expected Output:

enter image description here

Related: Append a column to an existing Datatable with dynamically bound values and How can I dynamically add colums and rows to an empty dataset? — user12031933
– user12031933, Commented Aug 5, 2021 at 7:53

persian-theme · Accepted Answer · 2021-08-05 21:44:53Z

2

change your code to :

DataTable dynamictable = new DataTable();
int col = 0;
foreach (DataColumn cl in dataTable.Columns)
{
    dynamictable.Columns.Add(cl.ToString());
    List<string> plainList = dataTable.AsEnumerable().Select(x => x[cl].ToString()).ToList();
    DataRow row = null;
    for (int i = 0; i < plainList.Count(); i++)
    {
       row = dynamictable.NewRow();
       row[col] = plainList[i];
       dynamictable.Rows.Add(row);
    }
    col++;
}
//now set dynamictable to datagridview or .....

edited Aug 5, 2021 at 21:44

answered Aug 5, 2021 at 16:39

persian-theme

6,6483 gold badges9 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

C# Adding dynamic column and rows in Datatable

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related