How to add multiple rows

Question

As the question says, how can I add multiple rows to a datatable in vb.net? I mean, without looping. F. e. I have an array of datarows and I can then write: dt.Rows.Add(rowarray).

Is this possible? I have searched the net, but found everywhere just looping (or I used the wrong search words).

Create an array of DataRow's and then add them to the DataTable. What have you tried first? — Trevor
– Trevor, Commented Nov 24, 2014 at 18:57

Mark · Accepted Answer · 2014-11-24 20:28:51Z

1

I don't think it's possible - DataRowCollection doesn't seem to have anything like AddRange to hide the looping, although I suppose you could write your own extension method:

Imports System.Runtime.CompilerServices

Module MyExtensions

    <Extension>
    Public Sub AddRange(existing As DataRowCollection, newRows As IEnumerable(Of DataRow))
        For Each row In newRows
            existing.Add(row)
        Next
    End Sub

End Module

And use that in your code:

dt.Rows.AddRange(rowarray)

answered Nov 24, 2014 at 20:28

Mark

8,1701 gold badge16 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to add multiple rows

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related