Re: .Net Dataview vs. Using Database View

"=?Utf-8?B?TWlrZSBNb29yZQ==?=" <>
wrote in news:FFD6AD7A-1CEA-4DBA-AC19-:

> Is there any real differences to using the .Net dataview over using a
> sql server database view?

Yes, a SQl Server view is more efficent for large datasets than a .NET
dataview.

..NET dataviews are applied on data downloaded to a client - so if you wish
to filter a large table, the entire table must be downloaded to the client.

It comes down to several factors whether to use a SQL view or .NET dataview
such as the size of the dataset, the response time required, the type of
data you're filtering against, etc.
--
Lucas Tam ()
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

Lucas Tam