Be the first to write a review
Using System.Data.DataSet Part 2
This stand-alone article expands upon the previous article by showing you how to populate a DataTable with other types of Data and how to programmatically insert DataTables into a DataSet. We also cover the DataTable class's Expression property and its Compute method, which make calculating totals from your data much easier. Finally we will see how to save DataSet contents to XML files and then load the XML Data back into a DataSet - a very handy feature when you need to transfer DataSets to another computer, or the same computer at a later date whilst preserving the Dataset’s structure and data.
The following topics are covered in this article:
The following topics are covered in this article:
- Populating a DataTable with other types of Data
- Programmatically Inserting the DataTable into a DataSet
- An introduction to the DataColumn class
- The DataTable Compute method
- Saving DataSet Data as XML Data
- Reloading Saved XML Data into a DataSet
Kevin Marshall
I live in Perth, Scotland and am senior programmer with WebXeL.com Ltd. I have been involved in computer programming since 1990, web based programming using ASP since 1997 and have been building ASP.NET applications since ASP.NET Beta 2 was released.
I have been an avid Dreamweaver user since Version 1 was launched and with the release of MX have moved into developing extensions. WebXeL run a website dedicated to the development of free and commercial Dreamweaver MX extensions for ASP.NET, the site can be found at http://www.webxel-dw.co.uk.