Table Row into Colums

[baburk]

I am having a dataset with one table.
I want to copy to another table by making the first row of the table as columnheaders for the new table.

The dataset may be the same of different.

How can I.

Help please.

[demaus]

So you want to create a new data table (dtData2) using the data in the first row of the first table of a dataset (dsDataSet) as the column names for the new data table (dtData2)

Assuming that dsDataSet 's first row of data is something like this

Col1            Col2         Col3             Col4
Name         Address     Address2     City
 

 
Dim dsDataSet as DataSet
Dim dtData2 as New DataTable
 
For Each dcCol as DataColumn In dsDataSet.Tables(0).Columns
 
Using dcNew as New DataColumn(dcCol.ColumnName) 'This creates a new column with a name of the columns from the dataset
 
' Here you can set other things about the column: DataType, Caption, etc...
 
' then add the column to the new datatable
dtData2.Columns.Add(dcNew)
 
End Using
End Next
 
 

When all is done then dtData2 will have four columns with Column Names of : Name, Address, Address2, City.

hope this is what you wanted or at least helps.

[baburk]

Thanks for your reply.

It helped me