473,320 Members | 1,933 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

DataSet OR Dataview

hi,
I have a three tier application, I have a method in the datalayer which
should either return a (dataset or dataview or datrow), i need to know which
should be the best possible option, are there any links or documents which
can help me understand.

Thanx in advance.

Prasad
Jul 21 '05 #1
2 1361
I don't know about specific articles, but there is one thing that we
learned the hard way that you you might want to know about. Dataset and
DataTable objects are serializable while DataView and DataRow objects
are not. If you are planning on crossing process boundaries (as when
you have physically separate tiers) you'll get non-serializable errors
unless you take special steps on your own to deal with this issue.

Have A Better One!

John M Deal

Prasad Patil wrote:
hi,
I have a three tier application, I have a method in the datalayer which
should either return a (dataset or dataview or datrow), i need to know which
should be the best possible option, are there any links or documents which
can help me understand.

Thanx in advance.

Prasad

Jul 21 '05 #2
In order for a DataView to be of any use, it needs a reference to a
DataTable. You can always create a view locally, but as John mentioned,
Views aren't serializable so that's going to take a lot of fun out of trying
to remote them.

Go with a DataTable/DataSet

--
W.G. Ryan MVP (Windows Embedded)

TiBA Solutions
www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
"John M Deal" <jo******@necessitysoftware.com> wrote in message
news:#l**************@TK2MSFTNGP12.phx.gbl...
I don't know about specific articles, but there is one thing that we
learned the hard way that you you might want to know about. Dataset and
DataTable objects are serializable while DataView and DataRow objects
are not. If you are planning on crossing process boundaries (as when
you have physically separate tiers) you'll get non-serializable errors
unless you take special steps on your own to deal with this issue.

Have A Better One!

John M Deal

Prasad Patil wrote:
hi,
I have a three tier application, I have a method in the datalayer which
should either return a (dataset or dataview or datrow), i need to know which should be the best possible option, are there any links or documents which can help me understand.

Thanx in advance.

Prasad

Jul 21 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Arthur Dzhelali | last post by:
I according to MSDN dataview and dataset are thread safe for read operations, but we run into this scenario. I just would like to see some comments on it. Aplication written in VB.NET it is an...
4
by: suzy | last post by:
hello. how can i sort data in a dataset? all the examples i have seen on msdn, etc are sorting a dataview. this works fine, but i want to return the results in xml and the dataview doesn't...
1
by: Arjen | last post by:
Hi, What are the main differences between a dataset and a dataview? What should I cache dataset or dataview... or what is the best thing to do in what situation? Thanks! Arjen
2
by: Dennis | last post by:
Hi, I am hoping I can get some help with a small problem I have run into using C#. U have an XML file that I load into a Dataset and then display this in a Datagrid. No problems doing this at all....
13
by: Lars Netzel | last post by:
hi! myDataSet that is fillled from an Access 2000 db and includes ONE table From that Table in myDataSet I create myDataView and use a Rowfilter to get a few rows that i work with (i need a...
0
by: Bob Davies | last post by:
Hi I have a webservice that retrieves data from a database, this is then returned to the calling client application built in windows forms within a dataset, however upon attempting to create...
17
by: A_PK | last post by:
I have problem databinding the DataGrid with DataView/DataSet after the filter... I create the following proceudre in order for user to filter as many as they want, but the following code is only...
3
by: Freeon | last post by:
Hi, I am looking for a way to sort a strong typed dataset. It would seem the most straightforward way is to use a dataview. The only problem is when I use the dataview I seem to loose the strong...
1
by: rn5a | last post by:
I was using a DataView to bind records from a DB table to a DataGrid using the following code: Dim sqlDapter As SqlDataAdapter Dim dSet As DataSet Dim dView As DataView sqlDapter = New...
11
by: Sid Price | last post by:
I have Dataset that I need to filter into another Dataset for display and I can not find out how to do this. I have found methods for copying a Dataset but I can not see how to filter the rows...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.