creating dataset from datarowcollection

[Matt Tapia]

I have a datarow collection (drAccountInfo), and I want to add each row to a
datatable that is then added to a dataset...here is my code:

Dim iCount As Integer
Dim myDataTable As New DataTable

For iCount = 0 to drAccountInfo.Length-1
Trace.Warn(iCount)
myDataTable.ImportRow(drAccountInfo(iCount))
Next iCount

Dim myDataSet As New DataSet
myDataSet.Tables.Add(myDataTable)
myDataSet.WriteXML("C:\inetpub\wwwroot\myapp\myfile.xml")

Everytime I run it, I get a blank dataset, but I know there is data in the
datarow collection. What gives?

 

[Grzegorz Danowski]

I have a datarow collection (drAccountInfo), and I want to add each row to
a datatable that is then added to a dataset...here is my code:

Dim iCount As Integer
Dim myDataTable As New DataTable

For iCount = 0 to drAccountInfo.Length-1
Trace.Warn(iCount)
myDataTable.ImportRow(drAccountInfo(iCount))
Next iCount

Why don't you use merge method? For example:
myDataSet.Merge(drAccountInfo)

Hope it helps.
Grzegorz

 

[Matt Tapia]

It works! Thanks!

Why don't you use merge method? For example:
myDataSet.Merge(drAccountInfo)

Hope it helps.
Grzegorz