Merging data between an Untyped and Typed Dataset

[wsyeager]

Does anybody know how you can merge data from an Untyped Dataset into a specific table of a Strongly Typed Dataset?

Check out the following function:
<code>


Public Function GetCustomerss() As dstCustomers

Try

Dim dst As New DataSet

Dim tablenames() As String = {"Customers"}

SqlHelper.FillDataset(SqlDataAdapter1.SelectCommand, dst, tablenames)

DstCustomers1.Merge(dst)

Catch ex As Exception

Throw (ex)

Finally

SqlDataAdapter1.Dispose()

SqlConnection1.Close()

End Try

Return DstCustomers1

End Function
</code>

Suppose that dataset "DstCustomers1" has two tables in it (Customers and Orders). When you perform the following code,
<code>


DstCustomers1.Merge(dst)
</code>
if DstCustomers1 has only one table, it will perform the merge with no problem. However, how can you specifically merge the contents of the Untyped dataset into a specific table of DstCustomers1 (like into the Customers or Orders table)?

 

[wsyeager]

Possible solution

The only thing I can think of that would accomplish this is the following code:

<code>
Dim dr As DataRow
For Each dr In dst.Tables(0).Rows
DstCustomers1.Customers.ImportRow(dr)
Next
</code>

If anyone has anything more efficient, just let me know....