Copying rows between two data views

[asifmaniar]

I have to copy rows from one data view to another. Fot this am using the following loop and each time creating a new row. But somehow in the final result the resultatt view only has one new row. The loop actually runs for each added row but only the last row is actually added. Any suggestions? Am copying rows from view2 to view.... For i = 0 To view2.Count - 1 view.AllowNew = True Dim dv As DataRowView 'adding the new row dv = view.AddNew() ' copying each column value For j = 0 To view.Table.Columns.Count - 1 dv(j) = view2.Item(i).Item(j) Next dv = nothing Next no matter how many times the above loops get executed only the last row is added :(