VB.net copy object (dataview)

Question

I have been trying to create a copy of an object but it appears to be linked in some way. Here is an example

Dim dataview as DataView = results.DefaultView

' Some amazing foreach loop
' but thoughtout the loop I want to create a copy of the data and then filter it

Dim filterView as DataView = dataview
filterView.RowFilter = "County = '" & loop.County &"'"

The plan is to then loop through this subset of data but when I debug the project the data contained within dataview is the same as filterView. I have tried DirectCast() and still get the same result. How do I create a copy of the object without creating some link to the original object?

Hope this makes sense but let me know if you need any further clarification.

Joe · Accepted Answer · 2013-09-10 15:48:27Z

2

Use Clone method to copy the table structure (Schema). Use the ImportRow method to copy from table to its clone. OR You can use the Copy method of a DataTable object to copy the entire DataTable: OR Copy from the results of a DataView.

http://support.microsoft.com/kb/308909

answered Sep 10, 2013 at 15:48

Joe

1,67912 silver badges10 bronze badges

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

1 Comment

Matt Over a year ago

Thanks, I ended up using .Copy() as I couldn't be bothered to copy the data in!

Collectives™ on Stack Overflow

VB.net copy object (dataview)

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related