How to Insert New Row Into Existing DataTable While Looping DataTable

[Kelvin]

Dear All,

Please help.
Same as subject !!!

[Lowell Heddings]

Kelvin wrote:

Dear All,

Please help.
Same as subject !!!

Inserting a new row is the same whether you are looping or not.

DataTable dt = new DataTable();
DataRow row = dt.NewRow();
row["columnname"] = "whatever";
dt.Rows.Add(row);
dt.AcceptChanges();

If you are looking for something more specific to your situation, then
you need to post some code.

Lowell

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

No really, if you are iterating a collection you cannot change it, or you
may get an exception.

IIRC I had a similar problem but with removing instead of adding, solution:
Use an ArrayList to keep the rows that you will add
after the loop add all the rows from the ArrayList into the datatable.
Cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Lowell Heddings" <lo****@mindjunction.com> wrote in message
news:Oc**************@TK2MSFTNGP14.phx.gbl...

Kelvin wrote:

Dear All,

Please help.
Same as subject !!!

Inserting a new row is the same whether you are looping or not.

DataTable dt = new DataTable();
DataRow row = dt.NewRow();
row["columnname"] = "whatever";
dt.Rows.Add(row);
dt.AcceptChanges();

If you are looking for something more specific to your situation, then you
need to post some code.

Lowell

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

Use an ArrayList while you are looping and later add them to the table

Cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Kelvin" <ke*******@gmail.com> wrote in message
news:db*************************@posting.google.co m...

Dear All,

Please help.
Same as subject !!!

[Nicholas Paldino [.NET/C# MVP]]

Ignacio,

Wouldn't it be easier to do this?

// Get the number of rows.
// dt is the data table.
int rows = dt.Rows.Count;

// The data row.
DataRow row;

// Cycle
for (int index = 0; index < rows; ++index)
{
// Get the row.
row = dt.Rows[index];

// Add row if necessary.
}

This way, you avoid an extra loop, and you prevent processing of the
added rows.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Ignacio Machin ( .NET/ C# MVP )" <ignacio.machin AT dot.state.fl.us> wrote
in message news:%2****************@TK2MSFTNGP12.phx.gbl...

Hi,

Use an ArrayList while you are looping and later add them to the table

Cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Kelvin" <ke*******@gmail.com> wrote in message
news:db*************************@posting.google.co m...

Dear All,

Please help.
Same as subject !!!