Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Re: .Net Dataview vs. Using Database View

Thread Tools

Re: .Net Dataview vs. Using Database View

Lucas Tam
Posts: n/a
"=?Utf-8?B?TWlrZSBNb29yZQ==?=" <(E-Mail Removed)>
wrote in news:(E-Mail Removed):

> 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

..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 ((E-Mail Removed))
Please delete "REMOVE" from the e-mail address when replying.
Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Database Database Database Database Computer Information 0 09-27-2012 02:43 AM
DataBase DataBase DataBase DataBase Computer Information 0 09-26-2012 09:40 AM
Sorted DataView, but unsorted datalist when bound to the dataview CodeMonkey ASP .Net 1 02-04-2011 10:55 AM
Re: .Net Dataview vs. Using Database View Manohar Kamath [MVP] ASP .Net 0 09-22-2004 09:49 PM
.Net Dataview vs. Using Database View =?Utf-8?B?TWlrZSBNb29yZQ==?= ASP .Net 0 09-22-2004 08:53 PM