DataSet OR Dataview

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Prasad Patil

    #1

    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
  • John M Deal

    #2
    Re: DataSet OR Dataview

    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:[color=blue]
    > 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[/color]

    Comment

    • W.G. Ryan eMVP

      #3
      Re: DataSet OR Dataview

      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" <johndeal@neces sitysoftware.co m> wrote in message
      news:#ltceMVxEH A.2876@TK2MSFTN GP12.phx.gbl...[color=blue]
      > 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:[color=green]
      > > 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[/color][/color]
      which[color=blue][color=green]
      > > should be the best possible option, are there any links or documents[/color][/color]
      which[color=blue][color=green]
      > > can help me understand.
      > >
      > > Thanx in advance.
      > >
      > > Prasad[/color][/color]


      Comment

      Working...