This post originated from an RSS feed registered with .NET Buzz by John Papa. Original Post: DataTable Becomes a Real Boy in ADO.NET 2 Feed Title: John Papa Feed URL: /error.htm?aspxerrorpath=/blogs/john.papa/rss.aspx Feed Description: .NET Code Samples, Data Access, Patterns and Other Musings Latest .NET Buzz Posts Latest .NET Buzz Posts by John Papa Latest Posts From John Papa

I am really excited about some of the new features in ADO.NET 2. I posted here last month regarding how the ADO.NET 2 DataTable class will expose a Merge method (woo hoo!). I found this very useful when I had DataTable's to merge but no DataSet (and thus had to create a DataSet just to merge the DataTable objects -- yuk!)

Anyway, there are other situations where I had a DataTable sans a DataSet and I had to create a DataSet just to take advantage of some features it had that the DataTable didn't. In ADO.NET 2, a lot of attention appears to have been paid to the DataTable as it now has many of the features of the DataSet. For example, in ADO.NET 2 you can get the following method on a ADO.NET 2 DataTable that were formerly only available in a DataSet:

• Merge
• ReadXml
• ReadXmlSchema
• WriteXml
• WriteXmlSchema

I never liked how the DataTable did not have the xxxXml method in its arsonal. But at least the next incarnation of ADO.NET will have incldued many of the features that the DataSet already has ... a bit of catch-up, I guess.

I'm very excited about the ability to create a DataTable from a DataView, the DataTable's new GetDataReader method, the fact that I can now change the DataRow.RowState manually, and the plethora of other features as well! I'm having fun putting together some code samples for VSLive, MSDN Magazine and my codebetter.com blog on these cool ADO.NET 2 features!