Add array of rows to DataTable

[S. Justin Gengo]

Frank,

I don't know of any way to add an array of rows. I believe that you'll have
to iterate through the array and add each one at a time:

DataTable.Rows.Add(SingleDataRow)

But to clear all rows is pretty easy:

DataTable.Rows.Clear()

Justin


"frank" <frank@frank.com> wrote in message
news:uvZOEEuSDHA.872@TK2MSFTNGP12.phx.gbl...

> How do I add an array of DataRows (i.e. DataRow[]) to a DataTable?
>
> Also, how do I remove all rows from a DataTable?
>
>

[frank]

"S. Justin Gengo" <gengoj@krause.com> wrote in message
news:vh86nleiv5f01a@corp.supernews.com...

> "frank" <frank@frank.com> wrote in message
> news:uvZOEEuSDHA.872@TK2MSFTNGP12.phx.gbl...

> > How do I add an array of DataRows (i.e. DataRow[]) to a DataTable?
> >
> > Also, how do I remove all rows from a DataTable?
> >
> >

> Frank,
>
> I don't know of any way to add an array of rows. I believe that you'll

have

> to iterate through the array and add each one at a time:
>
> DataTable.Rows.Add(SingleDataRow)

OK, I've done that but now it says "This row already belongs to another
table". I know you can't move a DataRow from one collection to another if it
belongs to another - so I tried dtFiltered.ImportRow(dr).

When I do it that way, it appears to add the rows without any problem, but
when it comes to actually referencing and using the data later on.

If I try:

Console.Write(dr[0].ToString() + "\r\n")

It says "Cannot find column 0".

Any ideas?

> But to clear all rows is pretty easy:
>
> DataTable.Rows.Clear()

I tried this to see if it would let me use the Add method, but it didn't
work.

[S. Justin Gengo]

Frank,

If you're referring to the row that was just added to the table then the row
object might get cleared when it's imported. That's my best guess.

Can you refer to it in full? (i.e. DataTableImportedTo.Rows(0)(0).ToString)

Sorry, but I don't know the equivilant in C#. It should be pretty close to
the same though...

Justin


"frank" <frank@frank.com> wrote in message
news:%23INi8XuSDHA.1552@TK2MSFTNGP10.phx.gbl...

> "S. Justin Gengo" <gengoj@krause.com> wrote in message
> news:vh86nleiv5f01a@corp.supernews.com...

> > "frank" <frank@frank.com> wrote in message
> > news:uvZOEEuSDHA.872@TK2MSFTNGP12.phx.gbl...

> > > How do I add an array of DataRows (i.e. DataRow[]) to a DataTable?
> > >
> > > Also, how do I remove all rows from a DataTable?
> > >
> > >

> > Frank,
> >
> > I don't know of any way to add an array of rows. I believe that you'll

> have

> > to iterate through the array and add each one at a time:
> >
> > DataTable.Rows.Add(SingleDataRow)

>
> OK, I've done that but now it says "This row already belongs to another
> table". I know you can't move a DataRow from one collection to another if

it

> belongs to another - so I tried dtFiltered.ImportRow(dr).
>
> When I do it that way, it appears to add the rows without any problem, but
> when it comes to actually referencing and using the data later on.
>
> If I try:
>
> Console.Write(dr[0].ToString() + "\r\n")
>
> It says "Cannot find column 0".
>
> Any ideas?
>

> > But to clear all rows is pretty easy:
> >
> > DataTable.Rows.Clear()

>
> I tried this to see if it would let me use the Add method, but it didn't
> work.
>
>

[frank]

"S. Justin Gengo" <gengoj@krause.com> wrote in message
news:vh88d7ab0hpne0@corp.supernews.com...

> "frank" <frank@frank.com> wrote in message
> news:%23INi8XuSDHA.1552@TK2MSFTNGP10.phx.gbl...

> > "S. Justin Gengo" <gengoj@krause.com> wrote in message
> > news:vh86nleiv5f01a@corp.supernews.com...

> > > "frank" <frank@frank.com> wrote in message
> > > news:uvZOEEuSDHA.872@TK2MSFTNGP12.phx.gbl...
> > > > How do I add an array of DataRows (i.e. DataRow[]) to a DataTable?
> > > >
> > > > Also, how do I remove all rows from a DataTable?
> > > >
> > > >
> > > Frank,
> > >
> > > I don't know of any way to add an array of rows. I believe that

you'll

> > have

> > > to iterate through the array and add each one at a time:
> > >
> > > DataTable.Rows.Add(SingleDataRow)

> >
> > OK, I've done that but now it says "This row already belongs to another
> > table". I know you can't move a DataRow from one collection to another

if

> it

> > belongs to another - so I tried dtFiltered.ImportRow(dr).
> >
> > When I do it that way, it appears to add the rows without any problem,

but

> > when it comes to actually referencing and using the data later on.
> >
> > If I try:
> >
> > Console.Write(dr[0].ToString() + "\r\n")
> >
> > It says "Cannot find column 0".
> >
> > Any ideas?
> >

> > > But to clear all rows is pretty easy:
> > >
> > > DataTable.Rows.Clear()

> >
> > I tried this to see if it would let me use the Add method, but it didn't
> > work.
> >

>
> If you're referring to the row that was just added to the table then the

row

> object might get cleared when it's imported. That's my best guess.
>
> Can you refer to it in full? (i.e.

DataTableImportedTo.Rows(0)(0).ToString)

>
> Sorry, but I don't know the equivilant in C#. It should be pretty close

to

> the same though...

Thanks for the help, but I found and solved the problem.

For archiving purposes, here's what it was:

When I used the ImportRow method it doesn't actually create any DataColumns
in the DataTable and as DataColumns are required to reference the data (even
though it *was* there) I could actually access it.

I resolved the issue by creating the DataColumns first, before using
ImportRow.