While Trying to help my wife find material regarding dynamically creating tables at runtime, I stumbled across a very nice group of articles, All about Dataset helper Classes doinf various cool things with the dataset. I heartly recommend reading this and getting some ideas. I Havn't really combed through all of it but it looks promising. (btw, they all have a VB.NET example as well)
Here's a snip of it.
"
HOW TO: Implement a DataSet SELECT DISTINCT Helper Class in Visual C# .NET | |
This step-by-step article illustrates how to implement and how to use a DataSetHelper class that includes sample code to create a DataTable object that contains the unique values of a column of another DataTable object. To do this, you use the... | |
HOW TO: Implement a DataSet CREATE TABLE Helper Class in Visual C# .NET | |
This step-by-step article describes how to implement and how to use a DataSetHelper class that includes sample code to create a table from a comma-delimited list of field names and data types. This article includes a second method so that you can also... | |
HOW TO: Implement a DataSet SELECT INTO Helper Class in Visual C# .NET | |
This step-by-step article describes how to implement and how to use a DataSetHelper class that includes sample code to create a DataTable object from an existing DataTable definition and to copy records that are sorted and filtered from the source... | |
HOW TO: Implement a DataSet JOIN helper class in Visual C# .NET | |
This step-by-step article describes how to implement and how use a DataSetHelper class that includes sample code to create a DataTable object from two or more related DataTable definitions and to copy records that are sorted and filtered from the... |