“Unable to cast object of type 'System.Data.DataTable' to type 'System.Data.IDataReader'” to Strongly Typed DataSet

<< Delete All Files & Folders from Parent that are older then X Days | Slow Remote Desktop >>

“Unable to cast object of type 'System.Data.DataTable' to type 'System.Data.IDataReader'” to Strongly Typed DataSet

December 16, 2010 at 11:18 AM — Fred Mastro

Unable to cast object of type 'System.Data.DataTable' to type 'System.Data.IDataReader'

When you try and set a Strongly Typed DataTable to another DataTable.

Use .Merge on your strongly typed dataset to correct this problem.

Dim dsCallData As YourStronglyTypedDataSet
Dim dsCallInfoQueriedFromDB As New DataTable

'... code here to populate dsCallInfoQueriedFromDB from database ...

dsCallData.dtCallInfol.Merge(dsCallInfoQueriedFromDB)

11bae14f-1250-46c3-b093-58e69f5cccc9|0|.0

Posted in: VB.NET

Tags:

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...Casting Types in VB.Net and MoreSource: Cheat Sheet - Casting in VB.NET and C# Great little find, and since I’m a VB.Net whore, I’l...Expression Blend 3 – SketchFlow – Creating PrototypesI’ve been dying to try and use SketchFlow with Expression Blend 3. I do a lot of development d...

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).

Twitter

February 10. 19:46
Works!

October 3. 23:20
CT6-MultilingualSupport - FredMastro's library http://t.co/RPkOym7w

May 19. 09:58
New blog post: http://tinyurl.com/6jvcxnb - Getting Out of Memory Exception when you have plenty of Memory/RAM available

April 1. 14:11
Blizzard announces StarCraft with Kinect: http://slashdot.org/submission/1516828/

April 1. 12:56
New blog post: http://tinyurl.com/42ys5e6 - The Add-in ‘xxxx' failed to load or caused an exception in SQL Management Studio

Follow me

	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.

Fred Mastropasqua My site of .Net blogs and more.

Highlights

Other FredMastro Sites