ADO.NET: Is it possible to create a dataset out of a view?
Database
1
Posts
1
Posters
0
Views
1
Watching
-
I have a dataset displayed in a particular view with some sorting. For some specific reasons I want to create a new dataset from this dataview so that the new dataset will have it's rows in actual physical sorted sequence just as in the view. How do i do it? One solution will be to iterate through the view's rows and create a new dataset of your own in the same sequence within a foreach loop. But I feel it's not that 'graceful'. Rakesh