Developersdex.com - Populate a dataset from datatable or collection or string values

Populate a dataset from datatable or collection or string values
Author: Himanshu Dhami

Rating: Rate this Resource
Visits: 13698

This article shows how you can create a dataset from a collection or pure string values:

Dim custDS As DataSet = New DataSet

Dim ordersTable As DataTable = custDS.Tables.Add("Orders")

Dim orow As DataRow

'set up columns in the results table

ordersTable.Columns.Add("col1", GetType(System.String))

ordersTable.Columns.Add("col2", GetType(System.String))

For Each object In collection

orow = ordersTable.NewRow()

orow("title") = object .Title

//or orow("title")="Test Title"

Visitor Comments

Be the first to rate this article!