How to merge multiple dataviews into one?

Question

I have three dataviews (dataview1, dataview2, and dataview3). These are of type System.Data.DataView, and all three have the same columns. Is there an easy way to merge them into one, so I have one dataview with rows from dataview1, followed by dataview2, and then dataview3?

score 11 · Accepted Answer · answered Sep 30 '11 at 17:53

11

Dim dataview1 As DataView = new DataView()
Dim dataview2 As DataView = new DataView()

'' given the tables are not null you can then merge like this

dataview1.Table.Merge(dataview2.Table)

answered Sep 30 '11 at 17:53

Dennis Traub

50,557
7
93
108

Thanks, I guess I somehow missed that! – Prabhu Sep 30 '11 at 17:59
1

Please flag as "Answered" if this is what you were looking for. Thanks :) – Hanlet Escaño Sep 30 '11 at 18:04
Afaik this will not really merge the DataViews but the underlying Tables, ie all RowFilters will be ignored. – TaW May 03 '18 at 08:04

score 3 · Answer 2 · edited May 03 '18 at 08:56

3

DataTable datatableMerge = dataview1.ToTable();
datatableMerge.Merge(dataview2.ToTable());

The result includes only the rows according to the the DataViews' Filters.

edited May 03 '18 at 08:56

TaW

53,122
8
69
111

answered Mar 02 '15 at 17:15

Yang CC

31
2

FYI, This only works if the dataviews have the same columns. – MatthewD Apr 12 '19 at 16:39

How to merge multiple dataviews into one?

2 Answers2

Linked