Merging DataTables

<< Setting Focus in ASP.Net | Convert Hex Color to System.Drawing.Color in VB.Net >>

Merging DataTables

25. March 2009

Read this article in your language IT | EN | DE | ES

Public Sub MergeDataTables(source as DataTable, destination As DataTable)   

  destination.BeginLoadData()   

  

  For i As Integer=0 To source.Rows.Count - 1

    destination.LoadDataRow(source.Rows(i).ItemArray,True)

  Next

  

  destination.EndLoadData()  

End Sub

Reference: by All-Star at http://forums.asp.net/p/1075389/1578419.aspx

240aa62f-6dfa-402c-b2c4-c78331d5cf7b|1|5.0

Programming, VB.NET vb.net, datatables, net

Mapping a DataTable to an Object Class. Like a homemade Linq to SQL. Send over WCF to SilverLightApplication Foundation An application I work has architecture in a way where we have a Class object...

Add comment

Name*
E-mail* (Will show your Gravatar icon)
Website
Country Country flag

Captcha*

b i u quote

Comment
Preview

Notify me when new comments are added

About the author

A Certified MCSE (NT4 & 2k), MCDBA (2k), A+, CCA, with over 10 years of experience with Windows Networking and Development. Developing mainly in ASP.NET, VB.NET and T-SQL. Also develops in Objective-C (iPhone), XAML (SilverLight & WPF), C#, "Classic" ASP 3.0, ADSI, VBscript, WScript.

Non-technical hobbies include other areas such as Movie watching (action, epic, comedy, some romantic comedy, well everything), Reading (Science Fiction, Fantasy, Detective and Programming categories), Film Editing, Directing with Special effects (using Adobe Premiere and Adobe After Effects), Dungeons & Dragons (D&D 4th Edition), Auto-Cross Racing & Cars (BMW M3, MazdaSpeed's), Motorcycles (Honda CBR 600), TV Shows (Flight of the Conchords, Lie To Me, Dollhouse, BattleStar Galatica, Smallville, Alias), Music (Akon, Billy Joel, Micheal Bublé, Bid Daddy Weave, T-Pain, Barlow Girl, Notorious B.I.G and more, love all types of music), and Religion (Christianity, debating and prophecies).

Highlights

	Some websites I've worked on. This is a small collection of sites I've developed or added to awhile back.

	Revenge Movie Trailer. Trailer I made with Adobe Premiere and After Effects. Jason Christman is the main star and I'm the director behind the camera.

	Essential Software For your Mac. - I'm a Microsoft geek, but I've switched over to Mac. There was a lot of stuff I needed to get installed that I missed on my Windows machine. Also I had no idea how to do it :p Here's some help.

	Speed Football. I wanted to make a special effect like the Smallville or Superman running fast. All the other ones I've seen, the person in the frame was the only moving object while everything else was blurred. I wanted to create the effect but interact with another normal moving object.

	Code Snippets and Quickies. Sometims I find something or develop something that I think is useful and it can be copied and pasted anywhere for someone to use. Here's a collection of things I've posted on.

Twitter

July 23. 16:51
New blog post: http://tinyurl.com/22s83w7 - I hate my phone 3G – This is how it works now… ever since OS4 upgrade

July 23. 10:08
New blog post: http://tinyurl.com/2ee4yye - $35 laptop prototype or something from India coming soon!

July 21. 18:44
Was in Vegas and ATT couldn't handle my calls or txt's. Full bars and no calls, txt's taking up to a minute to send. Congested!? #ATTFAIL

July 14. 10:54
New blog post: http://tinyurl.com/2w3bczk - When Faced with the Facts, You’ll hold on to your misbelieves even more.

July 6. 12:59
New blog post: http://tinyurl.com/2b3ggdv - nCore.cc Invite? Anyone?

Follow me

Fred Mastropasqua

Merging DataTables