Append one datatable to another? 1

[CraigBest]

Hi Folks

I have two datasets from separate queries. The two tables have the same structure, what I want to do is combine them into one table which I can then assign to a grid control.

How can I do this? Either appending one into the other is fine, or both into a third table is fine.

Thanks!

CraigHartz


CraigHartz

 

[pmegan]

Hey Craig

I've always done it row by row, something like this (untested):

[green]' copy all rows from table(1) into table(0)[/green]
Dim iCnt As Integer
Dim dr As DataRow

  With ds.Tables(1)
    For iCnt = 0 To .Rows.Count - 1
      dr = .NewRow
      dr = .Rows(iCnt).ItemArray.Clone
      ds.Tables(0).Rows.Add(dr)
    Next
  End With
End Sub

If anybody knows an easier or more efficient way of doing it I'd like to find out about it.

Pat

 

[MacLeod72]

If the 2 datasets are identical, you should be able to do:

ds1.Merge(ds2)

This should add the rows of "ds2" to "ds1".

Hope this helps!

--Rob

 

[pmegan]

Rob,

Do the tables have to be in the same dataset or will that work on standalone tables too?

Thanks,
Pat

 

[MacLeod72]

I have only used it to merge 2 datasets, but MSDN says that a Dataset, Datatable, or array of Datarows can be used. Here is the link (for .Net 1.1):

http://msdn2.microsoft.com/en-us/library/system.data.dataset.merge(vs.71).aspx

Hope this helps!

--Rob

 

[CraigBest]

Thanks Rob, that did the trick! A nice, simple solution. I'll write that one down!

CraigHartz


CraigHartz

 

[MacLeod72]

Glad to help!

--Rob