How to merge multiple dataviews into one?

.net asp.net vb.net ado.net dataview
Prabhu picture Prabhu · Sep 30, 2011 · Viewed 7.6k times · Source

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?

Answer

Dennis Traub picture Dennis Traub · Sep 30, 2011 
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)

Related questions

how to configure smtp settings in web.config

I'm trying to fix an email issue with an inherited website and don't have access to the code (i.e. just the compiled files). This site needs to be hosted on a new web server having a different smtp server. …

Read More
URL Routing, Image Handler & "A potentially dangerous Request.Path value"

I've been experiencing this problem now for quite sometime and have decided to try and get to the bottom of it once and for all by posting the question here for some thought. I have an image handler in a .…

Read More
.NET Configuration (app.config/web.config/settings.settings)

I have a .NET application which has different configuration files for Debug and Release builds. E.g. the debug app.config file points to a development SQL Server which has debugging enabled and the release target points to the live …

Read More