Adding empty rows to a DataTable

Question

Is it possible to add a few rows to a DataTable with a single call?

The issue is that I need to create a DataTable where each column requires a previous processing before being written into the DataTable. Writing row by row would be inconvenient.

I.e., I need to create a DataTable with N empty rows and later write values in a column basis.

Answer 1

You cannot add multiple rows without loops. If you want to add n rows to a DataTable where all columns are "empty" use DataRowCollection.Add without arguments:

for(int i = 0; i < n; i++)
    table.Rows.Add();  // all fields get their default value

Answer 2

in your for loop, (obviously needs a forloop to add multiple rows), you want to use

for(int i = 0; i < n; i++)
    table.Rows.Add();   

if you know what you want to put in the row, you can tweak this code:

DataRow newBlankRow = theDataTable.NewRow();
theDataTable.Rows.InsertAt(newBlankRow, theDataTable.Rows.Count);